N923AN
Service difficulty reports · 171
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 = 'N923AN' 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 = 'N923AN' 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 AALA20110203TUL03Stringer Clip · crackedSTRINGER CLIP CRACKED ON FORWARD SIDE OF STATION 500G FRAME AT STRINGER 26 LEFT. REPLACED STRINGER CLIP ON FORWARD SIDE OF STA 500G FRAME AT STRINGER 26 LEFT PER SRM 51-10-2.SDR AALA20110203TUL02Stringer Clip · crackedSTRINGER CLIP CRACKED ON AFT SIDE OF STATION 500H FRAME AT STRINGER 26 LEFT. REPLACED STRINGER CLIP ON AFT SIDE OF STATION 500H FRAME AT STRINGER 26 LEFT PER SRM 51-10-2.SDR AALA20110203TUL01Stringer Clip · crackedSTRINGER CLIP CRACKED ON FORWARD SIDE OF STATION 500H FRAME AT STRINGER 26 LEFT. REPLACED STRINGER CLIP ON FORWARD SIDE OF STATION 500H FRAME AT STRINGER 26 LEFT PER SRM 51-10-2.SDR AALA20090731TUL08Electronic Unit · defectiveUVF - SHORTLY AFTER TAKEOFF, HAD AN AFT CARGO FIRE WARNING. DISCHARGED FIRE EXTINGUISHER BOTTLE AS PER PROCEDURE. LANDED UVF WITHOUT INCIDENT. REPLACED CARGO EXTINGUISHER BOTTLE, FORWARD CARGO A2 SMOKE DETECTOR, AFT CARGO ELECTRONIC UNIT, AND CARGO FIRE CONSDR AALA20090331TUL31Bulkhead · corrodedCORROSION ON 1088 BULKHEAD AT TOP OF APU INLET DUCT INSIDE JACKSCREW AREA. FABRICATED AND INSTALLED ANGLE PER SRM 51-30 AND 51-40.SDR AALA20090331TUL30Bulkhead · corrodedCORROSION ON 1088 BULKHEAD AT BOTTOM OF APU INLET DUCT INSIDE JACKSCREW COMPARTMENT. FABRICATED AND INSTALLED STRAP PER SRM 51-30 AND 51-40.SDR AALA20090313TUL10Skin · damagedAIRCRAFT EXTERNAL IMPACT DAMAGE AT STATION 328 AT LONGERON 3 LEFT. INSTALLED REPAIR PER SRM 53-00-01-2R3 WITH ESO 61000 DATED 3-5-09 B737-53-005654.SDR AALA200802402ALamp · burned outDFW - OVERHEAD EMERGENCY LIGHT AT SEAT ROW 17ABC INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT AT OVERHEAD SEAT ROW 17ABC. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802401ALight · inoperativeDFW - EMERGENCY LIGHT EXIT IDENTIFIER AT RIGHT NUMBER TWO DOOR INOPERATIVE. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT RIGHT NUMBER TWO DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA200802360ASensor · failedMSP INFLIGHT - TRAILING EDGE FLAPS ASYMMETRY. LANDED MSP WITHOUT INCIDENT. REPLACED NUMBER EIGHT FLAP POSITION SENSOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20071480Relay · inoperativeYYZ INFLIGHT T1084/10AUG - SPEED TRIM FAIL LIGHT ILLUMINATED DURING CLIMB IN CONJUNCTION WITH THE STABILIZER TRIM INOPERATIVE. LANDED YYZ WITHOUT INCIDENT. REPLACED STABILIZER TRIM CUTOUT RELAY R64 AND ACCOMPLISHED STABILIZER TRIM CUTOUT TEST. SYSTEM GROUNDSDR AALA20070658Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN COACH CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20070659Battery Pack · inoperativeTUL - EMERGENCY LIGHT BATTERY PACK IN COACH CABIN FAILED FUNCTIONAL TEST. REPLACED EMERGENCY LIGHT BATTERY PACK IN COACH CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20060290Brake · lockedMEX - ON GROUND AFTER CLEARING RUNWAY NR 2 TIRE BLEW OUT. FOUND BRAKE NUMBER 2 LOCKED. REPLACED NUMBER ONE AND TWO TIRES AND NUMBER TWO BRAKE. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20050626Battery Pack · inoperativeTUL - EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040852Battery Pack · inoperativeBATTERY IN CABIN AT M1694 FAILED TO PASS 15 MINUTE TEST FOR EMERGENCY LIGHTING. REPLACED BATTERY PACK AT CABIN M1694 FOR EMERGENCY LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040853Battery Pack · inoperativeEMERGENCY LIGHT BATTERY IN CABIN AT M1695 FAILED 15 MINUTE TEST. REPLACED BATTERY PACK IN CABIN AT M1695 FOR EMERGENCY LIGHTS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED)SDR AALA20040851Battery Pack · inoperativeTUL - BATTERY IN CABIN AT M1671 FAILED TO SUSTAIN EMERGENCY LIGHTING FOR THE REQUIRED 15 MINUTE MINIMUM. REPLACED BATTERY PACK IN CABIN AT M1671 FOR EMERGENCY LIGHTING. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040836Slide · failedTUL - FORWARD GALLEY DOOR EMERGENCY SLIDE DID NOT AUTOMATICALLY DEPLOY, DEPLOYED MANUALLY. REPLACED SLIDE FOR FORWARD GALLEY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20040624Light · inoperativeDFW - LIGHT ASSEMBLY IN LEFT AFT EMERGENCY DOOR INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY IN LEFT AFT EMERGENCY DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20010833Light · defectiveLAX - DURING OVERNIGHT MAINTENANCE, EMERGENCY EXIT LIGHT AT 13D DIM. REPLACED EMERGENCY EXIT LIGHT AT SEAT 13D. SYSTEM GROUND CHECKED NORMAL OPERATION. (M)
Back to N923AN