N688SW, cancelled Nov 16, 2012
Service difficulty reports · 306
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 = 'N688SW' AND deregistration_id = 'N688SW-2012-11-16' 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 = 'N688SW' AND deregistration_id = 'N688SW-2012-11-16' 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 SWAA982039Floor · corrodedDURING SCHEDULED 1/4 D-CHECK, FOUND FLOOR PANEL TRANSITION ANGLE CORRODED ALONG UPPER SURFACE AT BS 860, LBL 21, RBL 21. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA982031Floorbeam · damagedDURING SCHEDULED 1/4 D-CHECK, FOUND FOUR HOLES IN FLOORBEAM AT BS 777, RBL 8. REPAIRED PER SRM.SDR SWAA980762Skin · crackedDURING SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED 2.5 LONG ABOVE STR 23R FWD AT BS 727E. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA980761Skin · crackedDURING SERVICE CHECK, FOUND FUSELAGE SKIN CRACKED 2.5 LONG BELOW STR 23R AT BS 727D. REMOVED AND REPLACED PER BOEING SRM.SDR SWAA970591Skin · scratchedDURING SCHEDULED B/C4 CHECK, FOUND FUSELAGE SKIN SCRATCHED 11 IN LENGTH, AT BS 1088. REPAIRED PER BOEING SRM.SDR SWAA970936Battery · dischargedDURING WALKAROUND CHECK, FOUND AFT EMERGENCY FLASHLIGHT INOP. REPLACED BATTERY PER BOEING M/M.
Back to N688SW, cancelled Nov 16, 2012