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 ASAA0410399Skin · dentedFUSELAGE SKIN HAS DENT. CUT OUT DAMAGED AREA, AND INSTALLED EXTERNAL SKIN PATCH.SDR ASAA0410397Structure · corrodedPAE - FOUND CORROSION AT RIGHT MLG WHEEL WELL ON CHORD. CUTOUT DAMAGED AREA AND SPLICE IN NEW AREA PER SRM. (M)SDR ASAA0410396Stringer · damagedPAE - FOUND ELONGATED FASTENER HOLE IN STRINGER 18L UPPER FLANGE AT BS 905. REMOVED DISCREPANT AREA, INSTALLED REPAIR STRINGER SPLICE. (M)SDR ASAA0410394Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBAM UPPER CHORD. REPAIRED FLOORBEAM UPPER CHORD AFT FLANGE. (M)SDR ASAA0410395Beam · corrodedPAE - FOUND CORROSION ON LONGITUDINAL BEAM. REMOVED AND REPLACED LONGITUDINAL BEAM. (M)SDR ASAA0410391Floorbeam · corrodedPAE - FOUND CORROSION BOTTOM LOWER LOBE OF FLOORBEAM. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASAA0410393Stringer · crackedPAE - FOUND STRINGER 19R CRACKED .250 INCH AT 2 HOLE LOCATIONS. REMOVED DAMAGED/CRACKED STRINGER, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASAA0410392Shear Tie · crackedPAE - FOUND SHEAR TIE CRACKED AT 2 FASTENER HOLE LOCATIONS. REMOVED AND REPLACED SHEAR TIE. (M)SDR ASAA0410389Stringer Clip · damagedPAE - FOUND STRINGER HAS MECHANICAL DAMAGE TO STRINGER CLIP. REMOVED DAMAGED STRINGER CLIP, FABRICATED NEW STRINGER CLIP AND INSTALLED. (M)SDR ASAA0410390Shear Tie · corrodedPAE - FOUND CORROSION ON SHEARTIE, FORWARD AND AFT SIDES. FOUND CORROSION BLENDOUT TO BE 'OUT OF LIMITS'. REMOVED, FABRICATED AND INSTALLED SHEAR TIE. (M)SDR ASAA0410388Frame · gougedPAE - FOUND FRAME DAMAGED. REPAIRED FRAME BY INSTALLING DOUBLER. (M)SDR ASAA0410387Frame · crackedPAE - FOUND FRAME CRACKED INBOARD FLANGE STATION 296. REMOVED DAMAGED SECTION OF FRAME, FABRICATED REPAIR PARTS AND INSTALLED. (M)SDR ASAA0410386Frame · corrodedPAE - FOUND CORROSION ON FRAME. REMOVED DAMGAED PARTS, FABRICATED AND INSTALLED REPAIR PARTS. (M)SDR ASAA0410385Stringer Clip · corrodedFOUND CORROSION ON STRINGER CLIP. BLENDED CORROSION, FOUND OUT OF LIMITS, FABRICATED AND INSTALLED. (M)SDR ASAA0410384Beam · corrodedFOUND CORROSION ON LONGITUDINAL BEAM. REMOVED AND REPLACED LONGITUDINAL BEAM. (M)SDR ASAA0410383Stringer · corrodedPAE - FOUND CORROSION ON STRINGER. REMOVED AND REPLACED STRINGER. (M)SDR ASAA0410381Stringer Clip · corrodedPAE - CORROSION FOUND ON STRINGER CLIP. REMOVED DAMAGE, FABRICATED AND INSTALLED STRINGER CLIP. (M)SDR ASAA0410380Stringer · corrodedPAE - FOUND CORROSION ON STRINGER. REMOVED DAMAGE, FABRICATED AND INSTALLED STRINGER REPAIR. (M)SDR ASAA0410382Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE. REMOVED, FABRICATED AND INSTALLED SHEAR TIE. (M)SDR ASAA0410378Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE AROUND LOWER FASTENER. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE PER SRM. (M)SDR ASAA0410379Shear Tie · corrodedFOUND CORROSION ON SHEAR TIE BETWEEN STRINGER 26L AND 27L. REMOVED DAMAGED SHEAR TIE, FABRICATED AND INSTALLED NEW SHEAR TIE IAW SRM. (M)SDR ASAA0410377Skin · gougedPAE - FOUND FUSELAGE SKIN IS GOUGED AT BS 902 STRINGER 19R. REPAIRED PER SRM. (M)SDR ASAA0410373Seat Track · corrodedFOUND CORROSION ON FLOOR SEAT TRACK FLANGE STATION 500A THROUGH S TO 500B LBL 45 WL 208. REPLACES SEAT TRACK BS 480-520 LBL 45 WL 200. (M)SDR ASAA0410375Stringer · corrodedFOUND CORROSION ON STRINGER BS 787 PLUS 5 INCHES STRINGER 22R WL 155. REMOVED AND REPLACED STRINGER BS 773-792 STRINGER 22R, WL 5. (M)SDR ASAA0410374Seat Track · corrodedPAE - FOUND CORROSION C53-107-01-03 ON SEAT TRACK BS 827-867 LBL 25 WL 208. REMOVED AND REPLACED SEAT TRACK BS 827-867 LBL 25, WL 208. (M)SDR ASAA0410371Cowling · wornFOUND NR 2 ENGINE NOSE COWL AFT LIP REPAIR WORN/DENTED. REMOVED AND REPLACED LOWER AFT CAP. (M)SDR ASAA0410372Web · damagedFOUND AFT WEB SECTION DAMAGED. REPLACED WEB. (M)SDR ASAA0410369Stringer · chafedPAE - FOUND CHAFED STRINGER. REMOVED AND REPLACED CHAFED STRINGER. (M)SDR ASAA0410367Stringer Clip · corrodedPAE - FOUND CORROSION ON STRINGER CLIP. REMOVED OLD STRINGER CLIP AND INSTALLED NEW STRINGER CLIP. (M)SDR ASAA0410365Frame · chafedFOUND CHAFED FRAME. REPAIRED FRAME. (M)SDR ASAA0410366Stringer Clip · corrodedFOUND CORROSION ON STRINGER CLIP. REMOVED OLD STRINGER CLIP AND INSTALLED NEW STRINGER CLIP. (M)SDR ASAA0410364Stringer · chafedPAE - FOUND CHAFED STRINGER. REPAIRED STRINGER. (M)SDR ASAA0410363Door Frame · corrodedPAE - FOUND CORROSION ON E/E BATTERY DOOR CUTOUT FORWARD FRAME. REPAIRED DOOR FRAME, CUTOUT. (M)SDR ASAA0410358Stringer Clip · corrodedPAE - FOUND CORROSION ON STRINGER CLIP. REMOVED, FABRICATED NEW AND INSTALLED. (M)SDR ASAA001ABattery Pack · inoperativeDURING RECON INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHT AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK THEN LIGHT TESTED NORMAL. (M)SDR ASAA01100NNBattery Pack · inoperativeDURING RECON INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0410039Battery Pack · inoperativeANC - DURING RECON INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 20 INOPERATIVE. REPLACED BATTERY PACK THEN LIGHTS TESTED NORMAL. (M)SDR ASAA20042Battery Pack · inoperativeANC - DURING RECON INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 8 INOPERATIVE. REPLACED BATTERY PACK THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0410036Battery Pack · inoperativeANC - DURING RECON INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 8 INOPERATIVE. REPLACED BATTERY PACK THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310686Battery Pack · inoperativeANC - DURING SCHEDULED INSPECTION, FOUND THE EXIT IDENTIFIER ON THE SMOKE BARRIER INOPERATIVE. REPLACED BATTERY PACK, THEN EXIT IDENTIFIER TESTED NORMAL. (M)SDR ASAA0310685Battery Pack · inoperativeANC - DURING SCHEDULED INSPECTION, FOUND EMERGENCY FLOOR TRACK LIGHTS AT ROW 9 INOPERATIVE. REPLACED BATTERY PACK, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310673Battery Pack · dischargedANC - EMERGENCY EXIT IDENTIFIER FOR THE RIGHT OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK, THEN EXIT IDENTIFIER TESTED NORMAL. (M)SDR ASAA0310643Battery Pack · dischargedANC - FOUND EMERGENCY FLOOR TRACK LIGHTS ON SEAT PALLET 9-5 INOPERATIVE. REPLACED BATTERY PACK, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310560Battery · dischargedANC - FOUND EMERGENCY EXIT IDENTIFIER ON THE SMOKE BARRIER INOPERATIVE. REPLACED BATTERY, THEN EXIT IDENTIFIER TESTED NORMAL. (M)SDR ASAA0310530Battery · inoperativeANC - FOUND EMERGENCY EXIT IDENTIFIER ON THE SMOKE BARRIER INOPERATIVE. REPLACED BATTERY, THEN EXIT IDENTIFIER TESTED NORMAL. (M)SDR ASAA0310523Battery Pack · inoperativeSEA - EMERGENCY FLOOR TRACK LIGHTS AT SEAT PALLET 8-9 INOPERATIVE. REPLACED BATTERY PACKS, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310520Battery · dischargedSEA - EMERGENCY EXIT IDENTIFIER ON THE SMOKE BARRIER INOPERATIVE. REPLACED REMOTE ASSEMBLY BATTERY, THEN LIGHT TESTED NORMAL. (M)SDR ASAA0310519Battery Pack · dischargedANC - EMERGENCY FLOOR TRACK LIGHTS AT SEAT PALLET 8-11 INOPERATIVE. REPLACED BATTERY PACKS, THEN LIGHTS TESTED NORMAL. (M)SDR ASAA0310507Skin Panel · corrodedDURING SCHEDULED C-CHECK, FOUND THE INTERNAL SKIN PANEL AT FUSELAGE STATION 334, STRINGER 28L CORRODED. REMOVED CORROSION AND REPAIRED SKIN PER SRM AND EA. (M)SDR ASAA0310504Frame · corrodedDURING SCHEDULED C-CHECK, FOUND THE FRAME AT FUSELAGE STATION 887, STRINGER 24L-25L CORRODED. REMOVED DAMAGED SECTION OF FRAME AND REPAIRED PER SRM. (M)
Back to N746AS