N17329, cancelled Mar 21, 2013
Service difficulty reports · 67
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 = 'N17329' AND deregistration_id = 'N17329-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 = 'N17329' AND deregistration_id = 'N17329-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 CALA9700327Support · crackedINSPECTION FOUND A 1.125 INCH CRACK IN FLOOR SUPPORT AT STA 540, AIRCRAFT CENTERLINE, RT SIDE. THE ANGLE WAS REPAIRED IAW SRM 51-70-11.SDR CALA9700322Skin · crackedINSPECTION FOUND THE NR 5 LEADING EDGE SLAT CRACKED AT THREE RIVETS UNDER INBOARD AUXILIARY TRACK. THE CRACKS WERE .25 INCH LONG. A DOUBLER AND FILLER REPAIR WAS INSTALLED IAW ECRA 5750-01159.SDR CALA9700321Skin · crackedINSPECTION FOUND A .25 INCH CRACK AT TWO RIVETS (SIX INCHES INBOARD OF ACTUATOR) ON NR 6 LEADING EDGE SLAT. THE SLAT WAS REPAIRED IAW ECRA 5750-01159.SDR CALA9700320Skin · crackedINSPECTION FOUND A .50 INCH CRACK AT RIVET HOLE OF NR 1 ENGINE PYLON PANEL NR 5724. A DOUBLER WAS INSTALLED IAW ECRA 5430-01204.SDR CALA9601616Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED AT NUTPLATE HOLES, STA 995-1016, LBL 37.21. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-2.SDR CALA9601618Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT STA 967. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03362.SDR CALA9601617Floorbeam · corrodedINSPECTION FOUND UPPER SURFACE OF FLOORBEAM CORRODED AT NUTPLATE HOLE, STA 1006, RBL 20. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03360.SDR CALA9601615Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED BETWEEN STA 947-967, RBL 17.61. THE INTERCOSTAL WAS REPLACED IAW SRM 51-40-2.SDR CALA9601614Intercostal · corrodedINSPECTION FOUND FLOOR SUPPORT INTERCOSTAL CORRODED BETWEEN STA 967-986.5, LBL 17.61. THE FLOOR SUPPORT INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-2.SDR CALA9601613Floorbeam · corrodedINSPECTION FOUND FLOORBEAM AT STA 986, LBL 15 TO DOOR SILL AREA CORRODED. THE AREA WAS REPAIRED IAW ECRA 5310-03361.SDR CALA9601611Floorbeam · corrodedINSPECTION FOUND RT SIDE AND CENTER OF FLOORBEAM CORRODED AT STA 986.5, RBL 3, RBL 5, AND RBL 15. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03361.SDR CALA9601610Floorbeam · corrodedINSPECTION FOUND FLOORBEAM CORRODED AROUND FASTENER HOLE AT STA 986.5, RBL 40. THE FLOORBEAM WAS REPAIRED IAW ECRA 5310-03361.SDR CALA9601609Intercostal · corrodedINSPECTION FOUND FLOOR SUPPORT INTERCOSTAL CORRODED BETWEEN STA 947 AND 967, LBL 17.61. THE FLOOR SUPPORT INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-2.SDR CALA9601608Intercostal · corrodedINSPECTION FOUND INTERCOSTAL CORRODED BETWEEN STA 967 AND 986, RBL 18.75. THE INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-10-2 AND 51-40-2.SDR CALA9601607Intercostal · corrodedINSPECTION FOUND FLOOR SUPPORT INTERCOSTAL CORRODED AT STA 986-1016, LBL 15. THE FLOOR SUPPORT INTERCOSTAL WAS REMOVED AND REPLACED IAW SRM 51-40-2.SDR CALA9601612Angle · corrodedINSPECTION FOUND FLOOR SUPPORT ANGLE AT AFT SIDE OF L-2 DOOR FRAME CORRODED AT STA 986.5. THE SUPPORT ANGLE WAS REMOVED AND REPLACED IAW SRM 51-10-2 AND 51-40-2.SDR CALA9601606Floorbeam · corrodedINSPECTION FOUND AFT RIGHT LAV WALL FLOORBEAM CORRODED. THE AREA WAS REPAIRED IAW ECRA 5310-03361.
Back to N17329, cancelled Mar 21, 2013