N564PC, cancelled Feb 8, 2002
Service difficulty reports · 55
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 = 'N564PC' AND deregistration_id = 'N564PC-2002-02-08' 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 = 'N564PC' AND deregistration_id = 'N564PC-2002-02-08' 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 GAIA9639Fitting · crackedDURING C-CHECK, INSPECTION REVEALED SEVENTEEN CRACKED STRUT FRAME ATTACH FITTINGS IN THE LOWER FUSELAGE CARGO COMPARTMENTS. CLOSER INSPECTION REVEALED THE CRACKS TO BE STRESS CORROSION CRACKS ALONG GRAIN LINES. EIGHT FRAMES WERE REPLACED IAW DOUGLAS SRM AND SDR GAIA9638Floor Beam · corrodedDURING C-CHECK, INSPECTION REVEALED CORROSION ON FUSELAGE FLOOR BEAM AT STA 642. REPAIRED FLOOR BEAM IAW KITTY HAWK EA D9-53-037. THE AIRCRAFT WAS RETURNED TO SERVICE. (X)SDR GAIA9637Splice · crackedDURING C-CHECK, INSPECTION REVEALED A CRACKED SEAT TRACK SPLICE AT STA 474. REPLACED SPLICE IAW DOUGLAS SRM. THE AIRCRAFT WAS RETURNED TO SERVICE. (X)SDR GAIA9636Longeron · crackedDURING C-CHECK INSPECTION, REVEALED TWO CRACKS ON LONGERON 30 BY THE PRODUCTION SPLICE AT FUSELAGE STATION 360. REPAIRED LONGERON IAW KITTY HAWK EA D9-35-040. THE AIRCRAFT WAS RETURNED TO SERVICE. (M)SDR GAIA9528Retract Mech · lack of lubeFLT NR 9535 - PHL-FSD-SEA - ON APPROACH TO FSD, AFTER EXTENDING THE LANDING GEAR THE 'LANDING GEAR DOOR' LIGHT STAYED ON. THE FLIGHT CREW CYCLED THE LANDING GEAR THREE TIMES BEFORE THE GEAR DOOR LIGHT WENT OUT. THE LANDING GEAR DOORS AND THE LANDING GEAR WERE
Back to N564PC, cancelled Feb 8, 2002