N948AN
Service difficulty reports · 189
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 = 'N948AN' 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 = 'N948AN' 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 AALA20120728001Intercostal · crackedINTERCOSTAL BETWEEN STATIONS 312 AND 328 CRACKED AT LEFT BUTTLINE 46. REMOVED AND REPLACED INTERCOSTAL PER AARD 51-10-05 AND BOEING DRAWING 141A5410.SDR AALA20120413003Wire Harness · damagedCREW REPORTED ANTI SKID LIGHT INOPERATIVE ILLUMINATED IN FLIGHT. EMERGENCY DECLARED FLIGHT RETURNED & LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED WIRE HARNESS FROM NUMBER 3 WHEEL WELL TRANSDUCER TO J BOX. SYSTEM GROUND CHECK NORMAL OPESDR AALA20120315016Spar · corrodedNUMBER 1 BOOST PUMP HAS CORROSION AT BONDING JUMPER ATTACH POINT TO FRONT SPAR. REMOVED CORROSION AND INSTALLED UPPER ANGLE REPAIR PER EA B737-57-022458.SDR AALA20120311006Intercostal · crackedINTERCOSTAL BEWEEN FLOORBEAD 328 TO 344 LEFT BUTTLINE 40 HAS VISUAL INDICATION OF CRACK IN UPPER FLANGE. INSTALLED REPLACEMENT INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20120304001Wire · brokenSEAT MOUNTED EMERGENCY LIGHT AT 9D INOPERATIVE. FOUND WIRES OUTBOARD OF 9F BROKEN. REPLACED WIRES. OPS CHECK NORMAL.SDR AALA20120309003Wire Harness · brokenSEAT MOUNTED EMERGENCY EXIT LIGHT ON SEAT 9D INOPERATIVE. REPLACED WIRING HARNESS THAT HAD BROKEN WIRES WITH SERVICEABLE HARNESS ON SEAT 9D EMERGENCY LIGHT TO SIDEWALL OUTLET. OPS CHECK NORMAL.SDR AALA20111102TUL01Skin · damagedNUMBER 5 SLAT SPEED TAPE INTERIM REPAIR PER EA B737-57-009067. FABRICATED AND INSTALLED PERMANENT SKIN SPLICE REPAIR OUTBOARD END NUMBER 5 SLAT PER SRM 57-42-01-2R SHEET.SDR AALA20110206MIA01Transmitter · failedMIA - CREW REPORTED DURING APPROACH AN INDICATION OF SPLIT TRAILING EDGE FLAPS. EMERGENCY DECLARED FLIGHT LANDED MIA WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LEFT FLAP TRANSMITTER. SYSTEM GROUND CHECK NORMAL OPERATION.SDR AALA20101001TUL02Processor · failedPLS - INFLIGHT POP-MIA. CREW REPORTED AIRCRAFT HAD FUEL IMBALANCE AND POSSIBLE FUEL LEAK. LEFT TANK SHOWED 200LB PER MINUTE FUEL LOSS. LEFT ENGINE SHUT DOWN BY CREW PER QRH, SINGLE ENGINE TIME 13 MINUTES. EMERGENCY DECLARED DIVERTED PLS LANDED WITHOUT INCISDR AALA20100802SJU01Lens · missingEXIT LIGHT LENS MISSING AT FORWARD RIGHT SIDE OVERWING EXIT DOOR BETWEEN SEATS 12F AND 13F. REPLACED EXIT LIGHT ASSEMBLY AT FORWARD RIGHT SIDE OVERWING EXIT DOOR. OPS CHECKED NORMAL.SDR AALA20100212TUL05Intercostal · crackedINTERCOSTAL CRACKED STATION 336 LEFT BODY LINE 45.5. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20100212TUL04Intercostal · crackedINTERCOSTAL CRACKED STATION 320 LEFT BODY LINE 45.5. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02-0G.SDR AALA20090915ATL01Lens · brokenSEAT MOUNTED EMERGENCY LIGHT IN AISLE HAS BROKEN LENS. REPLACED LENS FOR SEAT MOUNTED EMERGENCY LIGHT.SDR AALA20090825LAX01Valve · failedLAX - INFLIGHT DFW-SNA. CREW REPORTED DURING CRUISE ANIT-SKID LIGHT FLICKERED. LANDED LAX WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED ANTI-SKID BRAKE VALVE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA2009060200008Engine · fodIAD - INFLIGHT DFW-DCA. LEFT ENGINE COMPRESSOR STALL AND ROLLED BACK TO IDLE ON IT'S OWN. EMERGENCY DECLARED, LANDED IAD WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED NUMBER ONE ENGINE ON JUNE 4 AT IAD DUE TO FOREIGN OBJECT DAMAGE TO COMPRESSORSDR AALA200810244Trunnion · corrodedRIGHT MAIN GEAR FORWARD TRUNNION LUG BORE HAS CORROSION AT OUTBOARD LOWER LUG. REPAIRED PER SRM 57-20-90-2R-2.SDR AALA200810243Trunnion · corrodedRIGHT MAIN GEAR FORWARD TRUNNION LUG BORES HAVE CORROSION AT UPPER OUTBOARD LUG. REPAIRED PER SRM 57-20-90-2R-2.SDR AALA200810242Trunnion · corrodedRIGHT MAIN GEAR FORWARD TRUNNION LUG BORE HAS CORROSION. REPAIRED PER SRM 57-20-90-2R-2.SDR AALA200810241Trunnion · corrodedLEFT FORWARD TRUNNION FITTING INBOARD UPPER FACE ON LEFT HAND MAIN GEAR CORRODED. REPAIRED PER SRM 57-20-90-2R-2.SDR AALA2008100240Trunnion · corrodedLEFT MAIN GEAR FORWARD TRUNNION FITTING LOWER FACE IS CORRODED. REPAIRED PER SRM 57-20-90-2R-2.SDR AALA200810239Trunnion · corrodedLEFT FORWARD MAIN LANDING GEAR TRUNNION UPPER FACE OUTBOARD SIDE HAS CORROSION. ACCOMPLISHED REPAIR IAW SRM 57-20-90-2R-2.SDR AALA200810238Trunnion · corrodedLEFT FORWARD TRUNNION FITTING OUTBOARD FACE ON LEFT MAIN LANDING GEAR HAS CORROSION. ACCOMPLISHED REPAIR IAW SRM 57-20-90-2R-2.SDR AALA200810237Trunnion · corrodedRIGHT MAIN GEAR FORWARD TRUNNION INBOARD LUG FACE HAS CORROSION THAT MEASURES .107 IN DEPTH. REPAIRED PER SRM 57-20-2R-2.SDR AALA200802462Slide · out of positionFLIGHT ATTENDANT REPORTED SLIDE AT FORWARD ENTRY DOOR WAS DISARMED BUT SLIDE HARDPACK CAME OPEN ENOUGH FOR SLIDE TO START TO COME OUT WHEN DOOR OPENED. SLIDE DID NOT COME OUT ENOUGH TO DEPLOY. UNSURE IF LANYARDS WERE UNDER TENSION. REPLACED SLIDE AT FORWARDSDR AALA200802141Light · inoperativeDFW EXTERIOR EMERGENCY LIGHT AT RT AFT OVERWING INOPERATIVE. REPLACED LAMP FOR EXTERIOR EMERGENCY LIGHT AT RT AFT OVERWING. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802140Light · inoperativeDFW EMERGENCY LIGHT AT SEAT ROW 17 INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 17. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802139Light · inoperativeDFW EMERGENCY LIGHT AT SEAT ROW 9 INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 9. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802138Light · inoperativeDFW EMERGENCY LIGHT AT SEAT ROW 27 INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 27. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200802137Light · inoperativeDFW EMERGENCY LIGHT AT SEAT ROW 23 INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT ROW 23. SYSTEM GROUND CHECKED NORMAL OPS.SDR AALA200800234Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK FOR MID TO AFT CABIN RIGHT SIDE INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT MID TO AFT CABIN RIGHT SIDE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200800105Sign · damagedMIA - EMERGENCY EXIT SIGN LIGHT AT RIGHT NUMBER ONE DOOR DAMAGED. REPAIRED EXIT SIGN FOR EMERGENCY LIGHT AT RIGHT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070559Lens · missingMIA - EMERGENCY LIGHT AT SEAT 8D HAS LENS MISSING. REPLACED LENS FOR EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070558Lamp · burned outMIA- EMERGENCY LIGHT AT SEAT 8D INOPERATIVE. RELAMPED EMERGENCY LIGHT AT SEAT 8D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070154Light · inoperativeMIA - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR NEXT TO JUMPSEAT INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR NEXT TO JUMPSEAT. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070153Light · inoperativeMIA - EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070152Light · inoperativeMIA - EMERGENCY LIGHT AT SEAT 20D INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT SEAT 20D. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060598Bulb · inoperativeEMERGENCY LIGHT AT SEAT 14D INOPERATIVE AND HAS CRACKED LENS. REPLACED LENS AND BULB FOR EMERGENCY LIGHT AT SEAT 14D. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040114Battery Pack · inoperativeSNA) EMERGENCY LIGHT AT ROW 7 TO 11 INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT ROWS 7 TO 11. SYSTEM GROUND CHECKED NORMAL OPERATION. --CLOSED--SDR AALA20011325Connector · inoperativeLAX - DURING OVERNIGHT MAINTENANCE, COCKPIT EMERGENCY EXIT DOME LIGHT INOPERATIVE. RE-SEATED COCKPIT EMERGENCY EXIT DOME LIGHT CONNECTOR. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N948AN