N908AX, cancelled Mar 31, 2016
Service difficulty reports · 110
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 = 'N908AX' AND deregistration_id = 'N908AX-2016-03-31' 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 = 'N908AX' AND deregistration_id = 'N908AX-2016-03-31' 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 ABXA9600333Jamb · damagedDURING C-CHECK INSPECTION, FOUND THE ENTRY DOOR AFT JAMB INNER SKIN AT STA 200 DENTED AND TORN. REPAIRED IAW ABX REA D953-14173-MR.SDR ABXA9600325Angle · crackedDURING C-CHECK INSPECTION, FOUND THE LEFT WING OUTBOARD FLAP HINGE ATTACH ANGLE INSIDE THE FLAP CRACKED. REPLACED ANGLE IAW DC-9 SRM 51-30-1.SDR ABXA9600327Angle · crackedDURING C-CHECK INSPECTION, FOUND THE RIGHT WING OUTBOARD FLAP ATTACH ANGLE INSIDE FLAP CRACKED. REPLACED ANGLE IAW DC-9 SRM 51-30-1.SDR ABXA9600335Spar Cap · corrodedDURING C-CHECK INSPECTION, FOUND CORROSION ON THE RIGHT WING LOWER SPAR CAP AT XW-530. REPAIRED IAW ABX REA D957-14078-MR.SDR ABXA9600332Skin · blendedDURING C-CHECK INSPECTION, FOUND DEEP BLEND OUT ON AFT EDGE OF THE FORWARD LOWER CARGO DOOR SKIN. REPAIRED IAW ABX REA D952-14076-MR.SDR ABXA9600330Angle · crackedDURING C-CHECK INSPECTION, FOUND THE RIGHT PYLON UPPER ATTACH ANGLE CRACKED NEAR THE CENTER. REPAIRED IAW DC-9 SRM 54-04, FIGURE 10.SDR ABXA9600328Fitting · crackedDURING C-CHECK INSPECTION, FOUND THE UPPER FITTING INSIDE OUTBOARD EXPANSION JOINT ON THE RIGHT FLAP CRACKED. REPLACED FITTING IAW DC-9 SRM 51-30-2 AND 51-30-1.SDR ABXA9600329Angle · crackedDURING C-CHECK INSPECTION, FOUND THE RIGHT PYLON UPPER ATTACH ANGLE CRACKED NEAR THE FORWARD END. REPAIRED IAW DC-9 SRM 54-04, FIGURE 10.SDR ABXA9600326Trailing Edge · delaminatedDURING C-CHECK INSPECTION, FOUND THE RIGHT WING OUTBAORD TRAILING EDGE ASSEMBLY DELAMINATED. REPAIRED IAW DC-9 SRM 51-70-2.SDR ABXA9600324Bearing · wornDURING C-CHECK INSPECTION, FOUND THE RIGHT AILERON TRIM TAB LINKAGE WORN. REPLACED TRIM TAB LINKAGE BEARINGS IAW DC-9 MM 20-10-1.
Back to N908AX, cancelled Mar 31, 2016