N303FV, cancelled Apr 28, 2005
Service difficulty reports · 24
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 = 'N303FV' AND deregistration_id = 'N303FV-2005-04-28' 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 = 'N303FV' AND deregistration_id = 'N303FV-2005-04-28' 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 2003F00261Smoke Detector · defectiveON APPROACH INTO DAY, A MOMENTARY ACTIVATION OF MAIN CARGO FIRE SYSTEM, FOLLOWED IMMEDIATELY BY THE GREEN SYSTEM NORMAL LIGHT AND THEN YELLOW MAINTENANCE LIGHT. NO ACCOMPANING FIRE OR SMOKE NOTED. AIRCRAFT LANDED WITHOUT INCIDENT. REMOVED AND REPLACED SMOKESDR 20000801SH010Shear Tie · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SHEAR TIE AT STA 1150, STR 26R AND STR 29L. (X)SDR 20000801SH009Web · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON CARGO COMP FLOOR SUPPORT WEB FROM STA 950A - STA 950B, APPROXIMATELY STR 29L AND STR 29R. (X)SDR 20000329SH009Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED R-1 DOOR SILL MOUNT FRAME. (X)SDR 99ZZZX4187Web · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SHEAR WEB AT STA 1150 AND STA 1170, LEFT SIDE.SDR 99ZZZX3999Web · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON WEB AT STA 950A - STA 950B APPROX STR 28R.SDR 99ZZZX3998Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 26R STA 1183.SDR 99ZZZX3997Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FLOORBEAM UPPER FLANGE STA 380 RBL 24.SDR 99ZZZX3996Floorbeam · corrodedDURING A C-CHECK, CORROSION WAS NOTED AT STA 380 RBL 3, FLOORBEAM UPPER FLANGE.SDR 99ZZZX3995Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FRAME, BS 1090 AT STR 27R.SDR 99ZZZX3994Web · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON WEB OF WING TO BODY FAIRING BS 720F STR 28L - STR 28R (ALSO 4 EACH ATTACH ANGLES).SDR 99ZZZX3993Seat Track · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON SEAT TRACK STA 380 - STA 400, RBL 18.SDR 99ZZZX3991Bracket · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON BRACKET AT STR 26L STA 580.SDR 99ZZZX3990Bracket · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON BRACKET AT STR 26L STA 560.SDR 99ZZZX3989Bracket · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON BRACKET AT STR 26L STA 620.SDR 99ZZZX3988Bracket · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON BRACKET AT STR 26L STA 660.SDR 99ZZZX3987Bracket · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON BRACKET AT STR 26R STA 660.SDR 99ZZZX3986Bracket · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON BRACKET AT STR 26R STA 720B.SDR 99ZZZX2706Tie Bolt · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON TENSION TILE BOLT BS 1183, STR 12L.SDR 99ZZZX2705Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON R01 DOOR FRAME.SDR 99ZZZX2708Angle · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON UPPER AND LOWER ANGLES OF APU INLET FOR SCREEN.SDR 99ZZZX2707Hinge · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON LOWER AFT LAVATORY SERVICE PANEL HINGE.SDR 99ZZZX2923Stringer · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON STR 29R, BS 1090.SDR 99ZZZX2922Frame · corrodedDURING A C-CHECK, CORROSION WAS NOTED ON FRAME AT BS 1090 BETWEEN STR 28 AND STR 29R.
Back to N303FV, cancelled Apr 28, 2005