N923FT, cancelled Dec 21, 2017
Service difficulty reports · 66
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 = 'N923FT' AND deregistration_id = 'N923FT-2017-12-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 = 'N923FT' AND deregistration_id = 'N923FT-2017-12-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 P5CA0100522Skin · corrodedLEVEL 1 CORROSION FOUND ON FUSELAGE SKIN BS 1319 WL 214 AND WL 227. REPAIRED PER SRM 51010-01.SDR P5CA0100521Stringer · corrodedLEVEL 1 CORROSION FOUND ON BS 1700-STR 44 RIGHT, BS 1775- STR 48 RIGHT. SECTION REPLACED PER SRM 53-30-03.SDR P5CA0100520Intercostal · crackedCRACK FOUND ON INTERCOSTAL BULK CARGO BS 2040 LBL-30. REPAIRED PER SRM 53-10-07.SDR P5CA0100519Skin · corrodedLEVEL 1 CORROSION FOUND ON FUSELAGE SKIN BS 2060-STRINGER 46R. REPAIRED PER SRM 51-10-01.SDR P5CA0100518Stringer · corrodedLEVEL 1 CORROSION FOUND ON BS 1765-STRINGER 49R, BS 1640-STRINGER 48L, BS 1920-STRINGER 49L. REPAIRED PER SRM 51-10-01.SDR P5CA0100517Balance Weight · corrodedLEVEL 1 CORROSION FOUND ON BALANCE WEIGHT ONE LEFT OUTBOARD AILERON NR 3 POSITION. REPAIRED PER S/L 747-55-07.SDR P5CA0100516Balance Weight · corrodedLEVEL 1 CORROSION FOUND ON BALANCE WEIGHT THREE LEFT OUTBOARD ELEVATOR. REPAIRED PER S/L 747-55-07.SDR P5CA0100515Balance Weight · corrodedLEVEL 1 CORROSION FOUND ON BALANCE WEIGHT TWO RIGHT OUTBOARD ELEVATOR. REPAIRED PER S/L 747-55-07.SDR P5CA0100513Skin · corrodedLEVEL 1 CORROSION FOUND ON LT WING L/E TOP WING SKIN WS 586 - WBL 470 BULGING AROUND FASTENERS. REPAIRED PER SRM 57-10-01, 51-30-02.SDR P5CA0100512Intercostal · crackedCRACK FOUND ON INTERCOSTALS BS 1960- RBL 30, BS 1960- BL 0, BS 1960- RBL 7.5, BS 1980- LBL 37.5. REPAIRED PER SRM 53-10-07.SDR P5CA0100511Skin · dentedFUSELAGE SKIN DENTED BS 2298-STRINGER 24 LEFT, BS 2433-STRINGER 24L TO S25 LEFT, BS 2184-STRINGER 23L TO S24 LEFT, BS 2191 - STRINGER 23L TO S24 LEFT. REPAIRED PER SRM 51-40-01.SDR P5CA0100510Skin · dentedFUSELAGE SKIN DENTED BS 2298-STRINGER 21 RIGHT, BS 2288 TO 2300 - STRINGERS 22 TO 23 LEFT, BS 2303 - STRINGER 23 LEFT, BS 2306 - STRINGER 24 LEFT. REPAIRED PER SRM 51-40-01.SDR P5CA0100509Skin · dentedFUSELAGE SKIN DENTED AT BS 2309-STRINGER 22 RIGHT, BS 2318-STRINGER 22 LEFT, BS 2324-STRINGER 21 LEFT. REPAIRED PER SRM 51-40-01.SDR P5CA0100508Skin · delaminatedDELAMINATION FOUND ON LT WING, T/E INBOARD MID FLAP BOTTOM SKIN WITH BULGES. REPAIRED PER SRM 51-40-15.SDR P5CA0100507Flap · wornWEAR FOUND ON LEADING EDGE FLAPS - NR 2 - WS 1423, NR 4-WS 1280, NR 7-WS 972, NR 8-WS889, NR 9-WS807. REPAIRED PER SRM 51-40-15.SDR P5CA0100506Skin · chafedDAMAGE FOUND ON LT WING, T/E OUTBOARD FOREFLAP O/B AREA LEADING EDGE CHAFED. REPAIRED PER SRM 51-40-15.
Back to N923FT, cancelled Dec 21, 2017