N789AN
Service difficulty reports · 262
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 = 'N789AN' AND registry_match = 'registration' 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 = 'N789AN' AND registry_match = 'registration' 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 AALA20120519004Housing · crackedFIRST CLASS GALLEY CLOSET LEFT FORWARD ESCAPE PATH LIGHT WAS MISSING AND HOUSING CRACKED. REMOVED AND REPLACED FORWARD LEFT ESCAPE PATH LIGHT ASSEMBLY AT FIRST CLASS GALLEY CLOSET, OPS CHECK GOOD.SDR AALA20120411020Lamp · burned outEMERGENCY LIGHT AT SEAT 38C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 38C. OPS CHECKED NORMAL.SDR AALA20120411019Lamp · burned outEMERGENCY LIGHT FIRST CLASS GALLEY LEFT FORWARD CORNER INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FIRST CLASS GALLEY LEFT SIDE. OPS CHECKED NORMAL.SDR AALA20120411018Lamp · burned outCEILING EMERGENCY LIGHT ABOVE SEAT 38B INOPERATIVE. REPLACED LAMP FOR CEILING EMERGENCY LIGHT ABOVE SEAT 38B. OPS CHECKED NORMAL.SDR AALA20120315015Battery Pack · failedBATTERY PACK M33093 FAILED AFTER 6 MINUTES. REPLACED BATTERY PACK M33093. OPS CHECK NORMAL.SDR AALA20110812MIA03Light · inoperativeEMERGENCY LIGHT ON SEAT 26C INOPERATIVE. REPLACED LAMP FOR SEAT 26C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110709LHR01Connector · brokenSEAT 9D EGRESS LIGHT INOPERATIVE. REPLACED CONNECTOR AT SEAT 9D THAT WAS BROKEN. OPS CHECK NORMAL.SDR AALA20110509DFW01Wire · looseSEAT 13D ESCAPE PATH LIGHTS INOPERATIVE. FOUND WIRE PULLED OUT OF CONTACT SOCKET OF CONNECTOR. REPLACED WIRE. OPS CHECK NORMAL.SDR AALA20110511TUL04Light · missingSEAT 23C ESCAPE PATH LIGHT MISSING LAMPS. REPLACED LAMPS FOR SEAT 23C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110509DFW02Lens · missingSEAT 23C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 23C. OPS CHECK NORMAL.SDR AALA20110225LHR01Light · inoperativeSEAT 21G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21G. OPS CHECK NORMALSDR AALA20110225TUL29Lens · missingSEAT 30C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 30C. OPS CHECK NORMAL.SDR AALA20110225TUL28Light · inoperativeSEAT 30C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 30C. OPS CHECK NORMAL.SDR AALA20110225TUL27Lens · missingSEAT 23C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. OPS CHECK NORMAL.SDR AALA20110225TUL26Light · inoperativeSEAT 23C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. OPS CHECK NORMAL.SDR AALA20110225TUL25Lens · missingSEAT 22C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. OPS CHECK NORMAL.SDR AALA20110225TUL24Light · inoperativeSEAT 22C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. OPS CHECK NORMAL.SDR AALA20110225TUL23Lens · missingSEAT 37G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 37G. OPS CHECK NORMAL.SDR AALA20110225TUL22Light · inoperativeSEAT 37G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 37G. OPS CHECK NORMAL.SDR AALA20110225TUL21Lens · missingSEAT 34G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 34G. OPS CHECK NORMAL.SDR AALA20110225TUL20Light · inoperativeSEAT 34G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 34G. OPS CHECK NORMAL.SDR AALA20110225TUL19Lens · missingSEAT 22G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22G. OPS CHECK NORMAL.SDR AALA20110225TUL18Light · inoperativeSEAT 22G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 22G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110225TUL17Lens · missingSEAT 21 EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. OPS CHECK NORMAL.SDR AALA20101105TUL06Battery Pack · failedESCAPE PATH LIGHT BATTERY PACK FAILED DURING TEST PACK NUMBER M33096 AT LEFT NUMBER 2 DOOR. REPLACED BATTERY PACK FOR ESCAPE PATH LIGHT AT LEFT NUMBER 2 DOOR. OPS CHECK NORMAL.SDR AALA20101104DFW07Light · inoperativeSEAT 45C ESCAPE PATH LIGHT HAS LAMP INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR SEAT 45C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101105TUL05Light · inoperativeLEFT NUMBER 4 DOOR FORWARD EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 4 FORWARD EXIT SIGN. OPS CHECKS NORMAL.SDR AALA20101105TUL04Light · inoperativeLEFT NUMBER 3 DOOR AFT EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR AFT EXIT SIGN. OPS CHECKS NORMAL.SDR AALA20101104DFW06Light · inoperativeLEFT NUMBER 3 DOOR UPPER CENTER EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR UPPER CENTER EXIT SIGN. OPS CHECKS NORMAL.SDR AALA20101104DFW05Light · inoperativeLEFT NUMBER 3 DOOR FORWARD EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR FORWARD EXIT SIGN. OPS CHECKS NORMAL.SDR AALA20101104DFW04Light · inoperativeRIGHT NUMBER 2 DOOR FORWARD EXIT SIGN LAMP INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 2 DOOR FORWARD EXIT SIGN. OPS CHECKS NORMAL.SDR AALA20101107DFW13Light · inoperativeTHE LOWER LAMP IN THE EMERGENCY ESCAPE PATH LIGHT AT 35C IS INOPERATIVE. REPLACED LAMP FOR LOWER POSITION EMERGENCY ESCAPE PATH LIGHT AT 35C. OPS CHECKED NORMAL.SDR AALA20101107DFW11Light · inoperativeTHE CENTER PASSENGER SERVICE UNIT EMERGENCY FLOOD LIGHT AT ROW 30 IS INOPERATIVE. REPLACED LAMP FOR CENTER PASSENGER SERVICE UNIT EMERGENCY FLOOD LIGHT AT ROW 30. OPS CHECKED NORMAL.SDR AALA20101107DFW12Lens · missingSEAT 39G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 39G. OPS CHECKS NORMAL.SDR AALA20101107DFW10Connector · unsecureTHE EMERGENCY ESCAPE PROXIMITY LIGHTS ON ROW 30 CDEFG ARE INOPERATIVE. RE-SECURED CONNECTOR UNDER SEAT ROW 30 C, D, E, F,G. OPS CHECKS NORMAL.SDR AALA20101108TUL06Light · missingTHE ESCAPE PATH LIGHT AT SEAT 22C IS MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 22C. OPS CHECKED NORMAL.SDR AALA20101107DFW15Lens · missingTHE ESCAPE PATH LIGHT AT SEAT 22C IS MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 22C. OPS CHECKED NORMAL.SDR AALA20101108TUL05Light · inoperativeTHE ESCAPE PATH LIGHT AT SEAT 24C IS MISSING LAMP. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 24C. OPS CHECK NORMAL.SDR AALA20101107DFW14Lens · missingTHE ESCAPE PATH LIGHT AT SEAT 24C IS MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 24C. OPS CHECK NORMAL.SDR AALA20101107DFW09Light · brokenTHE FORWARD FACING RIGHT OUTBOARD G3 GALLEY CART STOWAGE WALL MOUNTED EMERGENCY PROXIMITY LIGHT IS BROKEN. REPLACED THE RIGHT OUTBOARD G3 GALLEY CART STOWAGE WALL MOUNTES EMERGENCY PROXIMITY LIGHT ASSEMBLY. OPS CHECKED NORMAL.SDR AALA20101107DFW08Light · brokenTHE END FACING G3 GALLEY COAT CLOSET WALL MOUNTED PROXIMITY EMERGENCY LIGHT IS BROKEN. REPLACED THE FORWARD FACING G-2 GALLEY COAT CLOSET WALL MOUNTED EMERGENCY PROXIMITY LIGHT ASSEMBLY. OPS CHECKED NORMAL.SDR AALA20101006TUL08Lens · brokenROW 4 EMERGENCY LIGHT INOPERATIVE. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 4. OPS CHECKS GOOD.SDR AALA20101006DFW04Light · inoperativeROW 4 EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 4. OPS CHECKS GOOD.SDR AALA20101006DFW05Lens · missingROW 21 EMERGENCY LIGHT LENS MISSING. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 21. OPS CHECKS GOOD.SDR AALA20101006DFW03Lens · brokenGALLEY EMERGENCY LIGHT ADJACENT TO RIGHT NUMBER 1 DOOR LENS BROKEN. REPLACED LENS AT FORWARD RIGHT GALLEY CORNER ESCAPE PATH LIGHT LENS. OPS CHECKS GOOD.SDR AALA20100919DFW07Lens · missingSEAT ESCAPE PATH LIGHT LENS MISSING ON 23C. REPLACED LENS FOR SEAT ESCAPE PATH LIGHT ON SEAT 23C. OPS CHECKS GOOD.SDR AALA20100919DFW06Lens · missingSEAT ESCAPE PATH LIGHT LENS MISSING ON 21C. REPLACED LENS FOR SEAT ESCAPE PATH LIGHT ON 21C.SDR AALA20100826DFW07Light · brokenSEAT 21G ESCAPE PATH LIGHT ASSEMBLY BROKEN. REPLACED LIGHT ASSEMBLY FOR ESCAPE PATH LIGHT AT SEAT 21G, OPS CHECKED NORMAL.SDR AALA20100826DFW06Lens · missingSEAT 26G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT SEAT 26G, OPS CHECKED NORMAL.SDR AALA20100826DFW05Light · inoperativeSEAT 35G ESCAPE PATH LIGHT HAS 1 LAMP INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT SEAT 35G. OPS CHECKED NORMAL.
Back to N789AN