N858AS
Service difficulty reports not matched to an aircraft · 141
They name N858AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. Newest first.
Query with SQL
duckdb -csv -c "SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N858AS' AND registry_match IS NULL ORDER BY difficulty_date DESC"
Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT sdr_id, difficulty_date, n_number, aircraft_make, aircraft_model, part_name, part_condition, jasc_code, discrepancy FROM 'https://openairdocs.org/data/latest/faa_service_difficulty_report.parquet' WHERE n_number = 'N858AS' AND registry_match IS NULL ORDER BY difficulty_date DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
SDR TRAX200800303Frame · corrodedFUSELAGE FRAME AT FS 349.0 HAS CORROSION AT BL 0. REMOVED CORROSION, DAMAGE FOUND WITHIN LIMITS IAW SRM 51-21-06.SDR TRAX200800302Fitting · crackedAAR - BATH TUB FITTING AT FS 461, RBL 9, CRACKED. REMOVED UNSERVICEABLE BATH TUB FITTING . LOCATED HOLES IN NEW FITTING, IAW SRM 51-42-11. OK TO INSTALL INSTALLED NEW SERVICEABLE FITTING PER SRM 51-42-21. OK TO FILLET SEAL AND TOUCH-UP FINISH. APPLIED FILLESDR TRAX200800301Frame · corrodedAAR - FUSELAGE FRAME AT FS 333.0 HAS CORROSION BL 0 TO LBL 9.
SDR TRAX200800300Fitting · crackedAAR - FS 484 CLIP CRACKED I/B LBL 27.
SDR TRAX200800299Fitting · crackedAAR - FS 484 CLIP CRACKED I/B RBL 27.
SDR TRAX200800311Attach Angle · crackedRT WHEEL WELL I/B BATT RIB ATTACH ANGLE CRACKED
SDR TRAX200800287Attach Fitting · crackedFS 280 ATTACH FITTING O/B RBL 9 CRACKED. REMOVED CRACKED FS 280 ATTACH FITTING. FABRICATED AND INSTALLED SERVICEABLE ATTACH FITTING IAW SRM 51-42-21.SDR TRAX200800286Attach Fitting · crackedFS 280 ATTACH FITTING O/B LBL 9 CRACKED. REMOVED CRACKED F/S 280 ATTACH FITTING. FABRICATED AND INSTALLED SERVICEABLE ATTACH FITTING IAW SRM 51-42-21.SDR TRAX200800285Angle · crackedFS 280 AFT ANGLE CRACKED O/B OF LBL 9. PERFORMED REPAIR TO FS 280.0 AFT ANGLE IAW REO 601R-53-11-136. REV A. COMPLIED WITH EO 600-53-0091.SDR TRAX200800284Web · crackedAAR - FS 280 LOWER WEB CRACKED O/B OF RBL 9 (MARKED).
SDR TRAX200800283Angle · corrodedAAR - FS 280 FWD FLOOR ANGLE BETWEEN LBL 9.0 & RBL 9.0 HAS MINOR SURFACE CORROSION. REMOVED FWD FLOOR ANGLE TO FACILITATE CORROSION REMOVAL. REMOVED MINOR CORROSION TO 0.003" ON FWD FLOOR ANGLE AT F.S. 280.0 LBL9 TO RBL9. RETURNED TO FINISH CODE A023. WORK SDR TRAX200800247Sign · missingSIGN MISSING ON LEFT OF PAX DOOR.SDR TRAX200701015Flashlight · inoperativeCAPT'S, F/O'S, AND F/A'S FLASHLIGHT INOP AND DIM.SDR TRAX200700917Door · obstructedPAX DOOR WILL NOT CLOSE, IT GETS 18 INCHES FROM AIRFRAME AND STOPS.SDR TRAX200700647Light · inoperativeFLOOR PROXIMITY LIGHTING INOP ROW 10-14. FLT 4129 DEL 40 MINS. ELECTROLUMINESCENT FLOOR PROXIMITY EMERGENCY ESCAPE PATH MARKING SYSTEM.SDR TRAX200700568Light · inoperativeFLOOR EMERGENCY LIGHTS AFT OF OVERWING EXIT ARE INOP. FLT 4722 DEL 165 MINS.SDR TRAX200700232Door · unknownPAX DOOR HARD TO OPEN.SDR TRAX200700197Warning Message · activatedHYD SYS 2 LO PRESS MSG, HYD SYS 2 QTY INDS ZERO. EN ROUTE TO HSV, A/C DIVERTED TO GSO DUE TO MTC. EMERGENCY DECLARED. FLTS 4539, 4586 CX.SDR TRAX200700074Light · inoperativeFOUND FWD EMERGENCY EXTERIOR OVERWING EXITING LIGHTS INOP. BOTH SIDES.SDR TRAX200600942Anchor Fitting · crackedASD FWD ANCHOR FITTING APPEARS TO BE CRACKED.SDR TRAX200600559Yoke · vibrationAT AN ALTITUDE OF 10000 FT, FELT A VIBRATION ON THE LEFT YOKE. WITH A AIRSPEED OF 290 KIAS. RECEIVED A TURN TO CAE AND ON THE APPROACH WITH THE AUTOPILOT OFF IT HAPPENED AGAIN. A/C RETURNED TO CAE AFTER T/O, EMERGENCY WAS DECLARED, FLTS 4321, 4586 CX.SDR TRAX200600450Warning Message · illuminatedNWS INOP MSG AFTER TAKEOFF COMPLIED WITH QRH, LANDED WITH NWS OFF, FLT 4613 DEL 63 MINS (AN EMERGENCY WAS DECLARED).SDR TRAX200600386Bracket · crackedDURING FRAME 640 INSP, FOUND RIGHT RE-ENFORCEMENT BRACKET CRACKED AT 640 FRAME.SDR TRAX200600049Smoke Warning · illuminatedSMOKE CARGO MESSAGE IN FLIGHT... A/C RETURNED TO ATL AFTER T/O... A/C SWAP TO 699, FLT 4552 DEL 114 MINS (AN EMERGENCY WAS DECLARED)SDR ASOA04668Fitting · crackedDURING A C-CHECK IN MCN, THE AFT CABLE ANCHOR FITTING ON THE PASSENGER DOOR WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE AFT CABLE ANCHOR FITTING ON THE PASSENGER DOOR. (M)SDR ASOA04665Clip · crackedDURING A C-CHECK IN MCN, THE CLIPS AT FS 484, LBL 27 AND LBL 36 AND RBL 36 WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REMOVING AND REPLACING THE CLIP AT FS 484, LBL 27 AND REPAIRING THE CLIPS AT FS 484, LBL 36 AND RBL 36 IAW ASA EO 600-53-0098. (SDR ASOA04663Plate · crackedDURING A C-CHECK IN MCN, THE CARGO DOOR FLOOR LANDING PLATE AT FS 589 AND FS 605 WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE CARGO DOOR FLOOR LANDING PLATE AT FS 589 TO FS 605 IAW ASA EO 600-53-0117. (M)SDR ASOA04662Floor Support · crackedDURING A C-CHECK IN MCN, THE LEFT AND RIGHT FLOOR SUPPORT ANGLES AT FS 21 IN THE CARGO COMPARTMENT WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE IS REPAIRING THE LEFT AND RIGHT FLOOR SUPPORT ANGLES AT FS 621 IAW ASA EO 600-53-0105. (M0SDR ASOA04673Step · crackedDURING A C-CHECK IN MCN, THE TOP STEP ON THE PASSENGER DOOR WAS FOUND BROKEN. MAINTENANCE REPAIRED THE TOP STEP ON THE PASSENGER DOOR IAW SRM 51-74-00. (M)SDR ASOA04265Lamp · burned outFLT 4887 - DUIRNG A GROUND INSPECTION IN DFW, THE OVERHEAD EMERGENCY LIGHTS AT ROWS FIVE AND FOURTEEN WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE OVERHEAD EMERGENCY LIGHT LAMPS AT ROWS FIVE AND FOURTEEN. OPS CHECKS GOOD. AIRCRAFT OK FSDR ASOA04159Step · crackedDURING HANGAR MAINTENANCE IN MCN, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND CRACKED. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. OPS CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA04093Lamp · inoperativeDURING A GROUND INSPECTION IN ATL, THE RIGHT REAR EMERGENCY EXIT LIGHT WAS FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE RIGHT REAR EMERGENCY EXIT LIGHT LAMP. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03413Step · crackedDURING A GROUND INSPECTION IN ATL, THE BOTTOM STEP ON THE PASSENGER DOOR WAS FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REMOVED AND REPLACED THE BOTTOM STEP ON THE PASSENGER DOOR. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03349Handle · lack of lubeFLT 4236 - DURING A GROUND INSPECTION IN ATL, THE MAIN PASSENGER DOOR WOULD NOT OPEN FROM OUTSIDE WITH THE HANDLE. MAINTENANCE LUBRICATED THE MAIN PASSENGER DOOR HANDLE. OPERATIONAL CHECKS GOOD. AIRCRAFT OK FOR SERVICE. (M)SDR ASOA03208Fire Loop · inoperativeFLT 4766 - DURING CLIMB-OUT DFW-AUS, THE CREW RECEIVED A LEFT ENGINE 14TH STAGE DUCT MESSAGE AT APPROXIMATELY 14,000 FEET. QRH AND EMERGENCY PROCEDURES WERE COMPLIED WITH. THE AIRCRAFT RETURNED TO DFW, LANDING SAFELY. MAINTENANCE REMOVED AND REPLACED THE LESDR ASOA03116Bracket · crackedDURING HANGAR MAINTENANCE IN MCN, THE LEFT AND RIGHT ANGLE BRACKETS BELOW THE ENGINE SUPPORT BEAM WERE FOUND TO BE CRACKED BEYOND LIMITS. MAINTENANCE REPAIRED THE LEFT AND RIGHT ANGLE BRACKETS BELOW THE ENGINE SUPPORT BEAM IAW SRM 51-00. (M)SDR ASOA02650Light · inoperativeFLT 4042 - DURING GROUND INSPECTION IN DFW, THE EMERGENCY FLOOR TRACK LIGHTING BETWEEN ROWS 2 THROUGH 5 WERE FOUND TO BE INOPERATIVE. MAINTENANCE REMOVED AND REPLACED THE EMERGENCY FLOOR FLEXIBLE LAMP STRIP BETWEEN ROWS 2 THROUGH 5. OPERATIONAL CHECKS GOOD. SDR ASOA02197SFitting · crackedDURING HANGAR MAINTENANCE IN MCN, THE RIGHT WING FITTING WAS FOUND TO BE CRACKED. MAINTENANCE REMOVED AND REPLACED THE RIGHT AILERON INBOARD CLOSURE RIB IAW SRM 51-00. (M)SDR ASOA02197Fitting · crackedDURING HANGAR MAINTENANCE IN MCN, THE RIGHT WING FITTING WAS FOUND TO BE CRACKED. MAINTENANCE WILL REPLACE THE RIGHT WING TRAILING EDGE RIB. (M)SDR ASOA02077Windshield · crackedFLT 4423 - DURNG DESCENT INTO OMA, THE FIRST OFFICERS WINDSHIELD CRACKED. NO EICAS MESSAGE WAS RECEIVED, BUT THE WINDSHIELD FELT COLD. THE CAPTAIN REPORTED ALL HEAT SWITCHES WERE IN THE CORRECT POSITIONS. AIRCRAFT LANDED SAFELY IN OMA. MAINTENANCE REMOVED SDR ASOA01027Windshield · crackedFLT 4496 - CAPTAINS FRONT WINDSHIELD CRACKED WHILE ON THE GROUND AFTER FLIGHT FROM DFW TO CHS. MAINTENANCE REMOVED AND REPLACED CAPTAINS FRONT WINDSHIELD. HEATING AND PRESSURIZATION TESTS WERE GOOD. AIRCRAFT RETURNED TO SERVICE. (M)
Back to N858AS