N308SW, cancelled Aug 30, 2018
Service difficulty reports · 105
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 = 'N308SW' AND deregistration_id = 'N308SW-2018-08-30' 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 = 'N308SW' AND deregistration_id = 'N308SW-2018-08-30' 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 SWIA971300Deice Boot · failedON CLIMB, LEFT OUTBOARD STABLIZER DEICE BOOT FAILED, BOTH TIMERS. RETURNED TO FIELD. RAN BOTH ENGINES BUT COULD NOT DUPLICATE ON GROUND ON ALL SETTINGS. OPS CHECKS GOOD.SDR SWIA971297Annunicator · malfunctionedDISAGREEMENT INDICATION WITH FLAPS UP FROM 15 DEGREES. RETURNED TO FIELD. REPLACED ANNUNICATOR UNIT IAW MM 27-50-05, OPS CHECKS GOOD.SDR SWIA971014Strap · corrodedBUTT STRAP UNDER FLOOR BOARD PANELS IN CARGO COMPARTMENT CORRODED. REMOVED AND REPLACED AFT CENTER BUTT STRAP IN CARGO COMPARTMENT IAW MM 51-40-02.SDR SWIA97858Relay Box · inoperativeAFTER DEPARTURE, RED INTRANSIT LIGHT A-SYSTEM DISAGREED WITH B-SYSTEM. CYCLED GEAR DOWN 3 TIMES, GREEN OK BUT WITH GEAR UP SAME RED INTRANSIT LIGHT REMAINED ON. RETURNED TO FIELD. CHECKED RIGHT MAIN A-SYSTEM PROXIMITY SENSORS. REMOVED LANDING GEAR SELECTOSDR SWIA97859Switch · out of adjustSERVICE DOOR LIGHT ILLUMINATED AFTER TAKEOFF. RETURNED FOR LANDING. ALL DOORS SECURE. ADJUSTED NOSE AVIONICS BAY DOOR MICRO SWITCH, OPS CHECKS GOOD.
Back to N308SW, cancelled Aug 30, 2018