N772AN
Service difficulty reports · 280
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 = 'N772AN' 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 = 'N772AN' 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 AALA20071343Lens · brokenNRT EMERGENCY LIGHT AT FIRST CLASS CLOSET HAS BROKEN LENS. REPLACED LENS FOR EMERGENCY LIGHT AT FIRST CLASS CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070567Hose · leakingDECLARED EMERGENCY FOR ARRIVAL DUE TO AN EN ROUTE LOSS OF HYDRAULIC QUANTITY FROM CENTER HYDRAULIC TANK. CREW USED ALTERNATE METHOD FOR FLAP AND GEAR DEPLOYMENT. LANDED WITHOUT INCIDENT AND HAD SUFFICIENT FLUID TO TAXI TO GATE UNDER OWN POWER. FOUND CENTER SDR AALA20070397Bulb · burned outORD- EMERGENCY EXIT CEILING LIGHT IN FIRST CLASS LEFT AISLE INOPERATIVE. RELAMPED EMERGENCY EXIT CEILING LIGHT IN FIRST CLASS AT LEFT AISLE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061464Light · inoperativeMIA - OVERHEAD EMERGENCY LIGHT AT SEAT ROW 34C INOPERATIVE. RELAMPED OVERHEAD EMERGENCY LIGHT AT SEAT ROW 34C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20061018Light · damagedDFW - EMERGENCY LIGHT AT LEFT NR 1 CLOSET DAMAGED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NR 1 CLOSED. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060968Connector · looseDFW - EMERGENCY LIGHTS AT SEAT ROWS 33 TO 45 LEFT AND RIGHT SIDE INOPERATIVE. SECURED LOOSE CONNECTOR AT SEAT 33D FOR INOPERATIVE EMERGENCY LIGHTS AT SEAT ROWS 33 TO 45 LEFT AND RIGHT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060966Light · missingDFW - EMERGENCY LIGHT AT SEAT 25C HAS MISSING LAMP. RELAMPED EMERGENCY LIGHT AT SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060970Light · missingDFW - EMERGENCY LIGHT AT SEAT 40G HAS MISSING LAMP. RELAMPED EMERGENCY LIGHT AT SEAT 40G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060967Light · inoperativeDFW - OVERHEAD EMERGENCY LIGHT AT BUSINESS CLASS GALLEY INOPERATIVE. REPLACED OVERHEAD EMERGENCY LIGHT AT BUSINESS CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060965Lens · brokenDFW - EMERGENCY LIGHT AT SEAT 25C HAS BROKEN LENS. REPLACED EMERGENCY LIGHT LENS FOR SEAT 25C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060969Lens · brokenDFW - EMERGENCY LIGHT AT SEAT 40G HAS BROKEN LENS. REPLACED EMERGENCY LIGHT LENS AT SEAT 40G. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060648Battery Pack · dischargedDFW - EMERGENCY LIGHTS AT FIRST CLASS CLOSET INOPERATIVE. REPLACED BATTERY PACK M33093 FOR INOPERATIVE EMERGENCY LIGHTS AT FIRST CLASS CLOSET. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060816Battery Pack · dischargedAFW - EMERGENCY LIGHTS AT RIGHT NUMBER FOUR DOOR INOPERATIVE. REPLACED BATTERY PACK FOR INOPERATIVE EMERGENCY LIGHTS AT RIGHT NUMBER FOUR DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060409Lens · missingDFW - EMERGENCY PATH LIGHT LENS MISSING ON SEAT 37C. REPLACED EMERGENCY PATH LIGHT LENS AT SEAT 37C. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041206Battery Pack · inoperativeDFW - EMERGENCY ESCAPE PATH LIGHT IN TOURIST CLASS INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY ESCAPE PATH LIGHT IN TOURIST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041153Wire · brokenDFW - EMERGENCY SEAT LIGHTS IN AFT CABIN INOPERATIVE. REPAIRED SHORT IN WIRE AT ROW 36 FOR EMERGENCY SEAT LIGHTS IN AFT CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20041080Battery Pack · inoperativeDFW - DURING FUNCTIONAL CHECK OF EMERGENCY LIGHTS BATTERY PACKS IN BUSINESS CLASS FAILED TIME TEST. REPLACED BATTERY PACKS AT L2 FOR BUSINESS CLASS EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040037Battery · inoperativeDFW WALL MOUNTED EMERGENCY LIGHTS IN BUSINESS CLASS GALLEY INOPERATIVE. REPLACED BATTERY FOR WALL MOUNTED EMERGENCY LIGHTS IN BUSINESS CLASS GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040071Valve · inoperativeDURING CRUISE DECREASED FUEL NOTED LT MAIN TANK, QTY LT TANK STABILIZED 63,300 LBS. RT MAIN TANK INCREASED 64,500 LBS TO 66,900 LBS WHILE CONTINUING TO USE CENTER TANK FUEL PROBES 18, 19, 20 LT MAIN TANK INDICATED LOWER HEIGHT PROBES 18, 19, 20 RT MAIN TANK. SDR AALA20031384Fuel Tank · malfunctionedEN ROUTE SJC-NRT AN UNWANTED FUEL TRANSFER AS A GRADUAL DECREASE IN FUEL NOTED IN LEFT TANK AND STABILIZED AT 63300 POUNDS WHILE INCREASING IN RIGHT TANK FROM 64500 TO 66900 WHILE USING CENTER TANK. LANDED LAX WITHOUT INCIDENT. A/C FERRY TO DFW FOR FURTHER EVASDR AALA20030251Light · brokenORD - EMERGENCY LIGHT ACROSS FROM L1 DOOR IS BROKE. REPLACED EMERGENCY LIGHT ASSEMBLY. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021899Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, LOWER LEFT FORWARD FACING EMERGENCY ESCAPE PATH LIGHTING AT G-3 GALLEY COAT CLOSET WALL BROKEN. REPLACED LOWER LEFT FORWARD FACING EMERGENCY ESCAPE PATH LIGHTING ASSEMBLY AT G-3 GALLEY COAT CLOSET WALL. SYSTEM GROUND CHECKSDR AALA20021231Light · brokenDFW - DURING OVERNIGHT MAINTENANCE, EMERGENCY LIGHTING ASSEMBLY AT FIRST CLASS LEFT SIDE GALLEY WALL BROKEN. REPLACED EMERGENCY LIGHTING ASSEMBLY AT FIRST CLASS LEFT SIDE GALLEY WALL. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20021025Idg · failedFOUR HOURS INTO FLIGHT, LEFT GENERATOR FAILED. REPLACED LEFT GCU PER MM. REPLACEMENT TEST PASSED MESSAGE CLEARED. LEFT GEN SYS STILL INOPERATIVE ON ENGINE RUN MESSAGE AND NO VOLT OUTPUT. REPLACED LEFT IDDG PER MM. LEAK AND GEN SYS OPS TEST OK.SDR AALA20020975Light · inoperativeDURING OVERNIGHT MAINTENANCE LOWER LEFT HAND FORWARD EMERGENCY ESCAPE PATH LIGHT ASSEMBLY AT G3 GALLEY COAT CLOSET INOPERATIVE. REPLACED LOWER LEFT HAND FORWARD LIGHT ASSEMBLY AT G3 GALLEY. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20020914Adapter · crackedAFW - FOUND ADAPTER CRACKED DURING DEFUELING. SMALL FUEL SPILL OCCURRED. REMOVED CRACK MANIFOLD ADAPTER AND INSTALLED NEW ITEM, LEAK CHECK OK. (M)SDR AALA20011570Light · malfunctionedORD - FLT 47 - EN ROUTE LHR-ORD, EMEREGNCY EXIT LIGHTS ILLUMINATED FOR 2 MINUTES IN FLIGHT 2 HOURS AND 35 MINUTES AFTER TAKEOFF. COULD NOT DUPLICATE FAULT. NO PREVIOUS HISTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20010339Warning System · activatedDFW - FLT 157 - EN ROUTE DFW-KIX, DETECTED FORWARD CARGO FIRE INDICATION AT COCKPIT. DISCHARGED FIRE BOTTLES, DUMPED FUEL, RETURNED DFW AND LANDED WITHOUT FURTHER INCIDENT. (M)SDR AALA20000920Light · brokenDFW - FOUND DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT ASSEMBLY ON LEFT FORWARD CORNER OF GALLEY WALL BROKEN. REPLACED EMERGENCY EXIT LIGHT ASSEMBLY. SYSTEM, GROUND CHECKED NORMAL OPERATION. (M)SDR AALA20000399Oven · smokeLHR - FLT 90 - DURING FLIGHT, FIRST CLASS OVEN NR 2 INOPERATIVE. FAN WOULD NOT TURN. SMOKE CAME FROM EXHAUST AND CIRCUIT BREAKER DID NOT POP OR OPEN. MANUALLY PULLED OUT. CONTINUED FLIGHT AND LANDED LHR WITHOUT INCIDENT. REPLACED OVEN. SYSTEM GROUND CHEC
Back to N772AN