N790AN
Service difficulty reports · 243
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 = 'N790AN' 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 = 'N790AN' 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 AALA200801705Light · inoperativeDFW - EMERGENCY LIGHT AT OVERHEAD SEAT 24C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801653Battery Pack · dischargedJFK - EMERGENCY LIGHTS AT SEAT ROWS 20 TO 26 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT SEAT ROWS 20 TO 26. SYSTEM GROUND CHECKED NORMAL OPERATION. (A)SDR AALA200801344Light · inoperativeDFW EXTERNAL EMERGENCY LIGHT AT LT NUMBER FOUR DOOR INOPERATIVE. REPLACED LAMP FOR EXTERNAL EMERGENCY LIGHT AT LT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED) (A)SDR AALA200801341Lens · missingJFK EMERGENCY LIGHT AT SEAT 23C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23C. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED) (A)SDR AALA200801340Light · inoperativeJFK EMERGENCY LIGHT AT OVERHEAD SET 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED) (A)SDR AALA200801216Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 22G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801215Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 31C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 31C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801214Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 26C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 26C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801213Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801212Light · inoperativeDFW - EMERGENCY LIGHT AT OVERHEAD SEAT 21C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200801211Light · inoperativeDFW - EXTERIOR EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR IN OPERATIVE. REPLACED LAMP FOR EXTERNAL EMERGENCY LIGHT AT LEFT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800995Lens · missingDFW - EMERGENCY LIGHT AT SEAT 23G MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800994Light · inoperativeDFW - EMERGENCY LIGHT AT SEAT 23G INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 23G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800993Light · brokenDFW - EMERGENCY LIGHT AT RIGHT CORNER OF G1 GALLEY BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT CORNER OF G1 GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800992Light · brokenDFW - EMERGENCY LIGHT AT LEFT CORNER OF G1 GALLEY BROKEN. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT CORNER OF G1 GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800086Lens · brokenJFK - EMERGENCY LIGHT AT SEAT 22C HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800085Lamp · inoperativeJFK - EMERGENCY LIGHT AT SEAT 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072568Lens · missingJFK - EMERGENCY LIGHT AT SEAT ROW 24C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT ROW 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072567Lamp · missingJFK - EMERGENCY LIGHT AT SEAT ROW 24C MISSING LAMP. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT ROW 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072155Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT 24C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072152Lens · missingMIA - EMERGENCY LIGHT AT SEAT 20C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072151Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT 20C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072154Lens · missingMIA - EMERGENCY LIGHT AT SEAT 22C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072153Lamp · inoperativeMIA - EMERGENCY LIGHT AT SEAT 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20072156Lens · missingMIA - EMERGENCY LIGHT AT SEAT 24C MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 24C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071891Battery Pack · inoperativeJFK - EMERGENCY LIGHTS AT SEAT ROWS 9D TO 13D INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER TWO DOOR FOR EMERGENCY LIGHTS AT SEAT ROWS 9D TO 13D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071337Bulb · inoperativeMIA - EMERGENCY EXIT LIGHT AT SEAT ROW 23C INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT SEAT ROW 23C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071336Bulb · inoperativeMIA - EMERGENCY EXIT LIGHT AT SEAT ROW 22C INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT LIGHT AT SEAT ROW 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070126Lens · brokenNRT - EMERGENCY LIGHT AT AFT GALLEY ON LEFT SIDE HAS BROKEN LENS. REPLACED EMERGENCY LIGHT LENS AT AFT GALLEY LEFT SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060466Battery Pack · dischargedDFW - EMERGENCY PATH LIGHTING IN CLOSET AREA OF LEFT NUMBER ONE AND TWO DOORS INOPERATIVE. REPLACED BATTERY PACK ABOVE LEFT NUMBER ONE DOOR FOR EMERGENCY PATH LIGHTING IN CLOSET AREA OF LEFT NUMBER ONE AND TWO DOORS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060388Battery Pack · dischargedBOS - EMERGENCY LIGHTS AT FIRST CLASS CREDENZA INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS AT FIRST CLASS CREDENZA. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060201Engine · bird ingestionORD - LEFT HAND ENGINE EXPERIENCED BIRD STRIKE AND SURGED INFLIGHT. SHUT ENGINE DOWN PER CHECKLIST. LANDED ORD WITHOUT INCIDENT. AIRCRAFT TAKEN OUT OF SERVICE. FOUND EVIDENCE OF BIRD STRIKE IN COMPRESSOR. ACCOMPLISHED BIRD STRIKE BOROSCOPE INSPECTION. NOSDR AALA20060183Battery Pack · inoperativeAFW - SEAT MOUNTED EMERGENCY ESCAPE PATH EXIT LIGHTS IN AFT COACH SECTION AND AT NUMBER ONE LEFT DOOR INOPERATIVE. REPLACED BATTERY PACK FOR SEAT MOUNTED EMERGENCY ESCAPE PATH EXIT LIGHTS IN AFT COACH SECTIONS AND AT NUMBER ONE LEFT DOOR. SYSTEM GROUND CHECKSDR AALA20050669Connector · looseJFK - EMERGENCY LIGHTS FROM SEAT 39 TO 44 INOPERATIVE. FOUND LOOSE PLUG AT ROW 38. RECONNECTED AND SECURED PLUG FOR EMERGENCY LIGHTS FROM SEAT 39 TO 44. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050654Wire · chafedJFK - INFLIGHT RIGHT ENGINE FUEL FILTER LIGHT CAME ON TWICE DURING FLIGHT. REPLACED RIGHT ENGINE FUEL FILTER AND FUEL PRESSURE SWITCH. FOUND WIRE W08182001R20 CHAFED UNDER CONNECTOR D573001 BACK SHELL. ACCOMPLISHED INTERIM REPAIR TO WIRE PER MAINTENANCE MANSDR AALA20040188Support Fitting · groovedAFW - RT WING FIXED TRAILING EDGE FLAPERON OUTBOARD SUPPORT FITTING HAS 0.7 X 2.0 AND 0.092 DEPTH GROOVE WORN ON UPPER SURFACE. BLENDED OUT DAMAGE AND PERFORMED HFEC FOR CRACKS. ROTO PEENED BLENDED AREA. ALODINE AND APPLIED TWO COATS OF PRIMER TO REWORKED ASDR AALA20031433Fuse · blownEZE EMERGENCY LIGHTS AT SEATS BETWEEN 3LR AND 4LR DOOR INOPERATIVE. REPLACED FUSE FOR EMERGENCY LIGHTS AT BATTERY PACK AT 3R DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031290Battery Pack · dischargedDFW AFT COACH SEATS EMERGENCY LIGHTS INOPERATIVE. REPLACED AFT COACH SEATS EMERGENCY LIGHTS BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031289Battery Pack · dischargedDFW FORWARD COACH SEATS EMERGENCY LIGHTS INOPERATIVE. REPLACED FORWARD COACH SEATS EMERGENCY LIGHTS BATTERY PACK. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031288Battery Pack · dischargedDFW BUSINESS CLASS SEATS EMERGENCY LIGHTS INOPERATIVE. REPLACED BATTERY PACK FOR BUSINESS CLASS SEATS EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031287Light · brokenDFW EMERGENCY PATH LIGHT FIXTURE IN GALLEY NEXT TO L1 DOOR BROKEN. REPLACED EMERGENCY PATH LIGHT FIXTURE IN GALLEY NEXT TO L1 DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030621Light · inoperativeDURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT INTERIOR FORWARD LEFT G3 CLOSET INOPERATIVE. REPLACED EMERGENCY EXIT INTERIOR FORWARD LEFT G3 CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20001696Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, FORWARD EMERGENCY EXIT LIGHT AT G3 GALLEY INOPERATIVE. REPLACED FORWARD LEFT LOWER EMERGENCY EXIT LIGHT ASSEMBLY AT G3 GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N790AN