N192US, cancelled Jul 21, 2023
Service difficulty reports · 40
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N192US' AND deregistration_id = 'N192US-2023-07-21' 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 = 'N192US' AND deregistration_id = 'N192US-2023-07-21' 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 Y2PA2021021821006Gearbox · leakingCREW REPORTED THAT IN CRUISE AT FL 340, RT OIL PRESSURE LOW LIGHT CAME ON, GAUGE INDICATIONS BACKED UP LIGHT INDICATION, OIL PRESSURE ZERO, OIL TEMP WENT TO ZERO, OIL QUANTITY DROPPED FROM 16 QTS TO APPROX.. 5 QTS. THEY PERFORMED COM PROCEDURE THROUGH PRECAUTISDR Y2PA2017092500002Skin · corrodedMAINTENANCE FOUND CORROSION ON THE SKIN AT BS 313, LONGERON 26R - 29L. REPAIRED THE SKIN IAW DRAWING 53-171010-2, PAGES 1-2, AND EA 17-53-332.SDR Y2PA2017092500001Skin · corrodedMAINTENANCE FOUND CORROSION ON THE SKIN FROM BS 699 - 718, LONGERONS 24 - 29R. REPAIRED IAW DRAWING 53-171010-1, REV A, AND EA 17-53-331 R1.SDR Y2PA2017051200001Warning System · false activationCREW REPORTED CABIN PRESS WARNING LIGHT ILLUMINATED IN THE CLIMB. DONNED O2 MASKS, DECLARED AN EMERGENCY, AND LANDED BACK AT AIRPORT WITHOUT FURTHER INCIDENT. MAINTENANCE PERFORMED OPS CHECK ON THE NR 2 AC PACK SYSTEM IAW AMM 21-31-1, OPS CHECK GOOD. PRESSURIZSDR Y2PA2015060200028Oxygen System · leakingCREW REPORTED A LOSS OF PRESSURIZATION AT FL250, REQUIRED OXYGEN MASKS AND A DESCENT TO 10,000 FEET. AN EMERGENCY WAS DECLARED DUE TO THE NEED OF THE OXYGEN MASK AND DIVERSION TO A SUITABLE AIRPORT. ABNORMAL AND NORMAL CHECKLIST WERE COMPLETED AND NORMAL LANSDR Y2PA2015052900027Generator · inoperativeAT CRUISE ALTITUDE, EXPERIENCED AN ELECTRICAL PROBLEM, AC CROSS-TIE LOCKOUT. LEFT GENERATOR BUSS FAILURE. CREW PERFORMED APPLICABLE COM PROCEDURE TO MITIGATE ELECTRICAL MALFUNCTION. ATC ADVISED THAT THERE NO ALTITUDE READ OUT FROM ACFT AND IN RESPONSE CREW SDR Y2PA20141124046Lug · crackedDURING C CHECK, DISCOVERED A CRACKED NLG RETRACT CYLINDER ATTACH LUG. REPLACED THE NLG ASSEMBLY IAW DC9 AMM 32-21-1.SDR Y2PA20141124045Frame · crackedDURING C CHECK, DISCOVERED A CRACKED RT FUSELAGE FRAME AT STATION 964. REPAIRED THE CRACKED RT FUSELAGE FRAME AT STATION 964 IAW DC9 SRM 51-70-5 FIG 1.SDR Y2PA20141124044Door Frame · crackedDURING C CHECK, DISCOVERED A CRACKED VENTRAL DOOR LT VERTICAL FRAME WEB. REPLACED THE CRACKED VENTRAL DOOR LT VERTICAL FRAME WEB IAW DC9 SRM 51-30-2 & 51-30-5.SDR Y2PA20141124043Attach Angle · crackedDURING C CHECK, DISCOVERED A CRACKED VENTRAL DOOR LT VERTICAL FRAME SKIN ATTACH ANGLE. REPLACED THE CRACKED VENTRAL DOOR LT VERTICAL FRAME SKIN ATTACH ANGLE IAW DC9 SRM 51-30-2 & 51-30-5.SDR Y2PA20141124042Floorbeam · corrodedDURING C CHECK, DISCOVERED A CORRODED MAIN DECK FLOORBEAM UPPER CHORD AT STATION 351 RBL 42. REPLACED CORRODED MAIN DECK FLOORBEAM UPPER CHORD AT STATION 351 RBL 42 IAW DC9 SRM 53-02 FIG 20A.SDR Y2PA20141124041Seat Track · corrodedDURING C CHECK, DISCOVERED A CORRODED SEAT TRACK FROM STATION 474 - 576 LBL 45. REPLACED CORRODED SEAT TRACK FROM STATION 474 - 576 LBL 45 IAW DC9 SRM 51-30-2 & 51-30-5.SDR Y2PA20141124040Longeron · crackedDURING C CHECK, DISCOVERED A CRACKED LONGERON 27L BETWEEN STATION 642 - 690. REPLACED CRACKED LONGERON 27L BETWEEN STATION 642 - 690 IAW DC9 SRM 51-30-1 & 51-30-5.SDR Y2PA20141124039Doubler · crackedDURING C CHECK, DISCOVERED A CRACKED APB DOUBLER AT STATION 820 BETWEEN LONGERON 7R - 7L. REPLACED CRACKED APB DOUBLER AT STATION 820 BETWEEN LONGERON 7R - 7L IAW DC9 SRM 51-30-2 & 51-30-5.SDR Y2PA20141124038Seat Track · corrodedDURING C CHECK, DISCOVERED A CORRODED SEAT TRACK FROM STATION 550 - 766 RBL 5. REPAIRED CORRODED SEAT TRACK FROM STATION 550 - 766 RBL 54 IAW DC9 SRM 53-05 FIG 4D.SDR Y2PA20141124037Seat Track · corrodedDURING C CHECK, DISCOVERED A CORRODED SEAT TRACK FROM STATION 550 - 766 RBL 54. REPAIRED CORRODED SEAT TRACK FROM STATION 550 - 766 RBL 54 IAW DC9 SRM 53-05 FIG 4D.SDR Y2PA20141124036Spar · crackedDURING C CHECK, DISCOVERED A CRACKED LT ELEVATOR FRONT SPAR STATION XE-71. REPAIRED THE CRACKED LT ELEVATOR FRONT SPAR STATION XE-71 IAW DC9 SRM 55-02 FIG 9.SDR Y2PA20141124035Floorbeam · corrodedDURING C CHECK, DISCOVERED A CORRODED MAIN DECK FLOORBEAM AT STATION 237 RBL 42. REPAIRED CORRODED MAIN DECK FLOORBEAM AT STATION 237 RBL 42 IAW DC9 SRM 53-05 FIG 20A.SDR Y2PA20141124034Skin · damagedDURING C CHECK, DISCOVERED A DAMAGED FUSELAGE SKIN AT STATION 942 AT LONGERON 16L. REPAIRED DAMAGED FUSELAGE SKIN AT STATION 942 AT LONGERON 16L IAW DC9 SRM 53-01 FIG 4.SDR Y2PA20141124033Longeron · damagedDURING C CHECK, DISCOVERED A DAMAGED LONGERON 22R AT STATION 235. REPAIRED DAMAGED LONGERON 22R AT STATION 235 IAW DC9 SRM 53-02 FIG 18.SDR Y2PA20141124032Frame · corrodedDURING C CHECK, DISCOVERED A CORRODED FUSELAGE FRAME AT STATION 256 AT LONGERON 30. REPAIRED CORRODED FUSELAGE FRAME AT STATION 256 AT LONGERON 30 IAW DC9 SRM 53-05 FIG 5.SDR Y2PA20141124031Frame · corrodedDURING C CHECK, DISCOVERED A CORRODED FUSELAGE FRAME AT STATION 389 AT LONGERON 30. REPAIRED CORRODED FUSELAGE FRAME AT STATION 389 AT LONGERON 30 IAW DC9 SRM 53-05 FIG 5 & 51-30-2.SDR Y2PA20141124030Frame · corrodedDURING C CHECK, DISCOVERED A CORRODED FUSELAGE FRAME AT STATION 465 BETWEEN LONGERONS 29L & 29R. REPAIRED CORRODED FUSELAGE FRAME AT STATION 465 BETWEEN LONGERONS 29L & 29R IAW DC9 SRM 53-03 PARA 1C.SDR Y2PA20141124029Longeron · corrodedDURING C CHECK, DISCOVERED A CORRODED LONGERON 18L BETWEEN STATION 480 - 505. REPAIRED CORRODED LONGERON 18L BETWEEN STATION 480 - 505 IAW DC9 SRM 51-30-2 & 51-30-5.SDR Y2PA20141124028Frame · corrodedDURING C CHECK, DISCOVERED A CORRODED AFT CARGO PIT FRAME AT STATION 786 BETWEEN LONGERONS 29L & 28R. REPAIRED CORRODED AFT CARGO PIT FRAME AT STATION 786 BETWEEN LONGERONS 29L & 28R IAW DC9 SRM 53-03 PARA 1C.SDR Y2PA201411240027Intercostal · corrodedDURING C CHECK, DISCOVERED A CORRODED INTERCOSTAL AT BS 160 RBL 11. REPAIRED IAW SRM 51-70-5 & 51-30-5.SDR Y2PA2014112400027Intercostal · corrodedDURING C CHECK, DISCOVERED FUSELAGE FRAME CORRODED BS 738 BETWEEN LONGERONS 25 & 26L. REPAIRED THE FRAME IAW SRM 53-03 FIG 2A.SDR Y2PA20141124026Frame · corrodedDURING C CHECK, DISCOVERED A CORRODED FUSELAGE FRAME AT STATION 738 BETWEEN LONGERONS 25L & 26L. REPAIRED CORRODED FUSELAGE FRAME AT STATION 738 BETWEEN LONGERONS 25L & 26L IAW DC9 SRM 53-03 FIG 2A.SDR Y2PA20141124025Door Sill · corrodedDURING C CHECK, MAINTENANCE DISCOVERED A CORROSION ON MCD CUT OUT LOWER SILL FROM STATION 301.5 - 410. INSTALLED REPAIR ON MCD CUT OUT LOWER SILL FROM STATION 301.5 - 410 IAW DER 8110-3 & DWG 53301424-1.SDR Y2PA20141124024Skin · corrodedDURING C CHECK, DISCOVERED A CORRODED SKIN FROM STATION 680 - 720 BETWEEN LONGERONS 23L - 28L INSTALLED REPAIR BETWEEN STATION 680 - 720 BETWEEN LONGERONS 23L - 28L IAW DER 8110-3 & DWG 53301423-1.SDR Y2PA20141124023Seat Track · corrodedDURING C CHECK, DISCOVERED A CORRODED SEAT TRACK FROM STATION 236 - 280 RBL 54. REPAIRED CORRODED SEAT TRACK FROM STATION 236 - 280 RBL 54 IAW DC9 SRM 51-30-2 & 51-30-1.SDR Y2PA20141124022Intercostal · crackedDURING C CHECK, DISCOVERED A CRACKED INTERCOSTAL AT STATION 160 RBL 22. REPAIRED CRACKED INTERCOSTAL AT STATION 160 RBL 22 IAW DC9 SRM 51-70-5 & 51-30-5.SDR Y2PA20141124021Skin · crackedDURING C CHECK, DISCOVERED A SKIN CRACK AT STATION 680 BETWEEN LONGERONS 25R - 26R. INSTALLED REPAIR BETWEEN STATION 680 - 710.5 BETWEEN LONGERONS 25R - 26R IAW DER 8110-3 & DWG 53301422-1.SDR Y2PA20141124020Skin · crackedDURING C CHECK, DISCOVERED A SKIN CRACK AT FUEL PANEL 1456. INSTALLED REPAIR BETWEEN STATION XRS 214 - XRS 266 IAW DER 8110-3 & DWG 57301401-1.SDR Y2PA20141124019Skin · corrodedDURING C CHECK, DISCOVERED SKIN CORRODED FROM BS 645 - 699 BETWEEN LONGERONS 23 - 30L. REPAIRED IAW SRM 51-30-2, 51-30-5 & DWG 5911421.SDR Y2PA20141124018Frame · corrodedDURING C CHECK, DISCOVERED A CORRODED FUSELAGE FRAME AT STATION 408 BETWEEN LONGERONS 29R & 29L. REPAIRED IAW DC9 SRM 53-03 FIG 2A PAGE 12.SDR Y2PA20141124017Skin · crackedDURING C CHECK, DISCOVERED A CRACK IN THE NOSE SKIN AT STATION Y76.550 RBL 16. REPAIRED IAW DC9 SB 53-262.SDR Y2PA2011112200028Probe · wrong partACFT STARTED WITH 13,500 LBS OF FUEL. AFTER 40-45 MINUTES OF FLIGHT FUEL QTY WAS 6,000 LBS. FUEL QTY CONTINUED TO DECREASE AT HIGHER RATE THAT FUEL BURN RATE. CAPTAIN DECLARED EMERGENCY. DIVERTED AND LANDED WITH FUEL INDICATING 3,050 LBS. DISCOVERED DURINSDR Y2PA2010062900012Doubler · corrodedDURING "A" CHECK MX FOUND 2 RIVETS WITH MISSING HEADS FWD OF THE LAVATORY SERVICE DOOR. INSPECTION FOUND CABIN AIR OUTFLOW VALVE DOUBLER (PLATE) CORRODED BEYOND LIMITS AT STA. 786, LONG. 23L. MX INSTALLED A NEW DOUBLER (PLATE) AT STA 786, LONG. 23L IAW THE SSDR Y2PA00067Transducer · malfunctionedSTICK SHAKER ACTIVATED AT APPROXIMATELY 100FT CONTINUOUSLY UNTIL TOUCHDOWN. CREW DECLARED EMERGENCY AND RETURNED TO POINT OF DEPARTURE AT YIP. AIRCRAFT LANDED WITHOUT FURTHER INCIDENT.MAINTENANCE AT YIP REMOVED AND REPLACE THE LT WING, LIFT, TRANSDUCER AND R
Back to N192US, cancelled Jul 21, 2023