N746AS
Service difficulty reports not matched to an aircraft · 606
They name N746AS, 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 = 'N746AS' 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 = 'N746AS' 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 ASAA0310505Frame · dentedOKC - DURING SCHEDULED C-CHECK, FOUND THE FRAME AT FUSELAGE STATION 727A, STRINGER 25L-26L CORRODED. REMOVED DAMAGED SECTION OF FRAME AND REPAIRED PER SRM. (M)SDR ASAA0310508Frame · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE FRAME AT FUSELAGE STATION 787, STRINGER 19L-26L CORRODED. REMOVED CORROSION AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310506Stringer · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE STRINGER 25L AT FUSELAGE STATION 352 CORRODED. REMOVED DAMAGED SECTION OF STRINGER AND REPAIRED PER SRM. (M)SDR ASAA0310515Stringer · crackedOKC - DURING SCHEDULED C-CHECK, FOUND STRINGER 26L AT FUSELAGE STATION 767-768.5 CRACKED. REMOVED DAMAGED AREA AND REPAIRED STRINGER PER SRM. (M)SDR ASAA0310509Seat Track · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 360-480, RIGHT BUTTOCK LINE 24 CORRODED. REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310514Structure · chafedOKC - DURING SCHEDULED C-CHECK, FOUND THE LEFT WING TRAILING EDGE OF THE MIDFLAP AT WING STATION 175.5 CHAFED. REPAIRED MIDFLAP PER EA. (M)SDR ASAA0310513Floorbeam · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 549-727A, LEFT BUTTOCK LINE 24.5 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0310512Floorbeam · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 540-706, LEFT BUTTOCK LINE 25 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER SRM AND EA. (M)SDR ASAA0310511Frame · crackedOKC - DURING SCHEDULED C-CHECK, FOUND THE FRAME AT FUSELAGE STATION 747, STRINGER 19L - 20L CRACKED AND CHAFED. REMOVED AND REPLACED SECTION AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310510Floorbeam · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE FLOORBEAM AT FUSELAGE STATION 520, BUTTOCK LINE 0, LEFT BUTTOCK LINE 24.5 CORRODED. REMOVED CORROSION AND REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0310494Seat Track · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 727-727B, RIGHT BUTTOCK LINE 60 CORRODED. REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310498Seat Track · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 420-480, RIGHT BUTTOCK LINE 45 CORRODED. REMOVED AND REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM. (M)SDR ASAA0310503Skin · chafedOKC - DURING SCHEDULED C-CHECK, FOUND THE LEFT WING LEADING EDGE AT WING STATION 505 CHAFED. REMOVED DAMAGED SECTION OF LEADING EDGE AND REPAIRED PER SRM. (M)SDR ASAA0310496Skin · dentedDURING SCHEDULED C-CHECK, FOUND THE HORIZONTAL STABILIZER LEADING EDGE AT FUSELAGE STATION 1049.602, STABILIZER STATION 75 DENTED. (M)SDR ASAA0310495Skin Panel · dentedDURING SCHEDULED C-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 378, WATERLINE 184.1L DENTED. CUT OUT DAMAGE AND REPAIRED PER SRM. (M)SDR ASAA0310502Seat Track · corrodedOKC - DURING SCHEDULED C-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 540-706, LEFT BUTTOCK LINE 25 CORRODED. REMOVED DAMAGED SECTION OF SEAT TRACK AND REPAIRED PER SRM. (M)SDR ASAA0310501Skin · crackedDURNG SCHEDULED C-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 747-749, STRINGER 19R CRACKED. REMOVED DAMAGED SECTION OF SKIN AND REPAIRED PER SRM. (M)SDR ASAA0310499Seat Track · corrodedDURING SCHEDULED C-CHECK, FOUND THE SEAT TRACK AT FUSELAGE STATION 420-500B, RIGHT BUTTOCK LINE 62 CORRODED. REMOVED AND REPLACED DAMAGED SECTION OF SEAT TRACK PER SRM. (M)SDR ASAA0310500Skin · crackedDURING SCHEDULED C-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 923-925, STRINGER 19R CRACKED. REMOVED DAMAGED SECTION OF SKIN AND REPAIRED PER SRM. (M)SDR ASAA0310260Battery Pack · dischargedSEA - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS BLINKING THROUGH OUT CABIN. REPLACED FIVE BATTERY PACKS, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0310006Battery · dischargedANC - EMERGENCY EXIT LIGHTS AT ROW 16 AND SMOKE BARRIER INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY AT SMOKE BARRIER AND BATTERY PACK (P/N 86-2-1004) AT ROW 16, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310004Battery · dischargedSEA - FORWARD EMERGENCY SLIDE EXIT LIGHT ILLUMINATED. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0210393Battery Pack · dischargedSEA - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 14 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER AND BATTERY PACK THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210390Receiver · inoperativeSEA - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 12 WOULD NOT TEST. REMOVED AND REPLACED REMOTE ASSEMBLY RECEIVER, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210369Receiver · inoperativeSEA - DURING LINE MAINTENANCE CHECK, FOUND THE BATTERY PACK AT ROW 16 NOT WORKING. REMOVED AND REPLACED REMOTE RECEIVER BATTERY. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0210321Receiver · failedANC - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 13 WOULD NOT EXTINGUISH. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERIES AND RECEIVERS, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210301Battery · dischargedANC - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROWS 11, 12 AND 15 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERIES, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210254Battery · dischargedDURING PREFLIGHT CHECK, FOUND FOUR EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROW 18. REMOVED AND REPLACED REMOTE RECEIVER BATTERY. LIGHTS THEN OPERATED PROPERLY.SDR ASAA0210252Battery · dischargedANC - DURING INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT SEAT PALLET 7-8 ILLUMINATED. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210182Battery · dischargedANC - DURING PREFLIGHT CHECK, FOUND FOUR EMERGENCY FLOOR TRACK LIGHTS INOPERATIVE AT ROWS 12-14. REMOVED AND REPLACED REMOTE RECEIVER AND BATTERY AT ROW 12 AND BATTERY ONLY AT ROW 14. LIGHTS THEN OPERATED PROPERLY. (M)SDR ASAA0210178Light · inoperativeANC - SMOKE BARRIER AND OVERWING EXIT LIGHTS INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLIES (3) AT BOTH OVERWING EXITS AND SMOKE BARRIER, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210175Guide · out of adjustANC - L1 DOOR WILL NOT CLOSE. ADJUSTED GUIDE ARM PER MM, THEN DOOR OPERATED NORMAL. (M)SDR ASAA0210174Battery Pack · dischargedANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHT AT ROW 14 INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERY PACK, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0210172Light · inoperativeANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHT AT ROW 19 INOPERATIVE. REMOVED AND REPLACED LIGHT ASSEMBLY AT ROW 19, THEN LIGHT NORMAL. (M)SDR ASAA0210171Battery · dischargedANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY EXIT IDENTIFIERS AT L2 AND R2 DOORS INOPERATIVE. REMOVED AND REPLACED REMOTE ASSEMBLY BATTERIES, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0210153Light · inoperativeANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY EXIT IDENTIFIER AT LEFT OVERWING EXIT INOPERATIVE. REPLACED LIGHT ASSEMBLY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0210152Battery · dischargedANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT LEFT OVERWING EXIT INOPERATIVE. REPLACED REMOTE ASSEMBLY BATTERY, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210150Battery · dischargedANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT SEAT PALLETS 9 AND 10 INOPERATIVE. REPLACED REMOTE ASSEMBLY BATTERIES, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0210149Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 967, LEFT BUTTOCK LINE 18 CORRODED. REPAIRED FLOORBEAM PER EA. (M)SDR ASAA0210145Keelbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND KEELBEAM AT BS 677-727, LEFT BUTTOCK LINE 8 CORRODED. REPAIRED REAR KEELBEAM PER EA. (M)SDR ASAA0210148Spar · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FORWARD SPAR AT HORIZONTAL STABILIZER STATION 57.93 CORRODED. REPAIRED REAR FORWARD SPAR PER EA. (M)SDR ASAA0210147Frame · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FRAME AT BS 332, RIGHT BUTTOCK LINE 68.4 CORRODED. REPAIRED REAR FRAME PER SRM. (M)SDR ASAA0210146Fitting · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND SPAR LUGS AT BS 1104, LEFT BUTTOCK LINE 45, RIGHT BUTTOCK LINE 45 CORRODED. REPAIRED REAR SPAR LUGS PER EA. (M)SDR ASAA0210143Spar · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND REAR SPAR AT LEFT HORIZONTAL STABILIZER 67.54 CORRODED. REPAIRED REAR SPAR PER EA. (M)SDR ASAA0210144Frame · crackedPAE - DURING SCHEDULED C-CHECK, FOUND CHORD AT LEFT WING STATION 126 CRACKED. REPAIRED REAR CHORD PER SRM. (M)SDR ASAA0210142Spar · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND REAR SPAR AT RIGHT HORIZONTAL STABILIZER 67.54 CORRODED. REPAIRED REAR SPAR PER EA. (M)SDR ASAA0210141Skin · crackedPAE - DURING SCHEDULED C-CHECK, FOUND SKIN PANEL ON L1 DOOR, BODY STATION 342, LEFT BUTTOCK LINE 63.3 CRACKED. REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0210140Skin · crackedPAE - DURING SCHEDULED C-CHECK, FOUND SKIN PANEL AFT SERVICE DOOR, BS 967, RIGHT BUTTOCK ILNE 59 CRACKED. REPAIRED SKIN PANEL PER SRM. (M)SDR ASAA0210138Floorbeam · corrodedPAE - DURING SCHEDULED C-CHECK, FOUND FLOORBEAM AT BS 1016, LBL 6, LBL 10 CORRODED. REPAIRED FLOORBEAM PER SRM. (M)SDR ASAA0210139Skin Panel · crackedPAE - DURING SCHEDULED C-CHECK, FOUND SKIN PANEL AT BS 378, STRINGER 28L-28R CRACKED. REPAIRED SKIN PANEL PER EA. (M)
Back to N746AS