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 AALA20100727TUL34Lens · missingPATHWAY EMERGENCY LIGHT AT SEAT 45D IS MISSING LENS. REPLACED LENS FOR PATHWAY EMERGENCY LIGHT AT SEAT 45D. OPS CHECKED NORMAL.SDR AALA20100204DFW01Lens · missingFORWARD EMERGENCY LIGHT AT SEAT 9D CLEAR LENS IS MISSING. REPLACED CLEAR LENS FOR FORWARD EMERGENCY LIGHT AT SEAT 9D. OPS CHECKED NORMAL.SDR AALA20100204DFW04Wire · unsecureWIRING FOR EMERGENCY LIGHT HANGING UNSECURED IN FRONT OF LIFE VEST BOX COVER AT SEAT 42C. RE-SECURED WIRE FOR EMERGENCY LIGHT IN FRONT OF LIFE VEST BOX COVER AT 42C. OPS CHECKS NORMAL.SDR AALA20100204DFW03Wire · unsecureWIRING FOR EMERGENCY LIGHT HANGING UNSECURED IN FRONT OF LIFE VEST BOX COVER AT SEAT 35D. RE-SECURED WIRE FOR EMERGENCY LIGHT IN FRONT OF LIFE VEST BOX COVER AT SEAT 35D. OPS CHECKS NORMAL.SDR AALA20100204DFW02Wire · unsecureWIRING FOR EMERGENCY LIGHT HANGING UNSECURED UNDER SEAT 35G. RE-SECURED WIRE FOR EMERGENCY LIGHT UNDER SEAT 35G.SDR AALA20100203DFW09Wire · unsecureWIRING FOR EMERGENCY LIGHT HANGING UNSECURED IN FRONT OF LIFE VEST BOX COVER AT SEAT 42C. RE-SECURED WIRE FOR EMERGENCY LIGHT IN FRONT OF LIFE VEST AT SEAT 42C.SDR AALA20100203DFW08Wire · unsecureWIRING FOR EMERGENCY LIGHT HANGING UNSECURED IN FRONT OF LIFE VEST BOX COVER AT SEAT 35D. RE-SECURED WIRE FOR EMERGENCY LIGHT IN FRONT OF LIFE VEST BOX COVER AT SEAT 35D.SDR AALA20100203DFW07Wire · unsecureWIRING FOR EMERGENCY LIGHT HANGING UNSECURED UNDER SEAT 35G. RE-SECURED WIRE FOR EMERGENCY LIGHT UNDER SEAT 35G.SDR AALA20100203DFW06Lens · crackedPATHWAY EMERGENCY LIGHT AT SEAT 32C HAS CRACKED LENS. REPLACED LENS FOR PATHWAY EMERGENCY LIGHT AT SEAT 32C. OPS CHECKS NORMAL.SDR AALA20100203DFW05Lens · missingPATHWAY EMERGENCY LIGHT AT SEAT 45D IS MISSING LENS. REPLACED MISSING LENS FOR PATHWAY EMERGENCY LIGHT AT SEAT 45D. OPS CHECKS NORMAL.SDR AALA20100203DFW04Lens · missingFORWARD EMERGENCY LIGHT AT SEAT 9D MISSING CLEAR LENS. REPLACED MISSING LENS FOR FORWARD EMERGENCY LIGHT AT SEAT 9D. OPS CHECKS NORMAL.SDR AALA20100111GRU01Fan · failedGRU - CREW REPORTED BURNING SMELL AND SMOKE IN FIRST AND BUSINESS CLASS CABIN. AIR CLEARED WHEN RECIRCULATION FANS SHUT OFF. REPLACED LEFT LOWER RECIRCULATION FAN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20091211MIA09Light · inoperativeEMERGENCY LIGHT AT 31G INOPERATIVE. REPLACED LAMP.SDR AALA20091211MIA08Light · inoperativeEMERGENCY LIGHT AT SEAT 10D INOPERATIVE. REPLACED LAMP.SDR AALA20091111MIA01Tire · failedNUMBER 11 TIRE STARTED TO SLOWLY DEFLATE DURING CLIMB. LANDED MIA WITHOUT INCIDENT. SMOKE FROM TIRE REPORTED ON LANDING. FOUND RETREAD CAME LOOSE AFTER TAKEOFF. REPLACED NUMBER 11 AND 12 WHEEL AND BRAKE ASSEMBLY.SDR AALA2009041400764Lens · brokenLHA - EMERGENCY LIGHTS BETWEEN JUMP SEATS IN AFT GALLEY HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHTS BETWEEN JUMP SEATS IN AFT GALLEY.SDR AALA2009040800748Guard · brokenDFW WIRE GUARD FOR OVERHEAD AISLE EMERGENCY EXIT SIGN OVER SEAT 30G BROKEN. REPLACED GUARD FOR EMERGENCY EXIT SIGN LIGHT AT OVERHEAD AISLE OVER SEAT 30G.SDR AALA2009040800747Light · inoperativeDFW EMERGENCY LIGHT AT SEAT 31G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 31G.SDR AALA2009040800746Lens · missingDFW EMERGENCY LIGHT AT SEAT 31G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 31G.SDR AALA2009040800745Lens · missingDFW EMERGENCY LIGHT AT SEAT 37G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 37G.SDR AALA2009040800741Lens · missingDFW EMERGENCY LIGHT AT SEAT 43G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 43G.SDR AALA2009040800740Light · inoperativeDFW EMERGENCY LIGHT OUTSIDE RIGHT NUMBER 3 DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT OUTSIDE RIGHT NUMBER 3 DOOR.SDR AALA2009040800739Light · inoperativeDFW EMERGENCY LIGHT OUTSIDE RIGHT NUMBER 2 DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT OUTSIDE RIGHT NUMBER 2 DOOR.SDR AALA2009030800565Light · brokenDFW - EMERGENCY LIGHT AT SEAT 9D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 9D.SDR AALA200802335Switch · inoperativeEZE INFLIGHT T943/10SEP. CREW REPORTED EMERGENCY LIGHTS THROUGHOUT ACFT WERE INTERMITTENTLY BLINKING ON AND OFF. LANDED EZE WITHOUT INCIDENT. REPLACED EMERGENCY LIGHT SWITCH AT LT NR 1 DOOR PANEL. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200801630Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39G INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 39G. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801629Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801628Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 21G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 21G. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801627Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 32G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 32G. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801631Light · damagedDFW - EMERGENCY LIGHT AT LT NR ONE CLOSET AREA DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LT NR ONE CLOSET AREA. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801514Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT MID COACH CLASS INOPERATIVE. REPLACED BATTERY PACK AT STATION 1518 FOR EMERGENCY LIGHT AT MID COACH CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801247Lamp · missingDFW - EMERGENCY LIGHT AT SEAT 21C MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801245Light · missingDFW - EMERGENCY LIGHT AT SEAT 23C MISSING LAMPS. REPLACED LAMPS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801244Light · brokenDFW - EMERGENCY LIGHT AT FORWARD GALLEY NEAR LEFT NUMBER ONE DOOR BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT FORWARD GALLEY NEAR LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801246Lens · missingDFW - EMERGENCY LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801248Lens · missingDFW - EMERGENCY LIGHT AT SEAT 21C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801044Light · shortedJFK - EMERGENCY LIGHT AT LEFT AND RIGHT FORWARD GALLEY INOPERATIVE. FOUND SHORTED LIGHT ASSEMBLY ON RIGHT SIDE FORWARD GALLEY. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT FORWARD GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800808Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 39G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 39G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800807Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 36C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 36C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800806Lamp · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.
SDR AALA200800803Light · inoperativeDFW - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR CLOSET AREA IS DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR CLOSET AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800805Lens · missingDFW - EMERGENCY LIGHT AT OVERHEAD SEAT 24G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT OVERHEAD SEAT 24G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800804Light · inoperativeDFW - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR GALLEY AREA IS DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR GALLEY AREA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800716Lens · missingDFW - EMERGENCY LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800715Lamp · inoperativeDFW - EXTERNAL EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800412Lens · brokenNRT - EMERGENCY EXIT LIGHT AT FIRST CLASS GALLEY IS BROKEN. REPLACED LENS FOR EMERGENCY EXIT LIGHT AT FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800323Lamp · inoperativeORD - EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800324Lens · missingORD - EMERGENCY LIGHT AT SEAT 40C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 40C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072418Lens · missingDFW - EMERGENCY LIGHT AT SEAT 32G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 32G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072416Lens · missingDFW - EMERGENCY LIGHT AT SEAT 26C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHTS AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.
Back to N783AN