JASC 5321
Service difficulty reports · 49,402
Reports filed under 5321 · Fuselage Floor Panel, 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 jasc_code = '5321' 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 jasc_code = '5321' 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 USAA950079Floor Skin · corrodedPIT - DURING Q-1 CHECK INSPECTION ACCOMPLISHED CORROSION TASK C45-53301 AND C46-53303 FOUND LEVEL I CORROSION ON SUBFLOOR SKIN UNDER THRESHOLD AT STATION 160-200. AREA WAS PREVIOUSLY 6 INCH BY 14 INCH. CUT OUT CORRODED AREA AND SPLICED IN NEW SECTION OF SUBFSDR USAA950078Floor Skin · corrodedPIT - DURING Q-1 CHECK INSPECTION ACCOMPLISHED CORROSION TASK C46-53303 INSIDE OF SERVICE DOOR STATION 200 FOUND LEVEL I CORROSION ON SUBFLOOR. CUT OUT CORRODED AREA AND SPLICED IN NEW SECTION OF SUBFLOOR PER SRM 53-01 FIG 2. (Z)
Back to JASC 5321