N791AN
Service difficulty reports · 325
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 = 'N791AN' 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 = 'N791AN' 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 AALA20070741Lens · missingDFW - EMERGENCY LIGHT AT SEAT 22C HAS MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 22C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070739Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 20C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 20C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070738Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 9C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 9C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070742Bulb · burned outDFW - EMERGENCY LIGHT AT SEAT 25C INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070740Bulb · burned outDFW - OVERHEAD EMERGENCY LIGHT AT SEAT 21C INOPERATIVE. RELAMPED OVERHEAD EMERGENCY LIGHT AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070450Lens · missingMIA - EMERGENCY LIGHTS AT SEAT 21C HAS MISSING LENS. REPLACED LENS CAP FOR EMERGENCY LIGHTS AT SEAT 21C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070175Bulb · burned outDFW - EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR CEILING INOPERATIVE. RELAMPED EMERGENCY LIGHT AT RIGHT NUMBER ONE CEILING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060950Light · inoperativeDFW - OVERHEAD EMERGENCY LIGHT AT LEFT CENTER GALLEY INOPERATIVE. RELAMPED OVERHEAD EMERGENCY LIGHT AT LEFT CENTER GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060728Light · brokenMIA - EMERGENCY PATH LIGHT AT FORWARD RIGHT AND LEFT HAND IN FIRST CLASS GALLEY BROKEN REPLACED LIGHT ASSEMBLY FOR EMERGENCY PATH LIGHT AT FORWARD RIGHT AND LEFT HAND IN FIRST CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060377Oven · malfunctionedINFLIGHT EXPERIENCED ELECTRICAL ODOR AND HAZE COMING FROM COMPARTMENT 547 BUSINESS CLASS GALLEY WARMING OVEN. LANDED WITHOUT INCIDENT. FOUND NO EVIDENCE OF DAMAGE TO WIRING OR SMOKE DAMAGE. PULLED AND COLLARED CIRCUIT BREAKER FOR WARMING OVEN. REPLACED BUSSDR AALA20060341Battery Pack · dischargedJFK - RIGHT AND LEFT HAND SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 30 AND AFT OF AIRCRAFT INOPERATIVE. REPLACED BATTERY PACK AT RIGHT NUMBER THREE DOOR FOR INOPERATIVE RIGHT AND LEFT HAND SEAT MOUNTED EMERGENCY LIGHTS AT ROWS 30 TO AFT OF AIRCRAFT. SYSTEM GROUNSDR AALA20060185Battery Pack · inoperativeAFW - BATTERY PACKS FOR EMERGENCY EXIT LIGHTS ABOVE NUMBER ONE LEFT AND RIGHT EXIT DOOR AND NUMBER FOUR LEFT DOOR INOPERATIVE. REPLACED BATTERY PACKS FOR EMERGENCY EXIT LIGHTS ABOVE NUMBER ONE LEFT AND RIGHT EXIT DOOR AND NUMBER FOUR LEFT EXIT DOOR. SYSTEM GSDR AALA20050633Light · inoperativeDFW - EMERGENCY LIGHT ON FORWARD LEFT GALLEY NEXT TO CLOSET INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT ON FORWARD LEFT HAND GALLEY NEXT TO CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041185Engine · shutdownLGW - TWO MINUTES AFTER LANDING RIGHT ENGINE AUTO SHUTDOWN. FOUND FOD DAMAGE. FLIGHT DATA RECORDER DOWNLOADED PER WORK CARD 31 92 11. DATA SENT TO TULSA TECH. ENGINEERING ORDERED HPC BOROSCOPED CONCENTRATING ON STAGES ONE AND SIX. REPLACED RIGHT ENGINE PESDR AALA20040641Battery Pack · inoperativeMIA - EMERGENCY LIGHTS ON COACH SEATS INOPERATIVE. REPLACED FAULTY BATTERY PACK M33401 FOR EMERGENCY LIGHTS ON COACH SEATS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040552Gearbox · leakingFRA INFLIGHT T071/13, THREE HOURS INTO FLIGHT STATUS MESSAGE DISPLAYED WITH RT ENGINE N3 READING 0 OIL QUANTITY AND RT ENGINE OIL PRESSURE STARTED DROPPING. CREW SHUT DOWN RT ENGINE AND DIVERTED. LANDED OVERWEIGHT AND WITHOUT INCIDENT. SINGLE ENGINE TIME APSDR AALA20040060Coupling · leakingLHR T101/10 WHILE TAXIING NUMBER 10 BRAKE LOCKED UP. AIRCRAFT WAS TOWED TO GATE AFTER MAINTENANCE RELEASED LOCK. REPLACED NUMBER 10 MAIN WHEEL AND BRAKE ASSEMBLIES. ACCOMPLISHED AXLE INSPECTION, NO DAMAGE. FOUND BRAKE QUICK RELEASE COUPLING LEAKING. REPLSDR AALA20031422Battery Pack · inoperativeSEAT MOUNTED EMERGENCY PATH LIGHT IN FIRST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR FIRST CLASS SEAT MOUNTED EMERGENCY PATH LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20031417Battery Pack · inoperativeALL SEAT MOUNTED EMERGENCY LIGHTS IN AFT COACH INOPERATIVE. REPLACED BATTERY PACK FOR ALL SEAT MOUNTED EMERGENCY LIGHTS IN AFT COACH. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20030247Light · not seatedDFW - DURING OVERNIGHT MAINTENANCE, OVERHEAD EMERGENCY EXIT LIGHT FORWARD OF COACH INOPERATIVE. RESEATED EMERGENCY EXIT LIGHT BULB. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021613Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, AFT SEAT MOUNTED EMERGENCY PATH LIGHT AT SEAT 4D HAS ONE LAMP INOPERATIVE. REPLACED AFT SEAT MOUNTED EMERGENCY PATH LIGHT ASSEMBLY AT SEAT 4D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021551Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, RIGHT SIDE R1 CLOSET DOOR EMERGENCY LIGHT ASSEMBLY BROKEN. REPLACED R1 CLOSET DOOR EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021139Light · inoperativeDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY ESCAPE PATH LIGHTING ASSEMBLY AT L1 CLOSET DAMAGED. REPLACED EMERGENCY ESCAPE PATH LIGHTING ASSEMBLY AT L1 CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20020256Light · inoperativeJFK - DURING OVERNIGHT MAINTENANCE, FOUND EMERGENCY ESCAPE PATH LIGHTING AT ROW 44 INOPERATIVE. RESECURED CONNECTOR FOR EMERGENCY ESCAPE PATH LIGHTING AT ROW 44. SYSTEM GRUOND CHECKED NORMAL OPERATION. (M)SDR AALA20020219Idg · failedRIGHT GENERATOR WOULD NOT COME ON LINE AFTER ENGINE START. DEFERRED RIGHT IDG INOPERATIVE AS PER MEL 24-03 AUTH LGW2-182DC-A PLACARD INSTALLED MPM 24-03 ACCOMPLISHED, ENTERED IN MIC. REMOVED AND REPLACED RIGHT ENGINE IDG AS PER MM 24-11-01-4. ALL OPS AND LE
Back to N791AN