N783AN
Service difficulty reports · 324
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 = 'N783AN' 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 = 'N783AN' 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 AALA20121107007Light · inoperativeROW 21G ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 21G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20120831010Light · defectiveSEAT 12G AFT EMERGENCY LIGHT DIM. REPLACED LIGHT ASSEMBLY FOR SEAT 12G AFT EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120831009Lens · missingSEAT 21C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 21C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120831008Lens · missingSEAT 25C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 25C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120828009Light · missingSEAT 21C EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 21C EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20120828008Light · defectiveSEAT 11D EMERGENCY LIGHTS DIM. REPLACED SEAT 11D AFT EMERGENCY LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20120509006Anti-Ice Valve · faultyJFK - CREW REPORTED RIGHT ENGINE ANTI ICE FAULTED ON CLIMBOUT. FLIGHT RETURNED JFK LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI ICE VALVE. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20111118AFW01Skin · dentedDENT IN FUSELAGE AT STATION 2000 STRINGER 15. REPAIR DOUBLER INSTALLED PER SRM 53-00-01-2R7.SDR AALA20111117AFW01Sleeve · debondedRIGHT ENGINE LP COMPRESSOR CASE KEVLAR WRAP AT THE 5 TO 7 POSITION AFT ADGE OF THE TEFLON SLEEVE DISBONDING. ACCOMPLISHED REPAIR PER EA ENGN-72-020363 ACCOMPLISHED.SDR AALA20111115AFW01Frame · gouged2 GOUGES ON THE INBOARD, AFT SIDE OF THE STRUT TORQUE BOX STRUCTURE OF THE LEFT PYLON ON THE AFT SIDE OF THE FRAME AT NAC 332. ACCOMPLISHED REPAIR PER EA B777-54-020272.SDR AALA20110330MIA02Housing · brokenRIGHT NUMBER 2 DOOR EMERGENCY LIGHT HAS MISSING PIN ON HOUSING AND COVER IS LOOSE. REPLACED HOUSING ASSEMBLY FOR RIGHT NUMBER 2 DOOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110219NRT01Smoke Warning · false activationMULTIPLE CABIN SMOKE-FIRE INDICATIONS ON CLIMBOUT. FLIGHT CONTINUED TO FINAL DESTINATION WITH NO FURTHER INDICATIONS. UPON LANDING ACCOMPLISHED CABIN CHECK AND ALL ELECTRICAL SYSTEMS CHECKS PER AMM SWD. AIR CONDITIONING, PACKS, PNEUMATICS CHECKS OK. CABIN SDR AALA20110212DFW05Lens · missingSEAT 22G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR SEAT 22G EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110212DFW04Light · inoperativeSEAT 22G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22G. OPS CHECK NORMAL.SDR AALA20110212DFW03Connector · looseLEFT NUMBER 2 DOOR EXTERIOR EMERGENCY LIGHT INOPERATIVE. TIGHTENED LOOSE CONNECTION FOR LEFT NUMBER 2 DOOR EXTERIOR EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20110212DFW02Lens · brokenFIRST CLASS CLOSET LEFT SIDE EMERGENCY LIGHT LENS BROKEN. REPLACED LIGHT ASSEMBLY FOR FIRST CLASS CLOSET EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20101202DFW09Light · looseLEFT OVERHEAD ROW 45 EMERGENCY LIGHT ASSEMBLY IS LOOSE. RE-TIGHTENED LOOSE LEFT OVERHEAD ROW 45 EMERGENCY LIGHT ASSEMBY. OPS CHECK NORMAL.SDR AALA20101202DFW08Light · inoperativeEMERGENCY LIGHT AT FORWARD RIGHT NUMBER 2 DOOR HAS 1 LAMP INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD RIGHT NUMBER 2 DOOR. OPS CHECK NORMAL.SDR AALA20101202DFW07Lens · missingEMERGENCY LIGHT AT SEAT 21C IS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C.SDR AALA20101118TUL20Lens · missingSEAT 33C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 33C. OPS CHECK NORMAL.SDR AALA20101118TUL19Lens · missingSEAT 27C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 27C. OPS CHECK NORMAL.SDR AALA20101118TUL18Lens · missingSEAT 23C EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. OPS CHECK NORMAL.SDR AALA20101118TUL16Lens · missingSEAT 26G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 26G. OPS CHECK NORMAL.SDR AALA20101118TUL15Lens · missingSEAT 37G EMERGENCY LIGHT MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 37G. OPS CHECK NORMAL.SDR AALA20101118TUL14Light · inoperativeSEAT 33C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 33C. OPS CHECK NORMAL.SDR AALA20101118TUL13Light · inoperativeSEAT 27C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 27C. OPS CHECK NORMAL.SDR AALA20101118TUL12Light · inoperativeSEAT 23C EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. OPS CHECK NORMAL.SDR AALA20101118TUL11Light · inoperativeSEAT 26G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26G. OPS CHECK NORMAL.SDR AALA20101118MIA01Light · inoperativeSEAT 37G EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 37G. OPS CHECK NORMAL.SDR AALA20100917TUL08Lens · missingROW 33G ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT ROW 33G. OPS CHECKED NORMAL.SDR AALA20100917TUL07Light · inoperativeROW 33G ESCAPE PATH LIGHT BULB INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 33G. OPS CHECKED NORMAL.SDR AALA20100917TUL02Lens · missingROW 39C ESCAPE PATH LIGHT HAS LENS MISSING. REPLACED LENS FOR ROW 39C ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100917TUL01Lamp · missingROW 39C ESCAPE PATH LIGHT HAS ONE LAMP MISSING. REPLACED LAMP FOR ROW 39C ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100917DFW03Lamp · burned outROW 30 CENTER ESCAPE PATH CEILING LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 30 CENTER ESCAPE PATH CEILING LIGHT. OPS CHECK NORMAL.SDR AALA20100917DFW02Lamp · burned outROW 37G ESCAPE PATH LIGHT HAS ONE BULB INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 37G. OPS CHECKED NORMAL.SDR AALA20100917DFW01Lamp · burned outROW 35C ESCAPE PATH LIGHT HAS ONE BULB INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 35C. OPS CHECKED NORMALSDR AALA20100916DFW05Lamp · burned outROW 26C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 26C ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100916DFW04Lamp · burned outLEFT NUMBER 2 DOOR AFT ESCAPE PATH LIGHT ON SIDEWALL IS INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT LEFT NUMBER 2 DOOR AFT. OPS CHECKED NORMAL.SDR AALA20100907TUL07Light · missingSEAT 32G EMERGENCY LIGHT MISSING LAMP. REPLACED LAMP FOR SEAT 32G EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100905DFW05Lens · missingSEAT 37C EMERGENCY LIGHT LENS MISSING. REPLACED LENS FOR SEAT 37C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100905DFW04Lens · missingSEAT 35C EMERGENCY LIGHT LENS MISSING. REPLACED LENS FOR SEAT 35C EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100905DFW03Lens · missingSEAT 32G EMERGENCY LIGHT LENS MISSING. REPLACED LENS FOR SEAT 32G EMERGENCY LIGHT. OPS CHECKED NORMAL.SDR AALA20100625NRT01Light · brokenFOUND AFT CABIN DIVIDER RIGHT EMERGENCY LIGHT BASE BROKEN & LENS MISSING. REPLACED LIGHT ASSEMBLY. OPS CHECK NORMAL.SDR AALA20100620DFW03Light · inoperativeAFT SEAT MOUNTED EMERGENCY LIGHT AT 11D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR AFT SEAT MOUNTED EMERGENCY LIGHT AT 11D. OPS CHECKED NORMAL.SDR AALA20100803TUL22Light · inoperativeROW 31G ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHTING AT 31G. OPS CHECKED NORMAL.SDR AALA20100803TUL21Light · inoperativeROW 33G ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHTING AT 33G. OPS CHECKED NORMAL.SDR AALA20100803TUL20Light · inoperativeROW 36G ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR 36G ESCAPE PATH LIGHTING. OPS CHECKED NORMAL.SDR AALA20100424DFW02Light · inoperativeROW 43G ESCAPE PATH LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR 43G ESCAPE PATH LIGHT. OPS CHECKED NORMAL.SDR AALA20100216DFW01Light · inoperativeEMERGENCY PATH LIGHTING AT SEAT 34G INOPERATIVE. REPLACED LAMP FOR EMERGENCY PATH LIGHTING AT SEAT 34G, OPS CHECK NORMAL.SDR AALA20100727TUL35Lens · crackedPATHWAY EMERGENCY LIGHT AT SEAT 32C HAS CRACKED LENS. REPLACED LENS FOR PATHWAY EMERGENCY LIGHT AT SEAT 32C. OPS CHECKED NORMAL.
Back to N783AN