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 ASAA0410672Seat Track · misinstalledPAE, D-CHECK: SEAT TRACK REQUIRES REPLACEMENT DUE TO FASTENER EDGE MARGIN. REPLACED SEAT TRACK.SDR ASAA0410668Web · corrodedPAE, D-CHECK: CORROSION ON LAV WEB. REPLACED WEB.SDR ASAA0410666Seat Track · damagedPAE, D-CHECK: CROWN TOOTH DAMAGED ON SEAT TRACK. REPLACED SEAT TRACK.SDR ASAA0410670Web · corrodedPAE, D-CHECK: CORROSION IN AFT CARGO WEB. REPLACED WEBSDR ASAA0410669Web · crackedPAE, D-CHECK: AFT CARGO DOOR UPLATCH WEB IS CRACKED. REPLACED.SDR ASAA0410665Seat Track · corrodedPAE, D-CHECK: CORROSION ON LWR SURFACE OF SEAT TRACK. REPLACED SEAT TRACK.SDR ASAAWeb · corrodedPAE, D-CHECK: CORROSION ON LAV WEB. REPLACED WEB.SDR ASAA0410667Web · corrodedPAE, D-CHECK: CORROSION ON UNDERSIDE AT WEB. REPLACED WEB.SDR ASAA0410663Skin · damagedPAE, D-CHECK: DAMAGE ON EXTERNAL SKIN. REPAIRED IAW EA.SDR ASAA0410637Bracket · damagedPAE - DURING D-CHECK, FOUND T-BRACKET HAS ELONGATED HOLES AT STATION 344. REMOVED, FABRICATED AND INSTALLED T-BRACKET PER SRM. (M)SDR ASAA0410635Channel · brokenPAE - DURING D-CHECK, FOUND CHANNEL AND ANGLE (P/N 656361514) SUPPORT END IS BROKEN OFF AT RIVET HOLE. REMOVED, FABRICATED AND REPLACED CHANNEL AND ANGLE SUPPORT PER SRM. (M)SDR ASAA0410623Seat Track · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON SEAT TRACK AT BS 727B. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410634Intercostal · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON FLOORBEAM INTERCOSTAL AT FASTENER HOLE. REMOVED AND REPLACED INTERCOSTAL PER SRM. (M)SDR ASAA0410648Support Angle · crackedPAE - DURING D-CHECK, FOUND SUPPORT ANGLE IS CRACKED. REMOVED AND REPLACED SUPPORT ANGLE PER SRM. (M)SDR ASAA0410647Intercostal · crackedPAE - DURING D-CHECK, FOUND FORWARD CARGO BAY INTERCOSTAL IS CRACKED. REMOVED AND REPLACED INTERCOSTAL PER SRM. (M)SDR ASAA0410646Intercostal · crackedPAE - DURING D-CHECK, FOUND FORWARD CARGO BAY INTERCOSTAL IS CRACKED. REMOVED AND REPLACED INTERCOSTAL PER SRM. (M)SDR ASAA0410636Intercostal · crackedPAE - DURING D-CHECK, FOUND INTERCOSTAL IS CRACKED AT BS 400-420. REMOVED AND REPLACED INTERCOSTAL PER SRM. (M)SDR ASAA0410630Web · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON WEB. REMOVED, FABRICATED AND REPLACED WEB PER SRM. (M)SDR ASAA0410624Seat Track · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON SEAT TRACK AT BS 947. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410645Web · crackedPAE - FOUND DURING D-CHECK, WEB AT STATION 980 HAS A CRACK. REMOVED AND REPLACED WEB PER SRM. (M)SDR ASAA0410642Bracket · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON BRACKET. REMOVED AND REPLACED BRACKET PER SRM. (M)SDR ASAA0410638Intercostal · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON INTERCOSTAL AT BS 953. REMOVED, FABRICATED AND INSTALLED INTERCOSTAL PER SRM. (M)SDR ASAA0410629Seat Track · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410625Seat Track · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON SEAT TRACK FLANGE AT STATION 480. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410621Seat Track · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410620Sill · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON UPPER SILL WEB AT STATION 794-847, INBOARD OF STRINGER 18R. REMOVED AND REPLACED PER SRM. (M)SDR ASAA0410628Seat Track · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410627Seat Track · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON SEAT TRACK. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410626Seat Track · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON SEAT TRACK AT STATION 727. REMOVED AND REPLACED SEAT TRACK PER SRM. (M)SDR ASAA0410617Skin · damagedPAE - DURING D-CHECK, FOUND DAMAGE AT SKIN LAP, STRINGER 4L. REPAIRED PER EA 5330-01845. (M)SDR ASAA0410616Seat Track · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FLOOR SEAT TRACK FLANGE. REMOVED AND REPLACED SEAT TRACK. (M)SDR ASAA0410614Seat Track · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON SEAT TRACK. REMOVED AND REPLACED TRACK PER SRM. (M)SDR ASAA0410656Web · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON WEB. REPLACED WEB. (M)SDR ASAA0410655Web · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON WEB. REPLACED WEB. (M)SDR ASAA0410653Intercostal · corrodedPAE - DURING D-CHECK, FOUND CORROSION INTERCOSTAL AND ATTACHMENTS. REPLACED INTERCOSTAL AND ATTACH ANGLES. (M)SDR ASAA0410652Intercostal · crackedPAE - DURING D-CHECK, FOUND FORWARD CARGO BAY INTERCOSTAL IS CRACKED. REMOVED, FABRICATED AND INSTALLED INTERCOSTAL. (M)SDR ASAA0410651Support Fitting · crackedPAE - DURING D-CHECK, WHILE WORKING LAP REPAIR AT BS 951, STRINGER 10R FOUND SUPPORT FITTING CRACKED. REMOVED, FABRICATED AND INSTALLED SUPPORT FITTING. (M)SDR ASAA0410661Skin · damagedPAE - DURING D-CHECK, FOUND DAMAGE ON EXTERNAL SKIN AT WING-TO-BODY FAIRING. REPAIRED PER EA. (M)SDR ASAA0410659Web · crackedPAE - DURING D-CHECK, WEB CRACKED. REPLACED WEB. (M)SDR ASAA0410658Door Frame · damagedPAE - DURING D-CHECK, ELONGATED HOLES IN WEB. REPLACED WEB. (M)SDR ASAA0410657Failsafe · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FAIL/SAFE CHORD. REPLACED FAIL/SAFE CHORD. (M)SDR ASAA0410660Housing · damagedPAE - DURING D-CHECK, FOUND LEFT CENTER SECTION HINGE DAMAGED AT CENTER SECTION ATTACH POINT. REPLACED LT STAB HINGE HOUSING. (M)SDR ASAA0410650Intercostal · crackedPAE - DURING D-CHECK, REJECTION INTERCOSTAL IS STILL CRACKED, FORWARD CARGO BAY INTERCOSTAL IS CRACKED. REMOVED, FABRICATED AND INSTALLED INTERCOSTAL. (M)SDR ASAA0410649Skin · damagedPAE - DURING D-CHECK, FOUND DAMAGE ON SKIN. REPAIRED PER EA. (M)SDR ASAA0410654Frame · chafedPAE - DURING D-CHECK, FOUND CHAFED FRAME ON APU ACCESS DOOR. REPLACED FRAME. (M)SDR ASAA0410671Floor Support · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FLOOR SUPPORT. REPLACED FLOOR SUPPORT. (M)SDR ASAA0410633Shear Tie · corrodedPAE - FOUND DURING D-CHECK, CORROSION ON SHEAR TIE AT STATION 328. REPAIRED SHEAR TIE PER SRM. (M)SDR ASAA0410631Skin · damagedPAE - FOUND DURING D-CHECK, DAMAGE ON EXTERNAL SKIN AT BS 908-913. REPAIRED PER EA 5330-01841. (M)SDR ASAA0410619Frame · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FRAME. REPAIRED PER SRM. (M)SDR ASAA0410640Skin · damagedPAE - DURING D-CHECK, FOUND DAMAGE ON SKIN LAP, MAIN CARGO DOOR. REPAIRED PER EA 5230-01250. (M)
Back to N746AS