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 ASAA0410593Skin · damagedPAE - DAMAGE ON EXTERNAL SKIN AT LAP JOINT. REPAIRED PER EA. (M)SDR ASAA0410632Skin · damagedPAE - FOUND DURING D-CHECK, SCRIBE MARK ON SKIN LAP AT STRINGER 14L. REPAIRED PER EA 5230-01250. (M)SDR ASAA0410564Skin · damagedPAE - SCRIBE MARKS AT RT FWD UPPER AND LOWER WING TO BODY FAIRING. REPAIRED IAW EA.SDR ASAA0410561Web · corrodedPAE - CORROSION ON AFT CARGO DOOR CUT OUT UPPER FRAME CLOSURE WEB. REPLACED UPPER FRAME CLOSURE WEB.SDR ASAA0410546Floorbeam · corrodedPAE - FOUND CORROSION LOWER FLOORBEAM BS 787 STRINGER 18R WL 201. REPAIRED TRANSVERSE BEAM PER EA 5310-02402 AND EO 04-3651. (M)SDR ASAA0410548Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED PER EA. (M)SDR ASAA0410547Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED PER EA. (M)SDR ASAA0410545Door Frame · crackedPAE - MAIN CARGO DOOR FRAME CRACKED. REPLACED FRAME PER SRM. (M)SDR ASAA0410553Skin · damagedPAE - DAMAGE AT SKIN LAP. REPAIRED PER EA. (M)SDR ASAA0410551Skin · damagedPAE - FOUND DAMAGE APPROX 21 INCHES LONG. REPAIRED PER EA. (M)SDR ASAA0410550Skin · damagedPAE - DAMAGE APPROX 2 INCHES LONG. REPAIRED PER EA. (M)SDR ASAA0410560Skin · damagedPAE - FOUND DAMAGE AT STRINGER 14L, BS 986-1016. REPAIRED PER EA. (M)SDR ASAA0410559Skin · damagedPAE - DAMAGE AT STRINGER 14L, BS 907-947. REPAIRED PER EA. (M)SDR ASAA0410549Skin · crackedPAE - FOUND CRACK INDICATIONS AT SKIN LAP. REPAIRED PER EA. (M)SDR ASAA0410552Angle · crackedPAE - L-ANGLE CRACKED BS 292, 11 INCHES BELOW STRINGER 15L. REPAIRED PER EA. (M)SDR ASAA0410558Floorbeam · corrodedPAE - FLOORBEAM CORROSION AT FASTENER HOLES UPPER FLANGE, UPPER AND LOWER SURFACES. REPAIRED PER EA. (M)SDR ASAA0410556Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM. REPAIRED PER EA. (M)SDR ASAA0410557Skin · damagedPAE - SCRIBE MARK IN SKIN. REPAIRED IAW EA.SDR ASAA0410555Skin · damagedPAE - SCRIBE MARKS AROUND DOUBLER, LWR FWD CORNER OF FWD ENTRY DOOR CUTOUT. REPAIRED IAW EA.SDR ASAA0410554Skin · damagedPAE - SCRIBE MARKS AT SKIN LAP. REPAIRED IAW EA.SDR ASAA0410532Skin · damagedPAE - SCRIBE MARK IN EXTERNAL SKIN LAP JOINT STA 359, STRINGER 24L, 2 INCHES LONG. REPAIRED SCRIBE MARK.SDR ASAA0410531Skin · damagedPAE - DURING VISUAL INSPECTION OF LAP JOINT AT STRINGER 24L IAW ER 04-3622, SEC 1 FOUND ADDITIONAL SCRIBE MARKS FROM BS 259-360.SDR ASAA0410530Skin · damagedPAE - SCRIBE MARKS IN EXTERNAL SKIN, AT WING TO BODY FAIRING. REPAIRED SKIN IAW EA.SDR ASAA0410529Skin · damagedPAE - SCRIBE MARKS IN EXTERNAL SKIN, ALONG RT FWD WING TO BODY FAIRING. REPAIRED SKIN IAW EA.SDR ASAA0410528Skin · damagedPAE - SCRIBE MARKS IN EXTERNAL SKIN, ALONG RT AFT WING TO BODY FAIRING. REPAIRED SKIN IAW EA.SDR ASAA0410527Skin · damagedPAE - SCRIBE MARKS IN EXTERNAL SKIN, ALONG RT AFT WING TO BODY FAIRING. REPAIRED SKIN IAW EA.SDR ASAA0410518Skin · damagedPAE - SCRIBE MARKS ON EXTERNAL SKIN AT WING TO BODY FAIRING. REPAIRED EXTERNAL SKIN IAW EA.SDR ASAA0410517Skin · damagedPAE - SCRIBE MARKS ON EXTERNAL SKIN AT WING TO BODY FAIRING. REPAIRED EXTERNAL SKIN IAW EA.SDR ASAA0410516Skin · damagedPAE - SCRIBE MARKS ON EXTERNAL SKIN AT WING TO BODY FAIRING. REPAIRED EXTERNAL SKIN IAW EA.SDR ASAA0410515Skin · damagedPAE - SCRIBE MARKS ON EXTERNAL SKIN AT WING TO BODY FAIRING. REPAIRED EXTERNAL SKIN IAW EA.SDR ASAA0410499Web · corrodedPAE - CORROSION ON WEB. REPLACED WEB.SDR ASAA0410498Frame · misdrilledPAE - UPPER FRAME SECTION HAS MISDRILLED PILOT HOLES UNDER FRAME CAP. REPAIRED IAW SRM.SDR ASAA0410497Skin · damagedPAE - MECHANICAL DAMAGE, 8 AREAS. REPAIRED IAW EA.SDR ASAA0410496Skin · corrodedPAE - CORROSION ON SKIN, 3 INCHES BELOW AFT CARGO DOOR CUTOUT, UPPER AFT CORNER. REPAIRED IAW EA.SDR ASAA0410495Skin · nickedPAE - NICK IN SKIN. REPAIRED IAW EA.SDR ASAA0410494Skin · damagedPAE - SCRIBE MARK IN EXTERNAL SKIN AT AFT CARGO DOOR UPPER AFT CORNER. REPAIRED AFT CARGO DOOR IAW EA.SDR ASAA0410493Skin · damagedPAE - SCRIBE MARK IN EXTERNAL SKIN AT AFT CARGO DOOR. REPAIRED AFT CARGO DOOR IAW EA.SDR ASAA0410514Stringer Splice · corrodedPAE - CORROSION ON STRINGER SPLICE. REMOVED AND REPLACED AND STRINGER SPLICE.SDR ASAA0410513Stringer · corrodedPAE - CORROSION ON STRINGER. REMOVED AND REPLACED STRINGER.SDR ASAA0410512Stringer Clip · corrodedPAE - CORROSION ON INTERCOSTAL AND STRINGER CLIP. REMOVED AND REPLACED INTERCOSTAL AND STRINGER CLIP.SDR ASAA0410511Stringer · corrodedPAE - CORROSION ON STRINGER. REMOVED AND REPLACED STRINGER.SDR ASAA0410492Skin · dentedPAE - DENT IN SKIN. REPAIRED IAW EA.SDR ASAA0410488Skin · damagedPAE - DAMAGE ON SKIN. REMOVED DAMAGE AND INSTALLED REPAIR.SDR ASAA0410487Splice · corrodedPAE - CORROSION ON STRINGER SPLICE. REMOVED AND REPLACED STRINGER SPLICE.SDR ASAA0410486Sill · corrodedPAE - CORROSION ON UPPER SILL WEB. REMOVED AND REPLACED SILL WEB.SDR ASAA0410485Door Frame · dentedPAE - AFT CARGO DOOR CUTOUT UPPER CHORD DENTED. REPLACED CHORD.SDR ASAA0410484Web · corrodedPAE - CORROSION AT AFT CARGO DOOR CUT-OUT FWD FRAME CLOSEOUT PANEL FASTENER HOLES. REPLACED AFT CARGO DOOR CLOSE-OUT WEB.SDR ASAA0410483Splice · crackedPAE - PRODUCTION SPLICE IS CRACKED. REPLACED STRINGER SPLICE.SDR ASAA0410461Frame · corrodedPAE - CORROSION ON FRAME STRAP AND FRAME. REMOVED AND REPLACED FRAME IB AND OB STRAP AND REMOVED AND REPLACED FRAME.SDR ASAA0410460Frame · crackedPAE - CRACKED FRAME. REPAIRED.
Back to N746AS