N743CK
Service difficulty reports · 54
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 = 'N743CK' AND registry_match = 'registration' 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 = 'N743CK' AND registry_match = 'registration' 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 KCSA201309100079Attach Angle · crackedL1 DOOR CUT OUT, ATTACH ANGLE CRACKED BETWEEN UPPER SILL AND BS 440 FRAME.SDR KCSA20120629008Slide · unwanted deployRIGHT UPPER DECK ESCAPE SLIDE INADVERTENTLY DEPLOYED. REMOVED AND REPLACED SLIDE ASSEMBLY IAW B747-400 AMM 25-68-01. REMOVED AND REPLACED EMERGENCY POWER RESERVOIRS IAW B747-400 AMM 52-23-13.SDR KCSA111188Light · inoperativeEMERGENCY LIGHT INOP UPPER DECK STA 640.SDR KCSA111187Bulkhead · crackedBS 2598 BULKHEAD RT FWD INNER CHORD HAS A CRACK AT FASTENER HOLE.
Back to N743CK