N14334, cancelled Mar 21, 2013
Service difficulty reports · 76
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 = 'N14334' AND deregistration_id = 'N14334-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 = 'N14334' AND deregistration_id = 'N14334-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 CALA0100802Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 294, LBL 28 TO RBL 14. THE CORRODED SECTION OF CHORD WAS CUT OUT AND A NEW SECTION WAS SPLICED IN IAW SRM 53-10-51, FIGURE 205.SDR CALA0100785Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1006, LBL 18. THE "T" CAP OF FLOORBEAM WAS REMOVED AND REPLACED IAW ECRA 5310-03851.SDR CALA0100784Stringer · crackedINSPECTION FOUND A 1" CRACK IN STRINGER 16R AT STA 500C-500D. THE CRACKED SECTION OF STRINGER WAS REMOVED AND A NEW SECTION WAS INSTALLED IAW SRM 53-30-03.SDR CALA0100780Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT STA 294-312, LBL 12. A NEW FLOOR SUPPORT WAS INSTALLED IAW SRM 51-10-02.SDR CALA0100765Splice · crackedINSPECTION FOUND A .125 INCH CRACK IN STRINGER SPLICE 4L AT STA 907. THE STRINGER SPLICE WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100205Wire · damagedTHE FLOOR TRACK LIGHTS IN FIRST CLASS SECTION OF CABIN WERE FOUND INOPERATIVE. MAINTENANCE FOUND WIRES DAMAGED NEAR ROW 1 LEFT. THE WIRES WERE REPAIRED AND THE BLOWN FUSE IN POWER SUPPLY WAS REPLACED IAW MM 20-10-13.SDR CALA0001248Panel · dentedINSPECTION FOUND LEADING EDGE OF HORIZONTAL STABILIZER I/B RIGHT SIDE DENTED. THE LEADING EDGE WAS REPAIRED IAW SRM 55-10-01, PAGE 207-208.SDR CALA0000158Warning System · activatedTHE MASTER CAUTION LIGHT, OVERHEAT/DETECT LIGHT, AND CARGO DETECTION SUPRESSION FAIL LIGHT ILLUMINATED WHILE EN ROUTE FROM IAH TO SJC. THE AIRCRAFT WAS DIVERTED TO PHX WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF FIRE. THE FIRE AND SMOKSDR CALA9901292Sensor · out of adjustTHE LANDING GEAR WOULD NOT RETRACT AFTER TAKEOFF FROM IAH. THE OVERRIDE TRIGGER WAS USED PER QRH. THE AIRCRAFT WAS RETURNED TO IAH WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND THE AIR SAFETY SENSOR OUT OF RIG. THE SENSOR WAS ADJUSTED IAW MM 32-09-01.SDR CALA9901284Skin · crackedINSPECTION FOUND A .25 INCH CRACK IN NR 1 LT WINDOW CUTOUT. REPAIRED IAW ECRA 5330-02877.SDR CALA9801948Skin · pittedFOUND EVIDENCE OF LIGHTNING STRIKE JUST BELOW CAPTAINS SLIDING WINDOW. BURNISHED DAMAGE PER SRM 53-00-01. ISSUED DIP FOR PERMANENT REPAIR.SDR CALA9800331Bearing · failedTHE AIRCRAFT WAS DIVERTED TO SHV AFTER THE NR 2 ENGINE GAVE OFF TWO LOUD BANGS FOLLOWED BY AIRCRAFT VIBRATION AND WITH THE NR 2 ENGINE GOING TO IDLE. THE AIRCRAFT LANDED AT SHV WITHOUT INCIDENT. MAINTENANCE FOUND THE NR 2 ENGINE GEARBOX AFT CHIP DETECTOR FULSDR CALA9701802Door · crackedINSPECTION FOUND A 1.875 INCH CRACK IN LOWER FORWARD CORNER OF FORWARD CARGO DOOR. THE FORWARD CARGO DOOR WAS REMOVED AND REPLACED. THE DOOR AND STOPS WERE ADJUSTED IAW MM 52-31-00, LEAK AND OPERATIONAL CHECKS WERE GOOD.SDR CALA9701363Safety Sensor · out of adjustTHE GEAR LEVER WOULD NOT RAISE PAST THE OFF POSITION ON FIRST ATTEMPT AFTER TAKEOFF. THE GEAR HANDLE RAISED TO THE UP POSITION AFTER SEVERAL ATTEMPTS AND THE FLIGHT PROCEEDED WITHOUT FURTHER PROBLEM. MAINTENANCE FOUND THE MLG AIR SAFETY SENSOR OUT OF ADJUSTMSDR CALA9701336Foreflap · delaminatedINSPECTION FOUND LT INBOARD TRAILING EDGE FOREFLAP DELAMINATED ON UPPER SURFACE. THE LT INBOARD TRAILING EDGE FOREFLAP WAS REMOVED AND REPLACED IN REFERENCE TO SRM 51-70-10.SDR CALA9701335Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1016, LBL 10 TO LBL 30. REPAIRED FLOORBEAM IAW SRM 53-00-51.SDR CALA9701334Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 1006, LBL 14 TO LBL 20. THE FLOORBEAM WAS REPAIRED IAW SRM 53-00-51.SDR CALA9701333Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 967, RBL 40 TO LBL 40. THE UPPER T-CHORD SECTION WAS REMOVED AND REPAIR WAS INSTALLED IAW ECRA 5310-03570 AND 5310-03450.SDR CALA9701331Battery Pack · dischargedTHE EMERGENCY LIGHT CAPACITY CHECK FAILED AT BS 662 ON RT SIDE. THE BATTERY CHARGER AND BATTERY PACK WERE REMOVED AND REPLACED.SDR CALA9701330Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM UPPER CHORD AT STA 986, LBL 24 TO RBL 24. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW SRM 53-00-51.SDR CALA9701329Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 312, LBL 8 TO RBL 24. THE CORRODED AREA WAS REMOVED, A NEW SECTION OF BEAM WAS FABRICATED AND INSTALLED IAW SRM 53-10-51, FIGURE 205.SDR CALA9701328Floorbeam · corrodedINSPECTION FOUND CORROSION ON FLOORBEAM AT STA 947, RBL 4. THE FLOORBEAM UPPER CHORD WAS REPLACED IAW SRM 53-00-51.SDR CALA9701280Skin · dentedA DENT IN THE AFT CARGO DOOR SKIN THAT HAD BEEN DEFERRED WAS REPAIRED PERMANENTLY. THE DENT WAS REMOVED AND A DOUBLER WAS INSTALLED IAW SRM 52-00-01.SDR CALA9701254Floorbeam · corrodedINSPECTION FOUND FLOORBEAM UPPER CHORD CORRODED AT STA 328, RBL 7 TO 63. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND REPLACED IAW SRM 53-10-51.SDR CALA9701249Skin · scratchedINSPECTION FOUND A SCRATCH IN LT FUSELAGE SKIN AT STA 460, STRINGER 23L. THE SCRATCHED AREA WAS ROUTED OUT. A DOUBLER WAS FABRICATED AND INSTALLED IAW SRM 53-00-01.SDR CAL960240Fire Detector · inoperativeFLT NR 1603 - DCA - THE APU FIRE WARNING LIGHT AND BELL ACTIVATED IN FLIGHT. THE FIRE BOTTLE WAS DISCHARGED, BUT THE FIRE WARNING LIGHT REMAINED ILLUMINATED. THE AIRCRAFT WAS RETURNED TO DCA WHERE IT LANDED WITHOUT INCIDENT. MAINTENANCE FOUND NO EVIDENCE OF
Back to N14334, cancelled Mar 21, 2013