N16301, cancelled Mar 21, 2013
Service difficulty reports · 89
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 = 'N16301' AND deregistration_id = 'N16301-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 = 'N16301' AND deregistration_id = 'N16301-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 CALA0300150Floorbeam · corrodedINSPECTION FOUND PASSENGER CABIN FLOORBEAM CORRODED AT BS 294.5, LBL 20 TO RBL 23. THE UPPER FLOORBEAM WAS REPLACED IAW SRM 53-10-51, FIGURE 205.SDR CALA0300146Skin · gougedINSPECTION FOUND LT HORIZONTAL STABILIZER LEADING EDGE SKIN GOUGED IN FOUR PLACES FROM STA 231-272. THE SKIN WAS REPAIRED IAW SRM 55-10-01, FIGURE 203.SDR CALA0300145Skin · dentedINSPECTION FOUND AFT CARGO DOOR SKIN DENTED BETWEEN STA 816 AND 819. REPAIRED DOOR IAW SRM 52-00-01, FIGURE 203.SDR CALA0300143Skin · gougedINSPECTION FOUND LT HORIZONTAL STABILIZER LEADING EDGE SKIN GOUGED IN TWO LOCATIONS: STABILIZER STATION 107.5 AND 289.1. THE AREAS WERE REPAIRED IAW SRM 55-10-1, FIGURE 203, SHEETS 1 & 2.SDR CALA0300142Frame · corrodedINSPECTION FOUND AFT CARGO COMPARTMENT LOWER LOBE INTERIOR FRAME CORRODED AT BS 847 BETWEEN S28L AND S28R. THE FRAME WAS REPAIRED IAW SRM 53-00-07, FIGURE 208.SDR CALA0100551Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 986.5, LBL 48. THE TOP CAP OF FLOORBEAM WAS REPLACED IAW ECRA 5310-03851.SDR CALA0100548Channel · corrodedINSPECTION FOUND HAT CHANNEL AND MOUNT FLANGE CORRODED AT STA 990, RBL 40. THE HAT CHANNEL AND MOUNT FLANGE WERE REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100544Angle · cutINSPECTION FOUND TOOLING MARKS CUT INTO L-2 DOOR Z-ANGLE AT STA 967-985. THE ANGLE WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100543Floor Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED AT FS 986.5-1006, RBL 17. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0100542Frame · crackedINSPECTION FOUND A 1" CRACK IN FRAME AT STA 727E, RBL 1. THE FRAME WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA0000031Unknown · smokeTHE SMOKE ALARM ACTIVATED IN THE LEFT AFT LAV WHILE AT CRUISE EN ROUTE TO IAH. THE FLIGHT ATTENDANT OBSERVED SMOKE COMING FROM THE AFTLAV TRASH CONTAINER. BOTH THE HALON AND WATER FIRE EXTINGUISHERS WERE DISCHARGED INTO THE TRASH CONTAINER. THE SMOKE CEASEDSDR CALA9901676Engine · failedTHE NR 1 ENGINE AUTO SHUTDOWN WITH NO ABNORMAL INDICATIONS WHILE ON APPROACH TO ATL. AN ENGINE RESTART WAS ATTEMPTED. UPON ENGINE SPOOL UP THE OIL PRESSURE AND QUANTITY BEGAN TO DECREASE. THE RESTART WAS ABORTED AND THE ENGINE WAS SECURED. THE AIRCRAFT LANDSDR CALA9900185Stringer · corrodedINSPECTION FOUND STRINGER 26L CORRODED UNDER TRANSITION PANEL AT STA 500A TO 500B. THE CORRODED SECTION OF STRINGER WAS REMOVED AND A NEW SECTION WAS SPLICED IN IAW SRM 53-00-03, FIGURE 201.SDR CALA9900152Seat Track · corrodedINSPECTION FOUND SEAT TRACK CORRODED BETWEEN STA 277 TO 294. THE SEAT TRACK WAS REMOVED AND A NEW TRACK WAS INSTALLED IAW SRM 53-00-02, FIGURE 202.SDR CALA9900147Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 344, LBL 52 TO RBL 10. A NEW FLOORBEAM CAP WAS INSTALLED IAW SRM 53-10-51.SDR CALA9900146Seat Track · corrodedINSPECTION FOUND LT O/B SEAT TRACK CORRODED AT STA 344 TO 360. THE SEAT TRACK WAS REPAIRED IAW SRM 53-00-52.SDR CALA9900131Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 312, LBL 10 TO RBL 36. A SPLICE REPAIR WAS INSTALLED IAW SRM 53-10-51.SDR CALA9900122Seat Track · corrodedINSPECTION FOUND LT I/B SEAT TRACK CORRODED AT STA 344 TO 360. THE SEAT TRACK WAS REMOVED AND A NEW SEAT TRACK WAS INSTALLED IAW SRM 53-00-52.SDR CALA9700316Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED IN THREE PLACES AT STA 312. THE CORRODED AREAS OF FLOORBEAM WERE CUT OUT, REPAIR DOUBLERS WERE FABRICATED AND INSTALLED IAW SRM 51-20-01 AND 53-10-51. A 23 SECTION OF UPPER T-CHORD WAS REPLACED.SDR CALA9601215Wire · shortedINSPECTION FOUND FLOOR TRACK LIGHTING AT FIRST FOUR SEATS ON LT SIDE OF AIRCRAFT INOPERATIVE DURING A SERVICE CHECK. MAINTENANCE FOUND WIRE SHORTED TO AIRFRAME AT FORWARD COAT CLOSET. THE WIRE WAS REPAIRED AND OPERATION OF THE FLOOR TRACK LIGHTING CHECKED GOSDR CAL950331Beam · crackedDHM - FLOOR BEAM CRACKED NEAR TOP OF WEB FS 520 RBL 45.5 LENGTH OF CRACK APPROXIMATELY .75 INCH. INSTALLED REPAIR ANGLE PER IAW ECRA 5320-01239. (W)SDR CAL950335Frame · crackedFORWARD BAGGAGE FRAME CRACKED AT STRINGER LEVEL, STRINGER 27R TO STRINGER 28R, STATION 460 CRACK LENGTH .75 INCH. REPAIR IAW 53-00-07 FIG 204 MANUFACTURE FRAME, CLIP HEAT TREATED, DRILLING, DEBURR, ALODINE, PRIME AND INSTALLED. (W)SDR CAL950334Fitting · crackedDHM - FITTING CRACKED ON HORIZONTAL STABILIZER CENTER SECTION, STATION 1121 BL 12R AFT END OF FITTING CRACKED .25 INCH. REMANUFACTURE NEW FITTING PER SRM 55-10-3. (W)SDR CAL950333Support Angle · crackedDHM - TRACK SUPPORT ANGLE CRACKED END INBOARD SIDE FS 519 RBL 45.5 CRACKED APPROXIMATE .375 INCH MANUFACTURE AND INSTALLED ANGLE REPAIR PER SRM 51-70-11. (W)SDR CAL950332Support Angle · crackedDHM - TRACK SUPPORT ANGLE CRACKED AT END ON INBOARD SIDE OF WEB FS 519 RBL 24.75 CRACK APPROXIMATELY .375 INCH. REPAIRED BY INSTALLED REPAIR ANGLE PER SRM 53-30-51. (W)SDR CAL950330Support Channel · crackedDHM - SUPPORT CHANNEL CRACKED AFT OF FLOOR BEAM FS 520 RBL 45.5 LENGTH APPROXIMATELY 1 INCH. REPAIRED PER IAW ECRA 5320-01239 REPLACED. (W)SDR CAL950329Beam · web crackedDHM - FLOOR BEAM TOP OF WEB CRACKED FS 520 LBL 45.5. INSTALLED REPAIR ANGLE PER IAW ECRA 5320-01239. (W)SDR CAL950328Support Channel · crackedDHM - SUPPORT CHANNEL CRACKED AFT OF FLOOR BEAM FS 520 LBL 45.5 APPROXIMATE LENGTH 1 INCH. REPAIRED PER IAW ECRA 5320-01239 REPLACED. (W)SDR CAL950327Floor Beam · crackedDHM - FLOOR BEAM CRACKED NEAR TOP OF WEB FS 520 LBL 24.75 APPROXIMATE LENGTH IS .75 INCH. INSTALLED REPAIR ANGLE PER IAW ECRA 5320-01234. (W)SDR CAL950326Support Channel · crackedDHM - SUPPORT CHANNEL CRACKED AFT SIDE OF FLOOR BEAM AT FS 520 LBL 24.75 LENGTH OF CRACK .74 INCH. REPAIRED PER IAW ECRA 5320-01239. (W)SDR CAL950325Support Angle · crackedDHN - SEAT TRACK ANGLE SUPPORT CRACKED AT OUTBOARD END SIDE OF WEB FS 519 LBL 24.75 .5 INCH IN LENGTH. INSTALLED ANGLE REPAIR PER IAW ECRA 5320-01239. (W)SDR CAL950303Floorbeam · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON RT AFT FLOORBEAM AT FS 967, RBL 41. THE CORRODED AREA WAS REMOVED AND REPAIRED IAW ECRA 5310-01102. (W)SDR CAL950301Floor Support · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON RT AFT LAV ANGLE FLOOR SUPPORT AT STA 986 TO 1016. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-02 AND ECRA 5310-01102. (W)SDR CAL950302Floorbeam · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON AFT FLOORBEAM AT FS 986 RBL 15. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-01102. (W)SDR CAL950300Floorbeam · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON TOP CAP OF FLOORBEAM AT FS 1006, BL 0. THE CORRODED AREA WAS CUT OUT. REPAIR ANGLES WERE FABRICATED AND INSTALLED IAW ECRA 5310-01102. (W)SDR CAL950299Support · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON FLOOR SUPPORT BETWEEN FS 294.5 AND FS 312, LBL 18. REPAIR WAS PERFORMED IAW ECRA 5320-01270. (W)SDR CAL950298Floorbeam · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION AT CLIP NUTS FOR FLOORBEAM TOP CAP AT STA 294.5, LBL 40 TO RBL 40. REPAIR WAS PERFORMED IAW ECRA 5310-01102. (W)SDR CAL950297Floorbeam · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON FLOORBEAM TOP CAP AT FS 312, LBL 20 TO RBL 30. THE TOP CAP WAS REMOVED AND REPAIR ANGLES AND TOP CAP WERE INSTALLED IAW ECRA 5310-01102 AND SRM 51-40-4. (W)SDR CAL950296Floorbeam · corrodedDHN - INSPECTION FOUND INTERGRANULAR CORROSION ON FLOORBEAM TOP CAP AT STA 328, LBL 20 TO RBL 40. THE FLOORBEAM CAP WAS REPLACED FROM LBL 65 TO RBL 65 IAW SRM 51-40-4. (W)
Back to N16301, cancelled Mar 21, 2013