N781AN
Service difficulty reports · 293
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 = 'N781AN' 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 = 'N781AN' 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 AALA20120529023Lens · missingSEAT 20C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120529022Light · inoperativeLEFT NUMBER 3 DOOR FORWARD ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR FORWARD ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120529021Lens · missingSEAT 38C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 38C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120529020Lens · missingSEAT 39C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 39C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120529019Lens · missingSEAT 37G ESCAPE PATH LIGHT MISSING MISSING. REPLACED LENS FOR SEAT 37G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120529018Lens · missingSEAT 24G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 24G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120529017Lens · missingSEAT 21G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 21G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120313020Cover · brokenSEAT 20C EMERGENCY LIGHT COVER BROKEN. REPLACED COVER FOR SEAT 20C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120313019Light · inoperativeSEAT 38G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 38G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120312014Light · inoperativeSEAT 20C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 20C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL20Light · inoperativeSEAT 35G EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 35G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL19Lens · missingSEAT 35G EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 35G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL18Light · inoperativeSEAT 36G EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 36G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL17Lens · missingSEAT 37G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 37G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL16Lamp · inoperativeSEAT 37G EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 37G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL15Lens · missingSEAT 40G EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 40G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL14Lens · missingSEAT 44G EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 44G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL13Light · inoperativeSEAT 44G EMERGENCY PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 44G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20111003TUL12Light · inoperativeFORWARD GALLEY, EMERGENCY LIGHT, RIGHT SIDE CART PARTITION INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT, RIGHT SIDE CART PARTITION. OPS CHECK GOOD.SDR AALA20110930DFW06Guard · brokenRIGHT NUMBER 4 DOOR EMERGENCY PATH LIGHT SWITCH GUARD BROKEN. REPLACED RIGHT NUMBER 4 DOOR EMERGENCY PATH LIGHT SWITCH GUARD. OPS CHECK NORMAL.SDR AALA20110930DFW05Lens · missingSEAT 36G EMERGENCY PATH LIGHT MISSING LENS. REPLACED LENS FOR SEAT 36G EMERGENCY PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110930DFW04Light · inoperativeSEAT 40G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 40G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110930DFW03Light · missingSEAT 26C EMERGENCY PATH LIGHT MISSING LENS AND LAMPS. REPLACED LIGHT ASSEMBLY EMERGENCY LIGHT ON SEAT 26C. OPS CHECK NORMAL.SDR AALA20110930DFW02Lens · missingEMERGENCY LIGHT, RIGHT SIDE CART PARTITION MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT, RIGHT SIDE CART PARTITION. OPS CHECK GOOD.SDR AALA20110814DFW02Actuator · inoperativeDFW - CREW REPORTED UNABLE TO PRESSURIZE CABIN. FOLLOWED QRH PROCEDURES UNABLE TO CONTROL CABIN ALTITUDE. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ACTUATOR ASSEMBLY FOR FORWARD OUTFLOW VALVE. SDR AALA20110510ORD01Module · faultyORD - CREW REPORTED ON DEPARTURE LANDING GEAR WOULD NOT RETRACT. CYCLED GEAR SEVERAL TIMES WITH SAME RESULT. EMERGENCY DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FAULTY LANDING GEAR CONTROL LEVER MODULE. SSDR AALA20110320DFW02Light · brokenEMERGENCY LIGHT AT LEFT FORWARD CORNER OF FORWARD GALLEY BROKEN AND DISLODGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT FORWARD CORNER OF FORWARD GALLEY. OPS CHECK NORMAL.SDR AALA20110320DFW01Light · inoperativeEMERGENCY CEILING LIGHT AT ROW 24 RIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT ROW 24 RIGHT. OPS CHECK NORMAL.SDR AALA20110124JFK01Wire Harness · looseSEAT MOUNTED EMERGENCY LIGHTS AT SEATS 45C AND 45G ARE INOPERATIVE. RE-SECURED LOOSE EMERGENCY LIGHTS HARNESS AT SEATS 45C AND 45G. OPS CHECK NORMAL.SDR AALA20101209TUL06Light · missingAFT GALLEY LEFT SIDE EMERGENCY LIGHT MISSING LAMP. REPLACED LENS CAP. OPS CHECK NORMAL.SDR AALA20101207TUL10Light · inoperativeLEFT NUMBER 3 DOOR UPPER EXIT SIGN INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR UPPER EXIT SIGN. OPS CHECK NORMAL.SDR AALA20101207TUL09Lens · missingSEAT 26C ESCAPE PATH LIGHT IS MISSING LENS. REPLACED LENS FOR SEAT 26C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW09Sign · inoperativeLEFT NUMBER 3 DOOR FORWARD EXIT SIGN INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 3 DOOR FORWARD EXIT SIGN.SDR AALA20101206DFW08Light · defectiveSEAT 20C ESCAPE PATH LIGHT IS DIM. REPLACED LAMP FOR SEAT 20C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101207TUL08Light · inoperativeSEAT 39G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 39G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101207TUL07Light · inoperativeSEAT 37G ESCAPE PATH LIGHT INOPERATIVE AND MISSING LENS. REPLACED LIGHT ASSEMBLY AT SEAT 37G. OPS CHECK NORMAL.SDR AALA20101207TUL06Light · out of positionLAVATORY 4F-L RETURN TO SEAT SIGN IS PARTIALLY ILLEGIBLE. REPOSITIONED LED. OPS CHECK NORMAL.SDR AALA20101207TUL05Light · inoperativeSEAT 44C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 44C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101207TUL04Light · inoperativeRIGHT NUMBER 1 DOOR FORWARD EXIT SIGN INOPERATIVE. REPLACED LAMP FOR RIGHT NUMBER 1 FORWARD EXIT SIGN. OPS CHECK NORMAL.SDR AALA20101207TUL03Light · defectiveSEAT 26G ESCAPE PATH LIGHT IS DIM. REPLACED LAMP FOR SEAT 26G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW07Light · inoperativeSEAT 40G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 40G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW06Light · inoperativeSEAT 38G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR SEAT 38G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW05Light · brokenPROXIMITY LIGHT AT LEFT SIDE OF FIRST CLASS GALLEY HAS BROKEN FRAME AND MISSING LENS. REPLACED LIGHT ASSEMBLY AT LEFT SIDE GALLEY FOR PROXIMITY LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW04Lens · missingROW 31C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 31C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW03Light · defectiveSEAT 24G ESCAPE PATH LIGHT IS DIM. REPLACED LAMP FOR SEAT 24G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101206DFW02Light · defectiveSEAT 36G ESCAPE PATH LIGHT IS DIM. REPLACED LAMP FOR SEAT 36G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20101201TUL12Light · brokenEMERGENCY LIGHT LAMP AT SEAT 24G BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24G. OPS CHECK NORMAL.SDR AALA20101201TUL11Lens · brokenEMERGENCY LIGHT LENS AT SEAT 24G BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24G. OPS CHECK NORMAL.SDR AALA20101201TUL10Light · brokenEMERGENCY LIGHT LAMP AT SEAT 26G BROKEN. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26G. OPS CHECK NORMAL.SDR AALA20101201TUL09Lens · brokenEMERGENCY LIGHT LENS AT SEAT 26G BROKEN. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26G. OPS CHECK NORMAL.
Back to N781AN