N747AS
Service difficulty reports not matched to an aircraft · 202
They name N747AS, but no registry record covers the date, the aircraft registered then was built later, or the report describes another aircraft. 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 = 'N747AS' AND registry_match IS NULL 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 = 'N747AS' AND registry_match IS NULL 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 ASAA0210226Skin · wornDURING SCHEDULED C CHECK, FOUND LEADING EDGE SKIN AT NR 5 SLAT ACTUATOR AT WING STATION 399-462.5, WORN. REPAIRED SKIN IAW SRM.SDR ASAA0210227Angle · damagedDURING SCHEDULED C CHECK, FOUND FAIRING ANGLES AT BODY STATION 688, RIGHT BUTTOCK LINE 6, RIGHT BUTTOCK LINE 8 DAMAGED. REMOVED AND REPLACED ANGLES IAW SRM.SDR ASAA0210228Skin · crackedDURING SCHEDULED C CHECK, FOUND R1 GALLEY DOOR SKIN CRACKED AT UPPER HINGE CUTOUT. REPAIRED CRACKS TO R1 DOOR IAW EA.SDR ASAA0210229Rib · corrodedDURING SCHEDULED C CHECK, FOUND INBOARD RIB AT WING STATION 453, CORRODED. REMOVED AND REPLACED RIB IAW SRM.SDR ASAA0210230Rib · corrodedDURING SCHEDULED C CHECK, FOUND OUTBOARD RIB AT WING STATION 453, CORRODED. REMOVED AND REPLACED OUTBOARD RIB IWA SRM.SDR ASAA0210231Skin · wornDURING SCHEDULED C CHECK, FOUND SKIN ON NR3 SLAT ACTUATOR CUTOUT AT WING STATION 272-313 WORN. REPAIRED SLAT SKIN IAW SRM.SDR ASAA0210232Bracket · crackedDURING SCHEDULED C CHECK, FOUND RAM AIR PLENUM BRACKET AT BODY STATION 565, RIGHT BUTTOCK LINE 50 CRACKED. REMOVED AND REPLACED BRACKET IWA SRM.SDR ASAA0210234Keelbeam · chafedDURING SCHEDULED C CHECK, FOUND KEELBEAM AT BODY STATION 720-727, RIGHT BUTTOCK LINE 7 CHAFFED. REPAIRED KEEL BEAM IAW EA.SDR ASAA0210235Frame · crackedDURING SCHEDULED C CHECK, FOUND FRAME AT STA 480, BUTTOCK LINE 0, CRACKED. FABRICATED REPAIR PARTS AND INSTALLED IAW EA.SDR ASAA0210236Angle · crackedDURING SCHEDULED C CHECK, FOUND SPLICE ANGLE AT BODY STATION 540, STR 22L-23L CRACKED. REMOVED AND REPLACED SPLICE ANGLE IAW SRM.SDR ASAA0210237Fitting · damagedDURING SCHEDULED C CHECK FOUND INTERCOSTAL CHORD FITTING AT BODY STA 360-385, LEFT BUTTOCK LINE 9. LEFT BUTTOCK LINE 16 WITH AN ELONGATED HOLE. REMOVED AND REPLACED INTERCOSTAL CHORD FITTING IAW SRM.SDR ASAA0210238Support · corrodedDURING SCHEDULED C CHECK FOUND SIDEWALL SUPPORT PLATE AT BODY STR 787-787+10, STRINGER 26R CORRODED. REMOVED AND REPLACED SIDEWALL SUPPORT PLATE IAW SRM.SDR ASAA0210239Bulkhead · crackedDURING SCHEDULED C CHECK FOUND AFT PRESSURE BULKHEAD WEB AT BODY STA 1042, RIGHT BUTTOCK LINE 2 CRACKED. REPAIRED AFT PRESSURE BULKHEAD WEB IAW EA.SDR AASA0210240Stringer · corrodedDURING SCHEDULED -C- CHECK FOUND STRINGER 26 RT AT BODY STATION 360-380 CORRODED. REMOVED, FABRICATED AND INSTALLED REPAIR IAW SRM.SDR ASAA0210241Skin · dentedDURING SCHEDULED C CHECK, FOUND NR 4 SLAT MAIN TRACK COVER AT SLAT STA 28, SLAT STA 31 DENTED. REPAIRED DENT TO ORIGINAL CONTOUR IAW EA.SDR ASAA0210242Attach Angle · brokenDURING SCHEDULED C CHECK FOUND NR 2 ENGINE OUTBOARD FIXED FAIRING ATTACH ANGLE AT NACELLE STATION 139 BROKEN. REMOVED, FABRICATED AND INSTALLED NEW ATTACH ANGLE PER SRM.SDR ASAA0210219Pressure Panel · crackedPAE - DURING SCHEDULED C-CHECK, FOUND RIGHT MAIN WHEEL WELL WEB AT BODY STATION 706-721, RBL 20, RBL 34 CRACKED. REMOVED AND REPLACED WEB PER SRM. (M)SDR ASAA0210218Stringer · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER 26R AT BODY STATION 337-357 CORRODED. REMOVED CORRODED SECTION, FABRICATED AND REPAIRED STRINGER PER SRM. (M)SDR ASAA0210217Door Frame · gougedPAE - DURING SCHEDULED C-CHECK, FOUND L1 DOOR FRAME AT BS 320 LBL 65 GOUGED. REPAIRED DOOR FRAME PER SRM. (M)SDR ASAA0210216Stringer · crackedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER 18L AT BODY STATION 1040 CRACKED. REPAIRED STRINGER PER SRM. (M)SDR ASAA0210215Stringer · dentedPAE - DURING SCHEDULED C-CHECK, FOUND STRINGER 20L AT BODY STATION 1040 DENTED. REPAIRED STRINGER PER SRM. (M)SDR ASAA0210214Keelbeam · crackedPAE - DURING SCHEDULED C-CHECK, FOUND KEEL BEAM WEB AT BS 663-727, LBL 5 CRACKED. REMOVED AND REPLACED KEEL BEAM WEB PER SRM. (M)SDR ASAA0210213Fitting · gougedPAE - DURING SCHEDULED C-CHECK, FOUND 9-G FLOOR PAN FITTING AT BS 344-360, RBL 60, RBL 65 GOUGED. REMOVED AND REPLACED FITTING PER SRM. (M)SDR ASAA0210212Skin · dentedPAE - DURING SCHEDULED C-CHECK, FOUND SKIN PANEL AT BS 1039, STRINGER 10R DENTED. REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0210211Skin Panel · gougedPAE - DURING SCHEDULED C-CHECK, FOUND FORE FLAP LOWER LEADING EDGE SKIN PANEL AT WING STATION 505R GOUGED. BLENDED AND INSTALLED REPAIR PER SRM. (M)SDR ASAA0210209Rib · gougedPAE - DURING SCHEDULED C-CHECK, FOUND NR 2 ENGINE INBOARD COWL RIB UPPER MID SPLICE AT ENGINE STATION 136 GOUGED. REMOVED AND REPLACED INBOARD COWL. (M)SDR ASAA0210208Floor Support · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND LATERAL FLOOR SUPPORT AT BS 967-980, LBL 23, LBL 40 CORRODED. REMOVED AND REPLACED FLOOR SUPPORT PER SRM. (M)SDR ASAA0210207Skin Panel · crackedPAE - DURING SCHEDULED C-CHECK, FOUND SKIN PANEL AT BS 950, STRINGER 11R CRACKED. REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0210206Failsafe · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME FAIL/SAFE CHORD AT BS 520, STRINGER 27L CORRODED. REPAIRED FRAME FAIL/SAFE CHORD PER SRM. (M)SDR ASAA0210205Shear Tie · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND STUB FRAME SHEAR TIE AT BODY STATION 787, STRINGER 26R CORRODED. FABRICATED, REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR ASAA0210204Fairing · chafedPAE - DURING SCHEDULED C-CHECK, FOUND NR 2 ENGINE OUTBOARD FIXED FAIRING AT NACELLE STATION 155, WING STATION 255R CHAFED. REPAIRED FAIRING PER SRM. (M)SDR ASAA0210203Angle · wornPAE - DURING SCHEDULED C-CHECK, FOUND RIGHT MAIN LANDING GEAR BAY FAIRING SUPPORT ANGLE AT FUSELAGE BS 727, RBL 9, RBL 17 WITH WORN FASTENER HOLES. REMOVED AND REPLACED ANGLE PER SRM. (M)SDR ASAA0210201Door Frame · gougedPAE - DURING SCHEDULED C-CHECK, FOUND AFT CARGO DOOR CUTOUT FORWARD FRAME STABILIZING WEB AT FUSELAGE BS 787, STRINGER 24R DENTED AND GOUGED. REMOVED AND REPLACED WEB PER SRM. (M)SDR ASAA0210200Support · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOOR TO SIDEWALL SUPPORT AT FUSELAGE BODY STATION 500-500A, STRINGER 26R CORRODED. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT PER SRM. (M)SDR ASAA0210199Fitting · damagedPAE - DURING SCHEDULED C-CHECK, FOUND INTERCOSTAL CHORD FITTING AT BS 360-385, LBL 9, LBL 16 WITH AN ELONGATED HOLE. REMOVED AND REPLACED INTERCOSTAL CHORD FITTING PER SRM. (M)SDR ASAA0210198Skin · chafedPAE - DURING SCHEDULED C-CHECK, FOUND LEADING EDGE OF OUTBOARD FORE FLAP AT LEFT WING STATION 495-499 CHAFED. FABRICATED REPAIRS TO FLAP PER SRM. (M)SDR ASAA0210197Support · wornPAE - DURING SCHEDULED C-CHECK, FOUND TIE DOWN SUPPORT AT FUSELAGE BODY STATION 410-520, RBL 21 WORN. REMOVED AND FABRICATED REPAIRS TO TIE DOWN SUPPORT PER SRM. (M)SDR ASAA0210196Support · damagedPAE - DURING SCHEDULED C-CHECK, FOUND NR 2 ENGINE INBOARD COWL BLOWOUT DOOR SUPPORT DAMAGED AT ENGINE STATION 230. REMOVED, FABRICATED AND REPLACED ENGINE COWL BLOWOUT DOOR SUPPORT PER SRM. (M)SDR ASAA0210195Support · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOOR TO SIDEWALL SUPPORT AT FUSELAGE BODY STATION 490-520, LEFT BUTTOCK LINE 25 CORRODED. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT PER SRM. (M)SDR ASAA0210194Support · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOOR TO SIDEWALL SUPPORT AT FUSELAGE BODY STATION 500-500A, STRINGER 26R CORRODED. REMOVED AND REPLACED FLOOR TO SIDEWALL SUPPORT PER SRM. (M)SDR ASAA0210193Support · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND BULKHEAD SUPPORT AT FUSELAGE BS 520, LBL 24, RBL 30 CORRODED. REMOVED CORROSION AND REPAIRED PER SRM BY FABRICATING AND INSTALLING NEW SUPPORT. (M)SDR ASAA0210192Intercostal · crackedPAE - DURING SCHEDULED C-CHECK, FOUND INTERCOSTAL AT FUSELAGE BS 500-500A, STRINGER 26R CRACKED. REMOVED DAMAGED INTERCOSTAL AND REPAIRED PER SRM BY FABRICATING AND INSTALLING NEW INTERCOSTAL. (M)SDR ASAA0210188Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME AT FUSELAGE BS 520, RIGHT BUTTOCK LINE 6, RIGHT BUTTOCK LINE 14 CORRODED. REMOVED CORROSION AND REPAIRED PER SRM BY FABRICATING AND INSTALLING REPAIR PARTS. (M)SDR ASAA0210191Rib · damagedPAE - DURING SCHEDULED C-CHECK, FOUND AFT AIRSTAIR RIB AT FUSELAGE BS 947-987 DAMAGED. REMOVED DAMAGED AREA AND REPAIRED PER SRM BY FABRICATING AND INSTALLING REPAIR PARTS. (M)SDR ASAA0210190Support Angle · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SUPPORT ANGLE AT FUSELAGE BODY STATION 664-675, RBL 27 CORRODED. REMOVED CORRODED AND REPAIRED PER SRM BY FABRICATING AND INSTALLING REPAIR PARTS. (M)SDR ASAA0210189Keelbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND KEEL BEAM WEB AT FUSELAGE BS 642, LBL 2 CORRODED. REMOVED CORROSION AND REPAIRED PER SRM BY FABRICATING AND INSTALLING REPAIR PARTS. (M)SDR ASAA0210187Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME AT FUSELAGE BS 400, STRINGER 19R CORRODED. REMOVED CORROSION AND REPAIRED PER SRM BY DRILLING OUT DAMAGE AND INSTALLING RIVET. (MSDR ASAA0210157Skin · crackedSEA - FUSELAGE SKIN CRACKED AT THE R2 DOOR LOWER FORWARD CORNER. REPAIRED PER EA. (M)SDR ASAA0210080Slat · delaminatedANC - DURING SCHEDULED A-CHECK, FOUND NR 2 LEADING EDGE SLAT DELAMINATING AT WING BODY LINE 329.75. REPAIRED PER EA. (M)SDR ASAA0210053Battery · dischargedANC - DURING MAINTENANCE CHECK, FOUND EMERGENCY FLOOR TRACK LIGHTING AT ROWS 7 AND 8 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AT ROWS7 AND 8, THEN LIGHTS OPERATED NORMAL. (M)
Back to N747AS