N14337, cancelled Jul 21, 2009
Service difficulty reports · 63
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 = 'N14337' AND deregistration_id = 'N14337-2009-07-21' 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 = 'N14337' AND deregistration_id = 'N14337-2009-07-21' 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 CALA0200075Track · corrodedINSPECTION FOUND CABIN FLOOR R/H FORWARD GALLEY ATTACH TRACK CORRODED AT STA 280-294, RBL43. THE TRACK WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0200070Floor Support · corrodedINSPECTION FOUND CABIN FLOOR SUPPORT CORRODED AT STA 294-312, LBL 12. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-70-12.SDR CALA0200069Floor Support · corrodedINSPECTION FOUND CABIN FLOOR SUPPORT CORRODED AT STA 328-344, LBL 12. THE FLOOR SUPPORT WAS REMOVED AND A NEW SUPPORT WAS INSTALLED IAW SRM 51-30-2.SDR CALA0001464Brake Assy · failedBRAKES FAILED ON TAXI TO GATE. CHECKED BRAKE SYSTEM PER MAINTENANCE MANUAL 32-41-00 ADJ / TEST. ALL SYSTEMS CHECK NORMAL.SDR CALA9802103Module · inopTHE FIRE WARNING LIGHT AND BELL ACTIVATED WHILE ON SHORT FINAL INTO EWR. THE WARNING WAS ON THE GLARESHIELD WITH NO INDICATIONS IN T-HANDLE ON THROTTLE CONSOLE. THE AIRCRAFT LANDED AT EWR WITHOUT INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF FIRE. MAINTENANCESDR CALA9801988Fire Warning · activatedWHEN THE APU WAS STARTED ON DESCENT INTO SAT, THE APU FIRE WARNING LIGHT AND BELL ACTIVATED. THERE WERE NO LIGHTS IN APU FIRE HANDLE OR FOR ENGINES AND NO OTHER ABNORMAL INDICATIONS WERE NOTED. THE APU RAN NORMALLY AND THE LIGHT AND BELL WERE SILENCED. THE AIRSDR CALA9800470Battery · dischargedTHE FORWARD SERVICE DOOR EXIT SIGN FAILED TEN MINUTE BURN DURATION TEST. THE BATTERY WAS REPLACED AND A WIRE WAS RECONNECTED, OPERATIONAL TEST WAS GOOD.SDR CALA9800404Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, RBL 5 TO LBL 40. THE FLOORBEAM WAS REPAIRED IAW SRM 53-10-51, FIGURE 205.SDR CALA9800403Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312 FROM LBL 20 TO RBL 20. A REPAIR ANGLE WAS INSTALLED IAW SRM 53-10-51, PAGE 220-223.SDR CALA9800395Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED BETWEEN FS 967 AND 986.5 LEFT SIDE, 22 INCHES FROM CENTERLINE. A NEW INTERCOSTAL WAS INSTALLED IAW SRM 51-10-2.SDR CALA9800393Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BS 967 UPPER T-CAP, LBL24. REPAIRED IAW SRM 53-00-51, FIGURE 202.SDR CALA9800392Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT BOTH SIDES OF SCREW HOLES TO EDGE OF T-CAP AT STA 986.5. REPAIRED IAW SRM 53-00-51.SDR CALA9700441O-Ring · leakingAIRCRAFT LOST B-SYSTEM HYDRAULIC FLUID AND PRESSURE ON APPROACH. THE LOSS WAS ACCOMPANIED BY ILLUMINATION OF THE HYDRAULIC PUMP LOW PRESSURE LIGHT. MAINTENANCE FOUND ELBOW LOOSE AND A BAD O-RING ON LOWER END OF ACOUSTIC FILTER. THE O-RING WAS REMOVED AND RE
Back to N14337, cancelled Jul 21, 2009