N236X, cancelled Jan 13, 2003
Service difficulty reports · 213
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 = 'N236X' AND deregistration_id = 'N236X-2003-01-13' 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 = 'N236X' AND deregistration_id = 'N236X-2003-01-13' 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 HEED9523Regulator · defective#2 ENGINE START DISENGAGE TRIPS BUSS INTERCONNECT, MUST RESET BATTERY SWITCH TO GET BUSS INTERCONNECT BACK ON LINE. ORDERED NEW PART.SDR HEED9522Relay · faultyBATTERY RELAY AND BUSS INTERCONNECT LIGHTS ON AT SAME TIME, MUST BE RESET OFTEN. ORDERED NEW PART.SDR HEED958Shim · damagedDAMAGED. ORDERED NEW PART.SDR HEED957Support · missingMISSING FROM AIRCRAFT. ORDERED NEW PART.SDR HEED956Blade · damagedDAMAGED BLADE. ORDERED NEW BLADESDR HEED9521Generator · failed#2 GENERATOR WILL NOT COME ON LINE, SMOKES IN STARTER MODE. ORDERED NEW PART.SDR HEED9520Altimeter · defectiveNEEDLE PEGS ORDERED NEW PART.SDR HEED9515Link · wornPARTS WORN BEYOND EXXON LIMITS. ORDERED NEW PART.SDR HEED9514Weight · defectiveBALANCE WEIGHT FOR M/R BLADE DEFECTIVE. ORDERED NEW PART.SDR HEED9513Shaft Assy · grease leakFORWARD COUPLING SLINGING GREASE REPLACED WITH NEW PART, ALSO COMPLIED WITH ASB 230-93-2, REV. 1. ORDERED NEW PART.SDR HEED9511Isolation Mount · wornOUTBOARD BEARING OF LATERAL ISOLATION MOUNT WORN .012 RADIAL AND .007 - .010 AXIAL. ORDERED NEW PART.SDR HEED9510Spring · defectiveAIRCRAFT AOG, REMOVED SERIAL NOS. LK-0006, LK-0021 ORDERED NEW PART.SDR 95ZZZX2210Union · crackedLOST HYDRAULIC PRESSURE ON NR 1 SYSTEM ON LANDING. FOUND THE PRESSURE LINE UNION CRACKED ON THE CENTER SERVO. FIGURE 29-1001, ITEM 11.
Back to N236X, cancelled Jan 13, 2003