N918XJ
Service difficulty reports · 210
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 = 'N918XJ' 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 = 'N918XJ' 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 REXA2013100601995Hinge · corrodedPAX DOOR TOP FOLDING STEP, FUSELAGE SIDE HINGE CORRODED. REPLACED PAX DOOR TOP FOLDING STEP HINGE IAW SRM 51-40-11.SDR REXA2013100201990Wire · pulledRIGHT AFT OVER WING EMERGENCY EXIT LIGHT WIRE PULLED OUT OF LIGHT. INSTALLED NEW CONTACT TO DS56 IAW ESPM 20-16-00. OP TEST OF EXTERNAL EMERGENCY, GOOD IAW AMM 33-51-00.SDR REXA2013092401843Light · missingFWD LEFT GALLEY EMERGENCY LIGHT IS MISSING. REPLACED MISSING EMERGENCY LIGHT IAW AMM 33-51-01.SDR REXA2013090601636Light · missingEMERGENCY LIGHT MISSING AT ROW 13 A & B. REPLACED LIGHT IAW AMM 33-51-01. OK FOR SERVICE.SDR MALA110164Unknown · damagedDURING INCORPORATION OF GREO 670-53-11-509 HOLE AT FS 193, RT SIDE WAS DOUBLE DRILLED. REO 690-53-11-306. INCORPORATED AND COMPLIED WITH EO R53134 WHICH ADDRESSES ABOVE GREO AND DEVIATION.SDR MALA110135Structure · crackedDURING LINE CHECK FOUND CRACKS ON AFT SIDE OF PAX DOOR. INSPECTED IAW REO 690-52-11-153. PAX DOOR OPERATES NORMALLY AND PRESSURIZATION CHECK IAW AMM 52-00-00. FOUND ACFT SAFE FOR 1 TIME FERRY FLIGHT FOR FURTHER INSPECTION AND REPAIR OF PAX DOOR. REPAIRED PSDR MALA110120Light · missingGLOW STRIP ON FLOOR OF GALLEY (NEAR CURTAIN) IS MISSING. INSTALLED FLOOR TRACK LIGHTING STRIP, PN PL88-910LH00.SDR MALA110080Light · missingEMERGENCY LIGHTING IN FRONT GALLEY MISSING. INSTALLED NEW LIGHTING STRIP PN PL88-900LH00 IAW 33-51-01.SDR MALA110051Light · missingEMERGENCY PATH STRIP MISSING ON LT SIDE OF GALLEY. INSTALLED NEW FLOOR TRACK LIGHTING AS REQUIRED IAW MM 33-20 ALL CHECKS GOOD AT THIS TIME.SDR MALA090079Strip · missingMISSING EMERGENCY FLOOR PATH STRIP AT SEAT 12AB. REPLACED EMERGENCY FLOOR PATH STRIP AT SEAT 12AB.
Back to N918XJ