N923XJ
Service difficulty reports · 203
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 = 'N923XJ' 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 = 'N923XJ' 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 MALA110215Unknown · smokeJUST PRIOR TO LANDING, SMOKE ODOR IN COCKPIT. F/A REPORTED SMALL AMOUNT OF SMOKE IN CABIN. AFTER LANDING RECEIVED RT PACK AUTOFAIL CAUTION. DEFERRED RT A/C PACK. IAW MEL 21-51-1A (C). INSPECTED NR 2 A/C PACK IN AFT EQUIPMENT BAY AND FOUND NO EVIDENCE OF DSDR MALA110011Light · missingF/A REPORTS EMERGENCY FLOOR MARKING STRIP LOCATED IN GALLEY AREA IS MISSING. REPLACED EMERGENCY LIGHTING STRIP IAW REF 33-51-01. PN ON PL88-900LH00: CL008.SDR MAL2008F00009Sensor · malfunctionedTHE CREW HAD A RT BLEED DUCT FAULT WARNING AND NOTED A SLIGHT SMELL OF SMOKE IN THE COCKPIT. CREW FOLLOWED QRH AND MADE SURE PACK WAS SHUTDOWN; DIVERTED. REPLACED TEMP SENSOR. (K)
Back to N923XJ