N920XJ
Service difficulty reports · 215
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 = 'N920XJ' 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 = 'N920XJ' 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 MALA20110909111Stringer · corrodedSTRINGER 21R CORRODED, FS 379 TO 364. R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909010Stringer Splice · corroded900-53-140-300, STRINGER SPLICE 25L AT FS 333 CORRODED. R & R STRINGER SPLICE IAW SRM 51-42-06.SDR MALA20110909001SStringer · corrodedSTRINGER 25L CORRODED, FS 295 TO 333. R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909008Longeron · corrodedLONGERON 25L CORRODED, FS 333-349. R & R LONGERON IAW SRM 51-42-06.SDR MALA20110909007Stringer · corrodedSTRINGER 23R CORRODED, FS333-349. R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909006Stringer · corrodedSTRINGER 23R CORRODED, FS 295-310. R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909005Stringer · corrodedSTRINGER 25R CORRODED, FS 295-333. R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909004Stringer · corrodedSTRINGER 26R CORRODED, FS 280-295. R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909003Stringer · corrodedSTRINGER 26L CORRODED, FS 333 TO 349 . R & R STRINGER IAW SRM 51-42-06.SDR MALA20110909002Stringer Splice · corrodedSTRINGER 25R SPLICE AT FS 333 CORRODED. R & R STRINGER SPLICE IAW SRM 51-42-06.SDR MALA20110909001Longeron · corrodedLONGERON AT STR 25R CORRODED, FS333 TO FS349. R & R LONGERON IAW SRM 51-42-06.SDR MALA20110902001AStringer · corrodedSTRINGER 24R CORRODED, FS 333 TO FS 349. REPAIRED STRINGER IAW REO 690-53-21-228 AND 53-00-03 REPAIR 001-A01 FIG 53-00-03-991-803, PG 226.SDR MALA110221Panel · chafedMM48, LT INBD FLAP PANEL 584GB IS CHAFED AT VANE ACTUATOR CUT-OUT. BLENDED OUT DAMAGED AREA OF PANEL AREA OF PANEL 584GB AT VANE ACTUATOR CUT OUT FOUND TO BE WITHIN ALLOWABLE LIMITS IAW SRM 57-52-01.SDR MALA110073Floor Panel · damagedDURING GVI ZONE, FOUND FLOOR PANEL VERY SOFT. REPAIRED FLOOR PANEL USING REG 0670-53-00-087 AS REF.SDR MALA100069Light · looseCREW REPORTED EMERGENCY LIGHT STRIP WHERE GALLEY CART ROLLS OVER IS LOOSE. REMOVED DAMAGED STRIP AND REPLACED.
Back to N920XJ