N14335, cancelled Mar 21, 2013
Service difficulty reports · 75
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 = 'N14335' AND deregistration_id = 'N14335-2013-03-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 = 'N14335' AND deregistration_id = 'N14335-2013-03-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 CALA0100902Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AROUND FASTENER HOLES AT STA 312-328. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0100901Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 312, LBL 20 - RBL 20. THE FLOORBEAM CHORD WAS REMOVED AND REPLACED IAW SRM 51-40-02.SDR CALA0100900Stringer · crackedINSPECTION FOUND A 1/2" CRACK IN STRINGER 16L BETWEEN STA 500C AND 500D. REPAIRED IAW SRM 53-00-03, FIGURE 201, SHEET 6.SDR CALA0100899Floor Support · corrodedINSPECTION FOUND UPPER SURFACE OF FLOOR SUPPORT CORRODED AT STA 294-312, LBL 12. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-40-02 AND 51-10-02.SDR CALA0100898Floor Support · crackedINSPECTION FOUND A .5 INCH CRACK IN FLOOR SUPPORT AT STA 540, LEFT OF BL 0 FLEX JOINT. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100897Floor Support · crackedINSPECTION FOUND A .5 INCH CRACK IN FLOOR SUPPORT AT STA 540 BETWEEN RT I/B AND O/B SEAT TRACKS. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100895Splice · crackedINSPECTION FOUND A 2 INCH CRACK IN STRINGER SPLICE AT STA 907, S4R. A NEW SPLICE WAS INSTALLED IAW SRM 53-40-3.SDR CALA9901364Battery · dischargedL2 EXTERIOR EMERGENCY EXIT LIGHT INOP. REPLACED BATERY PACK PER WD 33-51-21.SDR CALA9701423Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CLIP NUT HOLES CORRODED AT STA 967L, WL 208. A NEW UPPER T-CAP WAS INSTALLED IAW ECRA 5310-03588.SDR CALA9701415Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 312. THE FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 51-10-51.SDR CALA9701414Stringer · crackedINSPECTION FOUND A 1 CRACK IN STRINGER 26L LOCATED JUST OUTBOARD OF LEFT TRUNNION BEARING AT STA 294.5. THE CRACKED AREA WAS REMOVED AND A REPAIR ANGLE WAS INSTALLED IAW ECRA 5310-03590.SDR CALA9701413Flap · delaminatedINSPECTION FOUND UPPER SURFACE OF LT OUTBOARD FOREFLAP DELAMINATED. THE FLAP WAS REMOVED AND REPAIRED IAW ECRA 5750-01450.SDR CALA9701412Battery Pack · dischargedTHE CABIN EMERGENCY LIGHTING ON OVERHEAD BINS AT ROW 3L, 5R, 14R, 16R, 20L, 21R, AND 24L FAILED THE 10 MINUTE DURATION TEST. THE EMERGENCY LIGHT BATTERIES WERE REMOVED AND REPLACED.SDR CALA9701403Flap · delaminatedINSPECTION FOUND DELAMINATION ON AFT INBOARD EDGE OF RT OUTBOARD AFT FLAP. THE FLAP WAS REMOVED AND REPAIRED IAW ECRA 5750-02787.SDR CALA9701399Skin · dentedINSPECTION FOUND A DENT IN FUSELAGE SKIN BELOW AND FORWARD OF R-2 DOOR AT LAP JOINT AND BUTT SPLICE, BS 927, STRINGER 21R. THE SKIN WAS REPAIRED IAW SRM 53-00-01, FIGURE 210.SDR CALA9701406Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED STA 312 AND 344. THE CORRODED AREAS OF FLOORBEAM WERE CUT OUT. FLOORBEAM SECTIONS AND REPAIR ANGLES WERE FABRICATED AND INSTALLED IAW SRM 53-10-51.SDR CALA9701405Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5 LEFT TO RIGHT. THE CORRODED SECTION WAS REMOVED AND A NEW SECTION OF FLOORBEAM WAS FABRICATED AND INSTALLED IAW ECRA 5310-03450.SDR CALA9701407Skin · scratchedINSPECTION FOUND A SCRATCH IN FUSELAGE SKIN AT STA 374-390, S14L TO S15L. THE SCRATCH WAS CUT OUT IAW SRM 53-00-01, FIGURE 201. A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 53-00-01.SDR CALA9701408Skin · dentedINSPECTION FOUND FUSELAGE SKIN DENTED AT STA 380 BELOW S23L. A REPAIR WAS INSTALLED IAW SRM 53-00-01.SDR CALA9601380Transmission · failedTHE FLAPS WOULD NOT EXTEND USING NORMAL SYSTEMS ON APPROACH. WHEN THE ALTERNATE FLAP SYSTEM WAS USED, THE LEADING EDGE DEVICES EXTENDED, BUT THE FLAPS SHOWED .5 DEGREE AND THEN FROZE. THE AIRCRAFT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE NR 8 FLAP TRASDR CAL960556Connector · corrodedDFW - FLT 0624 - THE NR 1 ENGINE OVERHEAT ANNUNCIATOR LIGHT ILLUMINATED IN CRUISE FLIGHT, BUT EXTINGUISHED AFTER 10 SECONDS. WHEN LIGHT CAME ON 2ND TIME, CREW DISENGAGED AUTOTHROTTLES AND SPLIT THROTTLE 74 PERCENT N1 AND 92 PERCENT N2. LIGHT CONTINUED TO GO SDR CAL950985Fire Det Module · inoperativeFLT NR 0118 - IAH - THE APU FIRE WARNING LIGHT ILLUMINATED WHILE CRANKING APU ON SHORT FINAL. THE APU FIRE WARNING HANDLE WAS PULLED, BUT THE LIGHT REMAINED ON. THE APU FIRE BOTTLE WAS DISCHARGED AND THE LIGHT EXTINGUISHED. THE APU AND REAR OF AIRCRAFT WERESDR CAL950874Skin · crackedHOU - INSPECTION FOUND A 1 INCH CRACK IN OUTER SKIN AT INBOARD SIDE OF PYLON OF NR 1 ENGINE PYLON ACCESS CUT OUT. A REPAIR WAS INSTALLED IAW ECRA 5430-01204. (X)SDR CAL950876Shear Tie · brokenHOU - THE SKIN SHEAR TIE AT STA 460 BETWEEN S27R AND S28R WAS FOUND BROKEN DUE TO GROUND DAMAGE. A REPAIR WAS ACCOMPLISHED PER SRM 53-00-07, FIGURE 205, SHEET 2. (X)SDR CAL950875Skin · crackedHOU - INSPECTION FOUND A .5625 INCH CRACK IN RT WING LOWER LEADING EDGE SKIN AT PYLON OUTBOARD MID-SPAR FITTING. A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 51-70-13. (X)
Back to N14335, cancelled Mar 21, 2013