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 aircraft_model_key = '727256' 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 aircraft_model_key = '727256' 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 99ZZZX2921Spar · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LEFT WING FRONT SPAR LOWER CHORD PLATE AT WS 400 AND WS 422.SDR 99ZZZX2920Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT INBOARD SEAT TRACK FORWARD OF BS 460.SDR 99ZZZX2919Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT INBOARD SEAT TRACK, BS 1070.SDR 99ZZZX2918Antenna · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON ALL 4 SIDES OF ANTENNA (ADF).SDR 99ZZZX2500Beam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON RIGHT HORIZONTAL STABILIZER UPPER TIE BEAM (APROX STA 118).SDR 99ZZZX2454Frame · corrodedDURING A C-CHECK, CORROSION NOTED ON FRAME AT STA 380 BETWEEN STR 28L AND STR 28R.SDR 99ZZZX2453Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 28R AND STR 28L AT STA 360.SDR 99ZZZX2311Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 26R AND STR 27R AT STA 680 - STA 700.SDR 99ZZZX2310Shear Tie · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 660 AT STR 26R.SDR 99ZZZX2309Shear Tie · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 50 AT STR 26R.SDR 99ZZZX2308Shear Tie · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 540 AT STR 27RSDR 99ZZZX2307Panel · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 480 - STA 560 ON TRANSITION PANEL.SDR 99ZZZX2306Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED STA 420 - STA 440 ON STR 28L.SDR 99ZZZX2305Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FRAME 950C ON STR 29L.SDR 99ZZZX2304Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STRINGER 28R AT STA 950E.SDR 99ZZZX2303Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 990 ON STR 30.SDR 99ZZZX2302Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FRAME AT STA 1166 BETWEEN STR 28 - STR 29, LEFT.SDR 99ZZZX2301Channel · corrodedDURING A C-CHECK, CORROSION WAS NOTED IN LT AFT LAVATORY HAT CHANNEL LBL 24.75.SDR 99ZZZX2300Skin · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SKIN UNDER PANELS AT BS 990L, STR 23L.SDR 99ZZZX2299Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 27R, STA 740.SDR 99ZZZX2298Shear Tie · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 26R, FS 720B.SDR 99ZZZX2458Rod Arm · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON AC BAY EXTERNAL GROUND CONNECTION DOOR AND MECHANISMS.SDR 99ZZZX2457Rod Arm · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON AC BAY EXTERNAL GROUND CONNECTION DOOR AND MECHANISMS.SDR 99ZZZX2456Rod Arm · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON AC BAY MECHANISMS.SDR 99ZZZX2455Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FRAME AROUND AFT ADF LOOP ANTENNA FS 740 - BL ZERO.
Back to Boeing 727-256