N14308, cancelled Mar 21, 2013
Service difficulty reports · 71
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 = 'N14308' AND deregistration_id = 'N14308-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 = 'N14308' AND deregistration_id = 'N14308-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 CALA0200021Nose Cowl · delaminatedINSPECTION FOUND #1 ENGINE NOSE COWL DELAMINATED. THE NOSE COWL WAS REMOVED AND REPLACED IAW MM 71-11-01.SDR CALA9901112Skin · dentedINSPECTION FOUND AFT CARGO DOOR SKIN DENTED. THE DENTED AREA WAS CUT OUT AND A REPAIR DOUBLER WAS INSTALLED IAW SRM 52-30-01, FIGURE 201.SDR CALA9901111Skin · crackedINSPECTION FOUND A .5 INCH CRACK AT O/B FORWARD CORNER OF NR 1 ENGINE PYLON ACCESS PANEL 5727L. THE CRACK WAS STOP DRILLED AND A DOUBLER WAS INSTALLED IAW ECRA 5340-01230.SDR CALA9901108Stringer · crackedINSPECTION FOUND A .5 INCH CRACK IN STRINGER 6L AT STA 277. A STRINGER REPAIR WAS INSTALLED IAW SRM 53-00-03, FIGURE 203.SDR CALA9901105Skin · dentedINSPECTION FOUND FORWARD CARGO DOOR EXTERIOR SKIN DENTED. A DOUBLER WAS INSTALLED IAW SRM 52-00-01, FIGURE 203.SDR CALA9901104Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 967 ABOUT 20 INCHES FROM CENTERLINE TO BOTH LT AND RT SIDES. THE CORRODED SECTION OF FLOORBEAM WAS REPLACED IAW ECRA 5310-03909.SDR CALA9901098Frame · crackedINSPECTION FOUND MAIN FRAME CRACKED AT STA 616, S18L AND S18R. THE CRACKS WERE 1 AND .75 INCH LONG. DOUBLERS WERE INSTALLED IAW ECRA 5360-01024.SDR CALA9901081Galley Track · corrodedINSPECTION FOUND RT O/B GALLEY MOUNT TRACK CORRODED AT STA 328-360. THE MOUNT TRACK WAS REMOVED AND REPLACED IAW SRM 51-30-2 AND 51-10-2.SDR CALA9901075Floorbeam · corrodedINSPECTION FOUND CABIN FLOORBEAM UPPER SURFACE CORRODED AT STA 294 FROM LBL 20 TO RBL 30. THE CORRODED SECTION OF FLOORBEAM WAS REMOVED AND A NEW SECTION WAS INSTALLED USING SPLICE ANGLES IAW SRM 53-10-51, FIGURE 205.SDR CALA9901074Skin · dentedINSPECTION FOUND FUSELAGE SKIN DENTED FROM STA 344-360, WL 190R. A REPAIR WAS INSTALLED IAW SRM 53-00-01, FIGURES 201, 202, AND 223.SDR CALA9901072Stringer · crackedINSPECTION FOUND A .75 INCH CRACK IN STRINGER 16R AT BS 500C. THE CRACKED SECTION OF STRINGER WAS REMOVED AND A NEW SECTION WAS SPLICED IN IAW SRM 53-00-03, FIGURE 201.SDR CALA9901061Skin · dentedINSPECTION FOUND RT FUSELAGE SKIN DENTED AT STA 328, WL 190. THE SKIN WAS REPAIRED IAW SRM 53-00-01.SDR CALA9900222Wire · brokenINSPECTION FOUND ROW 25 EMERGENCY PATH LIGHTING INOPERATIVE. MAINTENANCE FOUND WIRE BROKEN/PULLED FROM SPLICE. THE SPLICE WAS REMOVED AND REPLACED AND OPERATION OF THE EMERGENCY LIGHTING CHECKED GOOD.SDR CALA9701699Skin · corrodedINSPECTION FOUND FUSELAGE SKIN CORRODED BETWEEN STA 986.5 AND 1016, WL 208.10. A REPAIR WAS INSTALLED IAW SRM 53-00-01 AND ECRA 5331-01008.SDR CALA9701677Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED BETWEEN STA 967 TO 986.5, RBL 18. THE FLOOR SUPPORT WAS REMOVED AND REPLACED IAW SRM 51-10-02.SDR CALA9701676Support · corrodedINSPECTION FOUND FLOOR SUPPORT CORRODED BETWEEN BS 986.5 TO 1010, LBL 15. THE FLOOR SUPPORT WAS REPLACED IAW SRM 51-10-02.SDR CALA9701675Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AT STA 967, LBL 4. REPAIRED IAW SRM 53-30-51.SDR CALA9700733Battery Pack · dischargedTHE L-1 AND R-1 DOOR EXIT LIGHTS DID NOT ILLUMINATE WHEN TESTED. MAINTENANCE REMOVED AND REPLACED THE BATTERY PACK.SDR CAL951058Power Supply · inoperativeHOU - THE EMERGENCY EXIT SIGN, BETWEEN ROW 11 AND ROW 12, FAILED THE 15 MINUTE DURATION TEST. THE POWER SUPPLY (CHARGER AND BATTERY) FOR THE EXIT SIGN WAS REMOVED AND REPLACED AND OPERATION WAS RESTORED. (M)SDR CAL950917Dnlock Sensor · inoperativeIAH - FLT 0692 - THE NLG RED UNSAFE LIGHT REMAINED ILLUMINATED AFTER GEAR WAS EXTENDED ON APPROACH TO IAH. THE TOWER REPORTED THE NLG WAS NOT DOWN. DURING A FLY-BY, A VISUAL INSPECTION ALSO CONFIRMED NLG WAS NOT DOWN. CYCLING GEAR TWICE AND USING MANUAL EXTSDR CAL950313Skin · damagedFLT NR 1698 - IAH - HOLE IN FORWARD SIDE OF AIRCRAFT FWD OF L-1 DOOR REPAIRED PER SRM 53-00-01 BLIND RIVIT REPAIR. INSPECTION EVERY 2500 FLT HOURS. REPLACE PRIOR TO 20,000 FLT HOURS. INITIATED DIP NR 24087. (W)
Back to N14308, cancelled Mar 21, 2013