N982AX, cancelled Mar 8, 2018
Service difficulty reports · 131
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 = 'N982AX' AND deregistration_id = 'N982AX-2018-03-08' 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 = 'N982AX' AND deregistration_id = 'N982AX-2018-03-08' 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 ABXA9500971Skin · damagedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 94-03-01, FOUND FUSELAGE SKIN DENTED AND CRACKED AT STA 105, LONGERON 18L. REPAIRED IAW ABX REA D953-13037-MR.SDR ABXA9500960Web · cutDURING C-CHECK INSPECTION, IT WAS NECESSARY TO CUT CUSP WEB FOR ACCESS TO DO OTHER REPAIRS. REPAIRED CUSP WEB IAW ABX REA D953-13050-MR.SDR ABXA9500959Web · cutDURING C-CHECK INSPECTION, IT WAS NECESSARY TO CUT CUSP WEB FOR ACCESS TO DO OTHER REPAIRS. REPAIRED CUSP WEB IAW ABX REA D953-13050-MR.SDR ABXA9500958Web · cutDURING C-CHECK INSPECTION, IT WAS NECESSARY TO CUT CUSP WEB FOR ACCESS TO DO OTHER REPAIRS. REPAIRED CUSP WEB IAW ABX REA D953-13050-MR.SDR ABXA9500957Web · cutDURING C-CHECK INSPECTION, IT WAS NECESSARY TO CUT CUSP WEB FOR ACCESS TO DO OTHER REPAIRS. REPAIRED CUSP WEB IAW ABX REA D953-13050-MR.SDR ABXA9500956Web · cutDURING C-CHECK INSPECTION, IT WAS NECESSARY TO CUT CUSP WEB FOR ACCESS TO DO OTHER REPAIRS. REPAIRED CUSP WEB IAW ABX REA D953-13050-MR.SDR ABXA9500970Floorbeam · corrodedDURING C-CHECK INSPECTION, FOUND CORROSION ON FLOORBEAM AT STA 389 AT RBL 44. REPAIRED IAW ABX REA D953-13029-MR.SDR ABXA9500969Skin · damagedDURING C-CHECK INSPECTION, FOUND A DENT WITH A GOUGE IN FUSELAGE SKIN STA 168, LONGERON 19R. REPAIRED IAW ABX REA D953-12980-MR.SDR ABXA9500967Skin · corrodedDURING C-CHECK INSPECTION, FOUND CORROSION ON FUSELAGE SKIN IN AREA OF NR 2 ADF LOOP ANTENNA, STA 298.5, BETWEEN LONGERON 1 AND 2L. REPAIRED IAW ABX REA D953-12973-MR.SDR ABXA9500966Skin · damagedDURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN DENTED WITH A GOUGE AT STA 206, LONGERON 19R. REPAIRED IAW ABX REA D953-12989-MR.SDR ABXA9500978Skin · dentedDURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN DENTED AND GOUGED AT STA 80, LONGERON 18. REPAIRED IAW ABX REA D953-12995-MR.SDR ABXA9500965Floorbeam · gougedDURING C-CHECK INSPECTION, FOUND FLOORBEAM STA 389, GOUGED. REPAIRED IAW ABX REA D953-13009-MR.SDR ABXA9500964Skin · damagedDURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN DAMAGED AT THE FORWARD EDGE OF THE ALC DOOR CUTOUT. REPAIRED IAW ABX REA D953-13004-MR.SDR ABXA9500972Skin · damagedDURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN DENTED WITH A GOUGE AT STA 189, LONGERON 19R. REPAIRED IAW ABX REA D953-12988-MR.SDR ABXA9500968Skin · damagedDURING C-CHECK INSPECTION, FOUND FUSELAGE SKIN DENTED AND GOUGED AT STA 937, LONGERON 23. REPAIRED IAW ABX REA D953-12993-MR.SDR ABXA9500963Blkhd Skin · damagedDURING C-CHECK INSPECTION, FOUND DAMAGE AT FORWARD SIDE OF AFT PRESSURE BULKHEAD SKIN. REPAIRED IAW ABX REA D953-13005-MR.SDR ABXA9500977Blkhd Skin · gougedDURING C-CHECK INSPECTION, FOUND A GOUGE IN THE AFT SIDE OF THE AFT PRESSURE BULKHEAD. REPAIRED IAW ABX REA D953-12990-MR.SDR ABXA9500961Angle · crackedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND RIGHT WING TO FUSELAGE GUSSET ANGLE AT STA 48 CRACKED. REPAIRED IAW DC-9 SB 57-103.SDR ABXA9500946Angle · crackedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND LEFT WING TO FUSELAGE GUSSET ANGLE AT STA 48 CRACKED. REPAIRED IAW DC-9 SB 57-103.SDR ABXA9500976Blkhd Skin · gougedDURING C-CHECK INSPECTION, FOUND THE INLET DUCT GOUGED THE BULKHEAD SKIN AT STA 1046. REPAIRED IAW ABX REA D953-12991-MR.SDR ABXA9500975Frame · crackedDURING C-CHECK INSPECTION, FOUND MAIN FRAME STA 718 CRACKED ON RIGHT SIDE. REPAIRED IAW ABX REA D953-12966-SB.SDR ABXA9500950Skin · damagedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND LIGHTNING STRIKES FROM STA 110 TO 218, LONGERON 26R. REPAIRED IAW DC-9 SRM 53-04 FIG 38.SDR ABXA9500949Angle · missingDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND SERVICE BULLETIN FITTINGS MISSING FROM NOSE LANDING GEAR DOORS. REPAIRED FITTINGS IAW DC-9 SRM 51-30-1, 51-30-2, 51-30-4 AND INSTALLED DOUBLERS IAW EA NR FS-53-03529-MA.SDR ABXA9500948Skin · dentedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND DENT IN THE FUSELAGE SKIN AT STA 115, LONGERON 21L. REPAIRED IAW DC-9 SRM 53-04 FIG 38 VIEW 1.SDR ABXA9500974Frame · crackedDURING C-CHECK INSPECTION, FOUND MAIN FRAME STA 718 CRACKED ON LEFT SIDE. REPAIRED IAW ABX REA D953-12966-SB.SDR ABXA9500973Skin · req'd repairDURING C-CHECK AND PSE INSPECTIONS, FOUND PREVIOUS REPAIR AT FORWARD UPPER CORNER OF ENTRY DOOR CUTOUT. REPAIRED IAW ABX REA D953-12981-MR.SDR ABXA9500951Te Panel · delaminatedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND WING TRAILING EDGE PANEL FORWARD OF RIGHT AILERON DELAMINATED. REPLACED PANEL IAW DC-9 SRM 51-30-1 AND 51-30-2.SDR ABXA9500952Angle · crackedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND PANEL 110 SUPPORT ANGLE CRACKED. FABRICATED AND INSTALLED NEW ANGLE IAW PFEA NR PFE-D953-10918 AND DC-9 SRM 51-30-5.SDR ABXA9500947Pan · crackedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND UPPER FORWARD END OF SERVICE DOOR HOLD OPEN LATCH PAN CRACKED AT WELD. REPLACED LATCH PAN IAW DC-9 SRM 51-30-2.SDR ABXA9500953Panel · delaminatedDURING C-CHECK INSPECTION AND COMPLIANCE WITH AD 92-22-08, FOUND LEFT WING UPPER BONDED PANEL FORWARD OF AILERON DELAMINATED. REPLACED PANEL IAW DC-9 SRM 51-30-1, 51-30-2 AND 51-30-5.SDR ABXA9500629Door · delaminatedDURING COMPLIANCE OF A.D. 91-22-07; A.S.B. 32-244, FOUND LEFT MAIN LANDING GEAR DOOR DELAMINATED. REPLACED DOOR IAW DC-9 M.M. 32-12-1.
Back to N982AX, cancelled Mar 8, 2018