N782AN
Service difficulty reports · 219
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 = 'N782AN' 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 = 'N782AN' 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 AALA20110203DFW15Lens · missingROW 26C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 26C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW14Light · inoperativeROW 26C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 26C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW12Light · inoperativeROW 25C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ESCAPE PATH LIGHT AT ROW 25C. OPS CHECK NORMAL.SDR AALA20110203DFW11Lens · missingROW 36C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 36C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW04Light · wrong partROW 11D HAS WRONG ESCAPE PATH LIGHT ON SIDE SEAT FIXTURE. INSTALLED CORRECT LIGHT ASSEMBLY AT ROW 11D.SDR AALA20110204TUL02Lens · missingROW 34C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 34C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110204TUL01Light · inoperativeLEFT NUMBER 3 DOOR AFT SIDEWALL ESCAPE PATH LIGHT BULB INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR LEFT NUMBER 3 DOOR AFT ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW10Light · inoperativeROW 36C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 36C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW09Light · inoperativeROW 38G ESCAPE PATH LIGHT ONE BULB INOPERATIVE. REPLACED LAMP FOR ROW 38G ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW08Light · missingROW 39C ESCAPE PATH LIGHT MISSING ONE LAMP. REPLACED LAMP FOR ROW 39C ESCAPE PATH LIGHT.SDR AALA20110203DFW07Lens · missingROW 23C ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS FOR ROW 23C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW06Light · inoperativeROW 23C ESCAPE PATH LIGHT INOPERATIVE. REPLACED LAMP AT ROW 23C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW05Light · inoperativeROW 34C ESCAPE PATH LIGHT MISSING LAMP. REPLACED LAMP FOR ROW 34C ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110203DFW03Battery Pack · dischargedCEILING ESCAPE PATH LIGHTS FROM LEFT NUMBER 2 DOOR TO ROW 12D INOPERATIVE. REPLACED BATTERY PACK FOR CEILING ESCAPE PATH LIGHTS FROM LEFT NUMBER 2 DOOR TO ROW 12D. OPS CHECK NORMAL.SDR AALA20110203DFW02Lens · missingFIRST CLASS COAT CLOSET LEFT ESCAPE PATH LIGHT MISSING LENS. REPLACED LENS AT FIRST CLASS COAT CLOSET LEFT ESCAPE PATH LIGHT. OPS CHECK NORMAL.SDR AALA20110119ORD01Light · inoperativeLEFT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR LEFT NUMBER 2 DOOR EXTERNAL EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20101117TUL04Lens · missingEMERGENCY LIGHT AT 24C MISSING CLEAR LENS. REPLACED LENS FOR ESCAPE PATH LIGHT AT 24C. OPS CHECK NORMAL.SDR AALA20101117TUL03Light · inoperativeROW 8H MID GALLEY HAS ONE EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP ROW 8H MID GALLEY EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20101116DFW10Light · inoperativeROW 20 FORWARD BULKHEAD WALL EMERGENCY LIGHT INOPERATIVE. REPLACED LAMP FOR ROW 20 FORWARD BULKHEAD WALL EMERGENCY LIGHT. OPS CHECK NORMAL.SDR AALA20100929TUL01Connector · defectiveFORWARD EMERGENCY LIGHT ON 11D INOPERATIVE. REPLACED PLUG ON EMERGENCY LIGHT AT 11D. OPS CHECK NORMAL.SDR AALA20100929DFW01Connector · looseAFT EMERGENCY LIGHT ON 1D INOPERATIVE. SECURED PLUG ON AFT EMERGENCY LIGHT AT 1D. OPS CHECKED NORMAL.SDR AALA20100923MCO01Hydraulic Line · leakingMCO - INFLIGHT JFK-MIA. APPROX 1.5 HRS INTO FLIGHT EXPERIENCED CENTER SYSTEM HYDRAULIC LOW INDICATION CENTER SYSTEM FLUID LEVEL DECREASED DOWN TO 0.30. AFTER GEAR AND FLAP EXTENSION FLUID DROPPED TO 0.11. EMERGENCY DECLARED DIVERTED MCO LANDED WITHOUT INCIDSDR AALA20100803TUL04Light · inoperativeEMERGENCY LIGHT AT FORWARD GALLEY RIGHT CORNER BROKE OUT. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD GALLEY RIGHT CORNER. OPS CHECKED NORMAL.SDR AALA20100803DFW01Light · inoperativeEMERGENCY LIGHT AT FORWARD GALLEY LEFT CORNER BROKE. REPLACED LAMP FOR EMERGENCY LIGHT AT FORWARD GALLEY LEFT CORNER. OPS CHECKED NORMAL.SDR AALA20100415MIA01Processing Unit · inoperativeMIA - INFLIGHT JFK-GRU. CREW REPORTED FUEL QUANTITY PROBLEM AND UNWANTED FUEL TRANSFER. EMERGENCY DECLARED, DIVERTED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED FUEL QUANTITY PROCESSOR TANK UNIT. SYSTEM GROUND CHECKED NORMAL OPERASDR AALA20100122DFW03Light · damagedEMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR AT GALLEY COMPARTMENT IS DAMAGED AND MISSING LENS. REPLACED LIGHT ASSEMBLY.SDR AALA20100122DFW02Light · damagedEMERGENCY LIGHT AT LEFT NUMBER ONE DOOR CLOSET AREA IS DAMAGED. REPLACED LIGHT ASSEMBLY AT LEFT NUMBER ONE DOOR.SDR AALA2009041300765Light · inoperativeJFK - EMERGENCY LIGHTS AT SEAT 21G INOPERATIVE. REPLACED SEAT 21G EMERGENCY LIGHT ASSEMBLY.SDR AALA2009040900738Cover · missingJFK EMERGENCY LIGHT PANEL COVER ADJACENT TO JUMPSEAT 4LC IS MISSING. REPLACED LIGHT ASSEMBLY.SDR AALA200802515ABattery Pack · dischargedAFW - EMERGENCY LIGHT BATTERY PACK AT OVERHEAD R2 DOOR FAILED TEST. REPLACED BATTERY PACK AT OVERHEAD R2 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801738Light · inoperativeJFK - EMERGENCY LIGHTS AT FORWARD FIRST CLASS CABIN CLOSET AREA INOPERATIVE. REPLACED IN WALL LIGHT ASSEMBLY FOR EMERGENCY LIGHTS AT FORWARD FIRST CLASS CABIN CLOSET AREA. SYSTEM GROUND CHECKED NORMAL OPERATION. (S)SDR AALA200801002Lens · missingJFK - EMERGENCY LIGHT AT SEAT 22C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801001Lens · missingJFK - EMERGENCY LIGHT AT SEAT 21G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800787Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 21G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800788Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800673Lens · missingJFK - EMERGENCY LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800672Lamp · inoperativeJFK - EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800669Lens · missingJFK - EMERGENCY LIGHT AT SEAT 22C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800668Lamp · inoperativeJFK - EMERGENCY LIGHT AT SEAT 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071103Light · damagedORD - EMERGENCY EXIT LIGHT AT LEFT NUMBER THREE DOOR MISSING COVER. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY AT LEFT NUMBER THREE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071007Bulb · burned outMIA - EMERGENCY LIGHT IN CEILING ABOVE SEAT 22C INOPERATIVE. RELAMPED EMERGENCY LIGHT IN CEILING ABOVE SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070337Bulb · burned outDFW - FOUND EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR CEILING INOPERATIVE. RELAMPED EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070336Bulb · missingDFW - FOUND EMERGENCY LIGHT AT SEAT 3G MISSING LAMPS. RELAMPED EMERGENCY LIGHT AT SEAT 3G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070335Lens · missingDFW - FOUND EMERGENCY LIGHT AT SEAT 3G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 3G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070338Light · inoperativeDFW - FOUND EMERGENGY LIGHT AT CENTER GALLEY CEILING INOPERATIVE. RELAMPED EMERGENCY LIGHT AT CENTER GALLEY CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070210Lens · missingORD - FOUND EMERGENCY LIGHT AT SEAT 40C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 40C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070209Bulb · missingORD - FOUND EMERGENCY LIGHT AT SEAT 22C MISSING LAMPS. RELAMPED EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070211Bulb · missingORD - FOUND EMERGENCY LIGHT AT SEAT 40C MISSING LAMP. RELAMPED EMERGENCY LIGHT AT SEAT 40C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070208Lens · missingORD - FOUND EMERGENCY LIGHT AT SEAT 22C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070109Lens · missingMIA - EMERGENCY LIGHT AT SEAT 3D HAS MISSING LENS CAP. REPLACED LENS CAP FOR EMERGENCY LIGHT AT SEAT 3D. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N782AN