N730AS
Service difficulty reports not matched to an aircraft · 393
They name N730AS, 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 = 'N730AS' 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 = 'N730AS' 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 ASAA0410203Seat Track · corrodedDURING C-CHECK FOUND SEAT TRACK INBOARD FLANGE AT STATION 420-480, RBL 24 IS CORRODED. REMOVED DAMAGED SECTION AND INSTALLED REPLACEMENT SECTION IAW SRM 51-30-2. (M)SDR ASAA0410199Seat Track · corrodedFOUND CABIN SEAT TRACK AT LBL 45, STATION 727-887 IS CORRODED. REMOVED DAMAGE AND INSTALLED REPLACEMENT SECTION IAW SRM 51-20-1. (M)SDR ASAA0410198Floorbeam · corrodedFOUND FLOORBEAM CORRODED AROUND FASTENER HOLES AT STATION 540-650. OPENED UP HOLES, INSPECTION WITH HFEC, TREATED AND PRIMED AREA IAW EA 5310-02341. (M)SDR ASAA0410197Floorbeam · corrodedFOUND SPOT CORROSON ON BEAM CAP SUPPORT JUNCTION AT STATION 360, RBL 12. REMOVED DAMAGE AND INSTALLED RPR SECTION IAW SRM 53-10-9. (M)SDR ASAA0410196Seat Track · gougedFOUND SEAT TRACK AT STATION 370-468 IS WORN AND GOUGED. REMOVED DAMAGED SECTION AND INSTALLED RPR SEAT TRACK SECTION IAW SRM 53-10-5. (M)SDR ASAA0410201Shear Tie · corrodedDURING C-CHECK, FOUND SHEAR TIE AND FRAME AT STATION 986, BETWEEN STRINGER 18L AND 19L IS CORRODED. REMOVED DAMAGE AND INSTALLED REPLACEMENT SHEAR TIE AND NEW FRAME SPLICE IAW SRM 51-30-2. (M)SDR ASAA0410202Seat Track · corrodedDURING C-CHECK, FOUND SEAT TRACK AT STATION 827-947, RBL 25 IS CORRODED. REMOVED DAMAGED SECTION AND INSTALLED REPLACEMENT SECTION IAW SRM 51-30-2.SDR ASAA0410195Floorbeam · corrodedFOUND FLOORBEAM RPR STRAP AT STATION 847 IS CORRODED. REMOVED DAMAGED RPR STRAP AND INSTALLED REPLACEMENT RPR STRAP IAW SRM 51-10-2 AND EA 5310-01478. (M)SDR ASAA0410194Stringer Clip · corrodedFOUND STRINGER CLIP AT STATION 986, STRINGER 19L IS CORRODED. REMOVED DAMGAED CLIP AND INSTALLED REPLACEMENT CLIP IAW SRM 51-20-1. (M)SDR ASAA0410193Floorbeam · corrodedFOUND FLOORBEAM LOWER FLANGE AT STATION 500, BL 0 - LBL 45 HAS LIGHT CORROSION. REMOVED DAMAGED PRP STRAP AND INSTALLED REPLACEMENT RPR STRAP IAW SRM 51-30-2 AND EA 5310-01463. (M)SDR ASAA0410192Floorbeam · corrodedFOUND FLOORBEAM TOP SURFACE AT STATION 1006, RBL 1-LBL 12 IS CORRODED. REMOVED DAMAGED RPR, INSTALLED REPLACEMENT RPR ANGLES IAW SRM 53-10-9. (M)SDR ASAA0410190Seat Track · gougedFOUND SEAT TRACK IS NICKED AND GOUGED AT STATION 600-616, LBL 25. REMOVED DAMAGED SECTION AND INSTALLED REPLACEMENT FLOOR TRACK SECTION IAW SRM 53-10-5. (M)SDR ASAA0410191Threshold · corrodedFOUND L2 DOOR THRESHOLD WEB IS CORRODED AND GOUGED. REMOVED DAMAGED WEB AND INSTALLED REPLACEMENT WEB IAW SRM 51-30-2. (M)SDR ASAA0410188Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM RPR STRAP AT FS 747. REMOVED DAMAGED RPR STRAP AND INSTALLED REPLACEMENT RPR STRAP IAW EA 5310-01466. (M)SDR ASAA0410189Floorbeam · corrodedFOUND CORROSION ON FLOORBEAM RPR STRAP AT FS 767. REMOVED DAMAGED RPR STRAP AND INSTALLED REPLACEMENT RPR STRAP IAW EA 5310-01465. (M)SDR ASAA0410147Light · inoperativeANC - DURING MAINTENANCE, FOUND SMOKE BARRIER EMERGENCY EXIT LIGHT INOPERATIVE. REPLACED ILGHT ASSEMBLY. (M)SDR ASAA0410069Battery · dischargedANC - DURING RECON INSPECTION, FOUND THE EMERGENCY EXIT SIGN ON THE SMOKE BARRIER INOPERATIVE. REPLACED BATTERY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0410068Battery Pack · dischargedANC - DURING RECON INSPECTION, FOUND THE EMERGENCY FLOOR TRACK LIGHTS ON PALLET 10-3 INOPERATIVE. REPLACED BATTERY PACK, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0410045Battery · dischargedANC - DURING RECON INSPECTION, FOUND THE EMERGENCY EXIT SIGN ON THE SMOKE BARRIER INOPERATIVE. REPLACED BATTERY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0410223Seat Track · corrodedDURING C-CHECK, FOUND SEAT TRACK AT STATION 887-940, BL 0 HAS SEVERE CORROSION. REMOVED DAMAGED SECTION OF SEAT TRACK AND INSTALLED REPLACEMENT SECTION IAW SRM 51-20-1. (M)SDR ASAA0310517Skin Panel · crackedPAE - DURING A-CHECK, FOUND THE FUSELAGE SKIN PANEL AT BODY STATION 747-748, STRINGER 17R CRACKED. REPAIRED SKIN PER SRM. (M)SDR ASAA0310493Battery Pack · dischargedANC - DURING INSPECTION, FOUND OVERWING EXIT IDENTIFIERS WITH DISCHARGED BATTERY. REMOVED AND REPLACED BATTERIES, THEN EXIT IDENTIFIERS OPERATED NORMALLY. (M)SDR ASAA0310488Skin Panel · corrodedPAE - DURING C-CHECK, FOUND THE INNER SKIN PANEL AT FUSELAGE STATION 492, STRINGER 27R-28R CORRODED. REPAIRED SKIN PANEL PER EA. (M)SDR ASAA0310489Stringer · corrodedPAE - DURING C-CHECK, FOUND STRINGER 27L AT FUSELAGE STATION 807-827 CORRODED. REPAIRED STRINGER PER EA. (M)SDR ASAA0310487Skin Panel · bulgedPAE - DURING C-CHECK, FOUND THE SKIN PANEL AT FUSELAGE STATION 520, STRINGER 27L-28L BULGING. REMOVED DAMAGED AREA AND REPAIRED SKIN PANEL PER EA. (M)SDR ASAA0310490Keelbeam · corrodedPAE - DURING C-CHECK, FOUND THE KEEL BEAM AT FUSELAGE STATION 800, RIGHT BUTTOCK LINE 6 CORRODED. REPAIRED KEEL BEAM PER EA. (M)SDR ASAA0310486Bear Strap · crackedDURING C-CHECK, FOUND THE BEAR STRAP AT FUSELAGE STATION 360, LEFT BUTTOCK LINE 65 CRACKED. REPAIRED BEAR STRAP PER EA. (M)SDR ASAA0310481Case · crackedPAE - DURING C-CHECK, FOUND THE AFT AIRSTAIR HANDLE CASING AT FUSELAGE STATION 967, LEFT BUTTOCK LINE 65 CRACKED. REPAIRED HANDLE CASING PER EA. (M)SDR ASAA0310482Web · corrodedPAE - DURING C-CHECK, FOUND THE SUB THRESHOLD WEB AT FUSELAGE STATION 792-847, STRINGER 26R CORRODED. REPLACED WEB PER SRM. (M)SDR ASAA0310479Splice · corrodedPAE - DURING C-CHECK, FOUND THE STRINGER SPLICE AT FUSELAGE STATION 887-934, STRINGER 24L CORRODED. REPLACED STRINGER SPLICE PER SRM. (M)SDR ASAA0310480Frame · corrodedPAE - DURING C-CHECK, FOUND THE FRAME AT FUSELAGE STATION 887, STRINGER 24L-25L CORRODED. CUT OUT DAMAGED SECTION AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310478Skin · crackedPAE - DURING C-CHECK, FOUND THE R1 DOOR SKIN AT FUSELAGE STATION 295, RIGHT BUTTOCK LINE 68 CRACKED. REPAIRED DOOR SKIN PER EA. (M)SDR ASAA0310477Floorbeam · corrodedPAE - DURING C-CHECK, FOUND THE LONGITUDINAL BEAM AT FUSELAGE STATION 685, RIGHT BUTTOCK LINE 43 CORRODED. REPAIRED BEAM PER SRM. (M)SDR ASAA0310475Stringer · corrodedPAE - DURING C-CHECK, FOUND STRINGER 20R AT FUSELAGE STATION 767 CORRODED. REPAIRED STRINGER PER SRM. (M)SDR ASAA0310474Splice · corrodedPAE - DURING C-CHECK, FOUND STRINGER SPLICE AT FUSELAGE STATION 907, STRINGER 22L-23L CORRODED. REPLACED STRINGER SPLICE PER SRM. (M)SDR ASAA0310456Stringer · corrodedPAE - DURING C-CHECK, FOUND STRINGER 26L, FUSELAGE STATION 807-827 CORRODED. REPAIRED STRINGER PER SRM. (M)SDR ASAA0310461Shear Tie · corrodedPAE - DURING C-CHECK, FOUND THE SHEAR TIE AT FUSELAGE STATION 987, STRINGER 25L-26L CORRODED. REPAIRED SHEAR TIE PER SRM. (M)SDR ASAA0310457Frame · dentedPAE - DURING C-CHECK, FOUND THE FRAME AT FUSELAGE STATION 420, STRINGER 23L-24L DENTED. REMOVED DAMAGE AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310458Door Frame · crackedPAE - DURING C-CHECK, FOUND THE AFT CARGO DOOR FRAME AT FUSELAGE STATION 836, LEFT BUTTOCK LINE 60 CRACKED. REPLACED DAMAGED DOOR FRAME SECTION PER SRM. (M)SDR ASAA0310459Splice · corrodedPAE - DURING C-CHECK, FOUND THE KEEL BEAM SPLICE ANGLES AT FUSELAGE STATION 727-727A, RIGHT BUTTOCK LINE 6 CORRODED. REPLACED SPLICE ANGLES PER SRM. (M)SDR ASAA0310460Shear Tie · corrodedPAE - DURING C-CHECK, FOUND THE SHEAR TIE AT FUSELAGE STATION 987, STRINGER 24L-25L CORRODED. REPAIRED SHEAR TIE PER SRM. (M)SDR ASAA0310462Door Frame · gougedPAE - DURING C-CHECK, FOUND THE AFT CARGO DOOR FRAME AT FUSELAGE STATION 727B, STRINGER 20L GOUGED. REMOVED DAMAGED AREA AND REPAIRED DOOR FRAME PER SRM. (M)SDR ASAA0310463Shear Tie · corrodedPAE - DURING C-CHECK, FOUND THE SHEAR TIE AT FUSELAGE STATION 727A, RIGHT BUTTOCK LINE 8 CORRODED. REPLACED SHEAR TIE PER SRM. (M)SDR ASAA0310444Seat Track · corrodedPAE - DURING C-CHECK, FOUND THE SEAT TRACK AT BODY STATION 540-727B, WATERLINE 208 CORRODED. REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0310445Gusset · crackedPAE - DURING C-CHECK, FOUND NR 2 ENGINE FAIRING GUSSET AT NACELLE STATION 99.25 CRACKED. REPLACED GUSSET PER SRM. (M)SDR ASAA0310442Frame · dentedPAE - DURING C-CHECK, FOUND THE FRAME AT BODY STATION 500, STRINGER 23R-25R DENTED. CUT OUT DAMAGED SECTION AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310443Frame · dentedPAE - DURING C-CHECK, FOUND THE FRAME AT BS 727B, STRINGER 24L-25L DENTED. CUT OUT DAMAGED SECTION AND REPAIRED FRAME PER SRM. (M)SDR ASAA0310414Stringer Clip · crackedPAE - DURING C-CHECK, FOUND STRINGER CLIP AT BODY STATION 277, STRINGER 26L CRACKED. REPLACED STRINGER CLIP PER SRM. (M)SDR ASAA0310409Support · corrodedPAE - DURING C-CHECK, FOUND SIDEWALL SUPPORT AT BS 500A-520, STRINGER 26R CORRODED. REPLACED SUPPORT PER SRM. (M)SDR ASAA0310008Torque Tube · damagedSEA - CREW REPORTED THE R2 DOOR WAS DIFFICULT TO OPERATE THROUGH THE OPEN AND CLOSE CYCLE. S/D REMOVED AND REPLACED AFT GALLEY DOOR TORQUE TUBE (P/N 65-45849-160) AND RIGGED R2 DOOR, THEN DOOR OPERATED WITHIN LIMITS. (M)
Back to N730AS