N992AJ, cancelled Aug 15, 2006
Service difficulty reports · 26
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 = 'N992AJ' AND deregistration_id = 'N992AJ-2006-08-15' 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 = 'N992AJ' AND deregistration_id = 'N992AJ-2006-08-15' 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 NACA20040060Annunciator · faultyNOSE LANDING GEAR DID NOT RETRACT. MAIN LANDING GEAR ONLY PARTIAL RETRACTION. FOUND INDICATION TO BE FAULTY AND REPLACED GEAR POSITION ANNUNCIATOR PANEL. PERFORMED RETRACTION TEST WITH NO DISCREPANCIES IAW BMM 32-31-2.SDR NACA20040041Depressor · bentRETURNED TO ANCHORAGE DUE TO LOW CABIN PRESSURE. FOUND MCD SEAL DEPRESSOR AT FORWARD LOWER CORNER BENT. RECONTOURED DEPRESSOR. DOOR FUNCTIONED GOOD.SDR NACA20040039Switch · out of adjustMAIN CARGO DOOR UNLOCKED LIGHT CAME ON IN FLIGHT. VERIFIED MAIN CARGO DOOR CLOSED AND LOCKED. DEFERRED LIGHT ASSEMBLY. REPLACED LATCH PIN ROD ACTUATOR CHECK VALVE, INSPECTED ALL WARNING SWITCHES AND WIRING WITH NO DEFECTS FOUND. TESTED PER FED-EX MM 52-70SDR NACA20040026Filter · carbonedNR 3 ENGINE SHUT DOWN DUE TO LOW OIL PRESSURE/BYPASS LIGHT ILLUMINATED ON CLIMBOUT. REMOVED NR 3 ENGINE OIL SCREEN, INSPECTED AND FOUND CARBON ON FILTER. REPLACED FILTER WITH NEW. OP AND LEAK CHECK GOOD.SDR NACA20040019Gasket · wornNR 1 ENGINE STRUT OVERHEAT LITE CAME ON DURING CLIMB. RETARDED THROTTLES AND LITE WENT OUT. RE-APPLIED CLIMB POWER AND LITE CAME BACK ON. REPLACED WING ANTI-ICE HIGH PRESSURE SHUT-OFF VALVE GASKETS. CHECKED GOOD.SDR NACA20040016Line · looseNR 2 ENGINE SHUT DOWN DUE TO OIL QUANTITY AND PRESSURE WENT TO ZERO. FOUND NR 2 ENGINE OIL PRESSURE TRANSMITTER PRESSURE LINE LOOSE. REMOVED AND INSPECTED LINE, NO DEFECTS FOUND. RE-INSTALLED PRESSURE LINE. LEAK & OP CHECKED GOOD.SDR NACA20040013Fitting · leakingNR 2 ENGINE SHUT DOWN DUE TO LOSS OF OIL PRESSURE AND OIL QUANTITY. REPLACED NR 2 ENGINE OIL LINE FITTING AT LT SIDE OF GEARBOX. INSPECTED NR 2 ENGINE CHIP DETECTORS AND MAIN OIL SCREEN. OP AND LEAK CHECK GOOD.SDR NACA20040010Bearing · seizedOUTBOARD FLAPS STUCK AT 3.5 DEGREES DURING FLAP RETRACTION. REPLACED BEARINGS IN RIGHT HAND OUTBOARD SEQUENCING CARRIAGE, SEQUENCING TOGGLES.SDR NACA20040008Duct · crackedNR 3 ENGINE FIRE WARNING LIGHT ON APPROACH. RETARDED THROTTLE AND LIGHT WENT OUT. FOUND 13TH STAGE BLEED DUCT CRACKED IN HALF AT COWL ANTI-ICE VALVE. REPLACED DUCT. FOUND 8TH STAGE CHECK VALVE LEAKING, AND 8TH STAGE DUCT IN STUB WING LEAKING. REPLACED DSDR NACA20030130Bearing · seizedDISCREPANCY: OB FLAPS WOULD NOT RETRACT PAST 4 DEGREES. REPLACED RT OB FLAPS, OB AND IB CARRIAGE TOGGLE DUE TO SEIZED BEARINGS. CHECKED GOOD.SDR NACA20030126Fire Loop · out of adjustNR 3 ENGINE FIRE DETECTOR LIGHT ON IN FLIGHT. ADJUSTED NR 3 ENGINE FIRE LOOP AWAY FROM COWLING, LIGHT EXTINGUISHED. FIRE LOOP WAS REPLACED ON PREVIOUS LOG SHEET/FLIGHT. CHECKED GOOD.SDR NACA20030118Terminal · brokenCARGO DOOR UNLOCKED LIGHT ILLUMINATED DURING TAKEOFF ROLL. REPLACED BROKEN TERMINAL RING AND REATTACHED TO NR 3 LATCH WARNING SWITCH.SDR NACA20030117Switch · looseMAIN CARGO DOOR UNLOCKED LIGHT ILLUMINATED ON TAKE OFF ROLL. FOUND TWO LATCH INDICATOR SWITCHES LOOSE WHILE LATCHED. TIGHTENED SWITCHES AND ROLLER CONTACTOR, OP CHECKED GOOD.SDR NACA20030107Pressure Switch · false indicationNR 3 ENGINE SHUT DOWN DUE TO OIL FILTER BYPASS/LOW OIL PRESSURE LIGHT ILLUMINATED. INSPECTED FILTER, CHECKED GOOD AND WAS REPLACED. REPLACED LOW OIL PRESSURE SWITCH. OP & LEAK CHECKED GOOD.SDR NACA20030090Smoke Detector · false indicationLOWER COMPARTMENT FIRE WARNING CAME ON DURING TAXI. REPLACED AFT BELLY FORWARD SMOKE DETECTOR.SDR NACA20030087Indicator · sticksDURING FLAP RETRACTION INBOARD FLAPS INDICATED MOVEMENT STOPPED AT 4 DEGREES. REPLACED FLAP POSITION INDICATOR, CHECKED GOOD.SDR NACA20020043Actuator · crackedDiscrepancy: On approach to ANC, loss of "A" hydraulic system.Corrective Action: Replaced nose gear lock actuator.SDR NACA20020033Duct · brokenNR 2 ENGINE FIRE WARING LIGHT AND BELL ON CLIMBOUT, OUT OF ANCHORAGE. WARNING LIGHT WENT OUT WHEN POWER WAS REDUCED TO IDLE. REPLACED 13TH STAGE ANTI-ICE LINE.SDR NACA20020026Gearbox · seizedDISCREPANCY: #3 engine failure in flight. N¹ - 16%, N² - 2%, oil pressure 2 PSI.CORRECTIVE ACTION: Replaced the #3 engine.SDR NACA20020009Case · crackedNR 3 ENGINE HIGH N2, LOW N1, HIGH EGT, HIGH F/F AT CRUISE AND HIGHER POWER SETTINGS. SURGE BLEED VALVE MOUNT FAILURE, REPLACED ENGINE.SDR NACA20020004Fitting · leakingENGINE NR 3 SHUT DOWN AT 1850Z DUE TO LOSS OF OIL PRESSURE AND QUANTITY. RESEALED RESTRICTOR UNION AND TIGHTENED LINE AT TRANSMITTER T-FITTING, SERVICED ENGINE WITH OIL. OPS CHECK GOOD.SDR NACA200000026Uplock Switch · malfunctionedDISCREPANCIES: LEFT GEAR TRANSIT LIGHT STAYS ON WHEN GEAR HANDLE IN UP POSITION.CORRECTIVE ACTION: REPLACED MLG UPLOCK SWITCH.SDR AAPUplock Switch · malfunctionedDISCREPANCIES: LEFT GEAR TRANSIT LIGHT STAYS ON WHEN GEAR HANDLE IN UP POSITION. REPLACED MLG UPLOCK SWITCH.SDR 99ZZZX4082O-Ring · wornIN-FLIGHT, SHUT DOWN OF NR 3 ENGINE DUE TO LOW OIL PRESSURE/QUANTITY INDICATION. AIRCRAFT RETURNED TO KATL. MAINTENANCE REPLACED O-RING ON OIL LINE BANJO FITTING FORWARD OF STARTER.SDR 98ZZZX1445Fitting · corrodedAIRCRAFT UNDERGOING A C-CHECK INSPECTION. THE RT WING TERMINAL FITTING STA 870 WAS FOUND CORRODED BEYOND SRM LIMITATIONS.SDR 98ZZZX1444Fitting · corrodedAIRCRAFT UNDERGOING A C-CHECK INSPECTION. THE RT WING TERMINAL FITTING STA 870 WAS FOUND CORRODED BEYOND SRM LIMITATIONS.
Back to N992AJ, cancelled Aug 15, 2006