N330SW, cancelled Apr 23, 2012
Service difficulty reports · 208
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 = 'N330SW' AND deregistration_id = 'N330SW-2012-04-23' 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 = 'N330SW' AND deregistration_id = 'N330SW-2012-04-23' 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 SWAA970070Skin · gougedDURING SCHEDULED BC4 CHECK, FOUND A DEEP GOUGE IN FUSELAGE SKIN BELOW L2 DOOR, AT BS 947.6. REPAIRED PER BOEING SRM.SDR SWAA970069Skin · crackedDURING SCHEDULED BC4 CHECK, FOUND FUSELAGE SKIN CRACKED 2.5 INCH LONG AFT OF WING TO BODY FAIRING, BELOW EMERGENCY EXIT LIGHT, BETWEEN S24 AND 25. REPAIRED PER BOEING SRM.SDR SWAA970068Battery · dischargedDURING SCHEDULED TERMINALCHECK, FOUND FWD CABIN FLOOR TRACK LIGHTING INOP. REPLACED BATTERY PACK AND CHARGER PER BOEING M/M.SDR SWAA961275Skin · crackedDURING SCHEDULED C1 CHECK, FOUND FWD GALLEY DOOR UPPER HINGE CUTOUT CRACKED AT LOWER AFT CORNER. REPAIRED PER SWA RA 1-352-0257.SDR SWAA960477Skin · crackedDURING SCHEDULED BC3 CHECK, FOUND FUSELAGE SKIN CRACKED AT BS 755, S23L. REPAIRED PER BOEING SRM.SDR SWAA960275Battery · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND MID CABIN EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK AND CHARGER PER BOEING M/M.SDR SWAA960269Battery · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND MIS CABIN EMERGENCY EXIT LIGHTS INOP. REPLACED BATTERY PACK PER BOEING M/M.SDR SWAA960302Battery Pack · dischargedDURING SCHEDULED TERMINAL CHECK, FOUND FWD ENTRY EMERGENCY EXIT LIGHT INOP. REPLACED BATTERY PACK AND HOUSING PER BOEING M/M.
Back to N330SW, cancelled Apr 23, 2012