N924XJ
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 = 'N924XJ' 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 = 'N924XJ' 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 REXA2012102600990Stringer · corroded900-53-140-300, STGR 24R HAS CORROSION BETWEEN FRAMES 310 AMD 295, IN THE FWD E & E BAY. (A236 040). REMOVED AND REPLACED STGR 24R FROM FS 280 AND FS 333 IAW CRJ 900 SRM 51-42-06. SEE CONTINUATION FOR DETAILS. P/N SH670-31212-2.SDR REXA2012102600989Diaphragm · corroded900-53-140-300, RIGHT I/B DIAPHRAGM HAS CORROSION BETWEEN FRAMES 364 AND 349, JUST TO THE RIGHT OF STGR 27, IN THE FWD E & E BAY. (A236 027). REMOVED AND REPLACED RIGHT I/B DIAPHRAGM BETWEEN FS 364 AND FS 349 IAW CRJ P/N SH670-32075-4. AAR AM-10.SDR REXA2012102400988Floor Support · corroded900-53-140-509, FLT DECK CTR FLOOR SUPPORT ANGLE AT FS 280.00 CORRODED. REMOVED AND REPLACED SUPPORT ANGLE AT FS 280 IAW CRJ 900 SRM 51-42-06, SEE CONTINUATION FOR DETAILS. P/N CC670-34095-3S. AAR SM-10.SDR REXA2012102200987Stringer · corroded900-53-140-300, STGR 21R BETWEEN FRAMES 364 AND 379, IN THE FWD E & E BAY. (A236 064). REMOVED AND REPLACED STGR 21R BETWEEN FRAMES 333.00 AND 379.00 IAW CRJ 900 SRM 51-42-06 AND 51-42-21. SEE CONTINUATION FOR DETAILS. P/N SH670-31383-1.SDR REXA2012102100986Beam · corroded900-53-140-509, WHILE WORKING 280 FLOOR LANDING FOUND LEFT 280 BEAM CORRODED. REMOVED & REPLACED LEFT FS 280 BEAM IAW CRJ 900 SRM 51-42-06 & REO 670-53-11-612, SEE CONTINUATION FOR DETAILS. P/N CC670-34094-1.SDR REXA2012102100985Beam · corroded900-53-140-300, WHILE WORKING 280 FLOOR LANDING FOUND RIGHT 280 BEAM CORRODED. REMOVED & REPLACED RIGHT FS 280 BEAM IAW CRJ 900 SRM 51-42-06 Y REO 670-53-11-612. SEE CONTINUATION FOR DETAILS. P/N CC670-34094-25.SDR REXA201210200098Angle · cracked900-52-830-300, PASSENGER DOOR AFT SIDE LOWER ANGLE CRACKED. REPAIRED AFT DRAG ANGLE IAW CRJ 900 SRM 52-11-04.SDR MALA100159Charger · inoperativeFOUND EMERGENCY LIGHTS DS154, DS155, DS156, DS159, DS349 INOP. REPLACED BATTERY CHARGER NR 1 PN ON/OFF 11-0049 S/N ON 23203 S/N OFF 22993 OPS CHECK GOOD PER JC 900-33-900-001 WORK IAW AMM 33-51.SDR MALA090135Light · missingFA REPORTS THAT THE EMERGENCY PATH FLOOR STRIP LIGHTING NEAR GALLEY TRASH BINS IS MISSING. REPLACED MISSING SECTION OF LIGHTING STRIP.SDR MAL2008F00035Light · crackedEMERGENCY FLOOR PATH LIGHTING ASSY HAS CRACKS IN (2) PLACES; ON THE (2) MOST FORWARD STRIPS TO THE RT SIDE. REMOVED AND REPLACED EMERGENCY FLOOR PATH LIGHTING ASSEMBLIES. (K)
Back to N924XJ