N741AS, cancelled May 1, 2007
Service difficulty reports · 319
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 = 'N741AS' AND deregistration_id = 'N741AS-2007-05-01' 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 = 'N741AS' AND deregistration_id = 'N741AS-2007-05-01' 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 ASAA0410022Seat Track · damagedOKC - DURING SCHEDULED D-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 370-446, RIGHT BUTTOCK LINE 45 PITTED AND GOUGED. REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410021Structure · chafedOKC - DURING SCHEDULED D-CHECK, FOUND THE NR 2 ENGINE PYLON AT FAIRING STATIONS 40 AND 62 CHAFED. REPAIRED PYLON PER EA. (M)SDR ASAA0410020Skin Panel · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE INTERNAL SKIN PANEL AT FUSELAGE STATION 382, STRINGER 28R-28L CORRODED. REPAIRED SKIN PANEL PER EA. (M)SDR ASAA0410019Bear Strap · damagedOKC - DURING SCHEDULED D-CHECK, REPLACED INTERIM REPAIR TO THE BEAR STRAP AT FUSELAGE STATION 259-277, LEFT BUTTOCK LINE 15.47. REPAIRED BEAR STRAP PER EA. (M)SDR ASAA0410018Floorbeam · damagedOKC - DURING SCHEDULED D-CHECK, FOUND AFTER ACCOMPLISHING A FLOORBEAM REPAIR, THE SHEAR WEB AT FUSELAGE STATION 500A, LEFT BUTTOCK LINE 24 HAS MISALIGNED HOLES. REPAIRED SHEAR WEB PER EA. (M)SDR ASAA0410017Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 947, LEFT BUTTOCK LINE 24.75, RIGHT BUTTOCK LINE 24.75 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410016Skin · damagedOKC - DURING SCHEDULED D-CHECK, A PREVIOUS SKIN REPAIR WAS NOT CONFIGURED TO THE CURRENT AND REVISED SRM AT FUSELAGE STATION 344, STRINGER 19R. (M)SDR ASAA0410011Pressure Panel · damagedOKC - DURING SCHEDULED D-CHECK, FOUND THE PRESSURE WEB AT FUSELAGE STATION 260.5, STRINGER 27L HAS ELONGATED HOLES. REPAIRED WEB PER SRM AND EA. (M)SDR ASAA04100012Skin · gougedOKC - DURING SCHEDULED D-CHECK, FOUND THE LEFT HORIZONTAL STABILIZER LEADING EDGE AT STABILIZER STATION 156.55-159 GOUGED. REPAIRED HORIZONTAL STAB PER EA. (M)SDR ASAA0410015Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-727B, RIGHT BUTTOCK LINE 44 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0410013Skin Panel · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 350, STRINGER 24L DENTED. REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0410014Frame · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FRAME AT FUSELAGE STATION 685, STRINGER 13R-16R CORRODED. REPLACED FRAME PER SRM AND BOEING DRAWING. (M)SDR ASAA0410010Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-727B, BUTTOCK LINE 0 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0410009Fitting · crackedOKC - DURING SCHEDULED D-CHECK, FOUND THE BULKHEAD FITTING AT FUSELAGE STATION 727, RIGHT BUTTOCK LINE 45.5 CRACKED. REPLACED FITTING PER EA. (M)SDR ASAA0410002Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 480, RIGHT BUTTOCK LINE 5, RIGHT BUTTOCK LINE 59 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410003Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 520, RIGHT BUTTOCK LINE 60, LEFT BUTTOCK LINE 55 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410004Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 260, BUTTOCK LINE 0, LEFT BUTTOCK LINE 10 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0410001Floorbeam · damagedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 380, LEFT BUTTOCK LINE 11, RIGHT BUTTOCK LINE WITH ELONGATED HOLES. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0410005Seat Track · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 480-520, RIGHT BUTTOCK LINE 25 CORRODED. REPAIRED SEAT TRACK PER SRM. (M)SDR ASAA0410006Frame · damagedOKC - DURING SCHEDULED D-CHECK, THE LOWER CHORD AT FUSELAGE STATION 294, STRINGER 25L HAD A FASTENER LOCATION TRIMMED OUT. REPAIRED LOWER CHORD PER EA. (M)SDR ASAA0410007Skin · damagedOKC - DURING SCHEDULED D-CHECK, A PREVIOUS SKIN REPAIR WAS NOT CONFIGURED TO THE CURRENT AND REVISED SRM AT FUSELAGE STATION 927, STRINGER 20R. REMOVED PREVIOUS REPAIR AND REPLACED THE NEW REVISED SRM REPAIR. (M)SDR ASAA0410008Skin Panel · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 440-455, STRINGER 25R DENTED. REPAIRED SKIN PANEL PER EA. (M)SDR ASAA0310609Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 847, RIGHT BUTTOCK LINE 24.75, RIGHT BUTTOCK LINE 61 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA03100687Web · damagedOKC - DURING SCHEDULED D-CHECK, FOUND THE WEB AT FUSELAGE STATION 260.5, STRINGER 27L HAS ELONGATED HOLES. REPAIRED WEB PER SRM AND EA. (M)SDR ASAA0310688Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-727B, BUTTOCK LINE 0 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0310689Skin · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 350, STRINGER 24L DENTED. REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0310679Seat Track · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 683-727, RIGHT BUTTOCK LINE 60 CORRODED. REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM. (M)SDR ASAA0310683Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-663, LEFT BUTTOCK LINE 24 CORRODED. REPLACED FLOORBEAM PER SRM. (M)SDR ASAA0310678Floorbeam · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 294, LEFT BUTTOCK LINE 11 CORRODED. REPLACED DAMAGED SECTION OF FLOORBEAM PER SRM. (M)SDR ASAA0310677Seat Track · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 807-947, RIGHT BUTTOCK LINE 24.75 CORRODED. REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM. (M)SDR ASAA0310676Floor Support · corrodedOKC - DURING SCHEDULED D-CHECK, FOUND THE FLOOR SUPPORT AT FUSELAGE STATION 660, RIGHT BUTTOCK LINE 48, RIGHT BUTTOCK LINE 52 CORRODED. REPAIRED FLOOR SUPPORT PER SRM. (M)SDR ASAA0310681Frame · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE FRAME AT FUSELAGE STATION 500, STRINGER 25L DENTED. REMOVED DAMAGED AREA AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310682Shear Tie · damagedOKC - DURING SCHEDULED D-CHECK, FOUND DAMAGED SHEAR TIE AT FUSELAGE STATION 340, STRINGER 26R-27R. REPLACED SHEAR TIE PER SRM. (M)SDR ASAA0310680Skin Panel · dentedOKC - DURING SCHEDULED D-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 219, STRINGER 24L DENTED. REMOVED DAMAGED AREA AND REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0310546Battery Pack · inoperativeSEA - DURING SCHEDULED MAINTENANCE INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTING AT SEAT PALLETS 1-11, 3-3 AND 9-2 INOPERATIVE. REPLACED BATTERY PACKS, THEN FLOOR TRACK LIGHTS TESTED NORMAL. (M)SDR ASAA0310525Battery · dischargedANC - DURING SCHEDULED MAINTENANCE INSPECTION, FOUND EMERGENCY EXIT IDENTIFIER AT THE R2 DOOR WILL NOT ILLUMINATE. REPLACED BATTERY, THEN EXIT IDENTIFIER TESTED NORMAL. (M)SDR ASAA0310003Battery · dischargedDURING SCHEDULED MAINTENANCE INSPECTION, FOUND NO LED INDICATION OF AFT CONTROL MODULE FUNCTION. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERIES ON PALLETS 10-5, 5-5, AND 6-9, REMOTE ASSEMBLY RECEIVERS ON PALLETS 10-5 AND 5-5, FORWARD CONTROL MODULE (P/N 87-3-SDR ASAA0210394Receiver · inoperativeANC - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROWS 6 AND 7 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER AND BATTERY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0210387Skin · dentedPAE - DURING SCHEDULED C-CHECK, FOUND FUSELAGE SKIN AT BS 947, STRINGER 17L DENTED. REPAIRED FUSELAGE SKIN PER EA. (M)SDR ASAA0210388Door Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND AFT CARGO DOOR FRAME AT BS 790-794, STRINGER 23R-26R CORRODED. REMOVED CORROSION AND REPAIRED CARGO DOOR FRAME PER SRM. (M)SDR ASAA0210386Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND CHORD AT BS 662, RIGHT BUTTOCK LINE 69 CORRODED. REPAIRED CHORD PER EA. (M)SDR ASAA0210382Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 500B, RIGHT BUTTOCK LINE 20, LEFT BUTTOCK LINE 40 CORRODED. REMOVED AND REPLACED LOWER CHORD PER EA. (M)SDR ASAA0210383Channel · chafedPAE - DURING SCHEDULED C-CHECK, FOUND NR 1 ENGINE COWL U-CHANNEL AT NACELLE STATION 122.25 CHAFED. REMOVED DAMAGED U-CHANNEL AND FABRICATED REPAIRS PER SRM. (M)SDR ASAA0210384Longeron · corrodedPAE - DURNG SCHEDULED C-CHECK, FOUND NR 2 ENGINE COWL LONGERON AT NACELLE STATION 154-184, CORRODED. REMOVED AND REPLACED NR 2 ENGINE COWL LONGERON PER SRM. (M)SDR ASAA0210374Rib · gougedPAE - DURING SCHEDULED C-CHECK, FOUND NR 1 ENGINE COWL RIB AT NACELLE STATION 173 GOUGED. REPAIRED DAMAGED COWL PER SRM. (M)SDR ASAA0210375Fairing · gougedPAE - DURING SCHEDULED C-CHECK, FOUND NR 1 ENGINE COWL FAIRING AT NACELLE STATION 137 GOUGED. REPAIRED DAMAGED COWL FAIRING PER SRM. (M)SDR ASAA0210377Rib · gougedPAE - DURING SCHEDULED C-CHECK, FOUND NR 1 ENGINE COWL RIB AT NACELLE STATION 200.5 GOUGED. REPAIRED DAMAGED COWL RIB PER SRM. (M)SDR ASAA0210378Rib · gougedPAE - DURING SCHEDULED C-CHECK, FOUND NR 1 ENGINE COWL RIB AT NACELLE STATION 99.25-116.5 GOUGED. REPAIRED DAMGAED COWL RIB PER SRM. (M)SDR ASAA0210376Channel · gougedPAE - DURING SCHEDULED C-CHECK, FOUND NR 1 ENGINE COWL CHANNEL AT NACELLE STATION 180 GOUGED. REPAIRED DAMAGED COWL CHANNEL PER SRM. (M)SDR ASAA0210380Angle · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND ANGLE AT BS 993, LEFT BUTTOCK LINE 14.5 CORRODED. REMOVED AND REPLACED ANGLE PER SRM. (M)
Back to N741AS, cancelled May 1, 2007