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 ASAA0410459Floor Panel · crackedPAE - CRACKED FLOOR WEB IN FWD LAVATORY. REPAIRED WITH DOUBLER.SDR ASAA0410458Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM LOWER FLANGE, LOWER SURFACE. REPAIRED WITH DOUBLER.SDR ASAA0410457Skin · chafedPAE - FUSELAGE SKIN DAMAGED FROM CHAFING. REMOVED DAMAGED SKIN, FABRICATED, NEW SKIN AND INSTALLED.SDR ASAA0410451Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM LWR CHORD. REPAIRED FLOORBEAM LWR CHORD IAW EA.SDR ASAA0410450Stringer · chafedPAE - CHAFED STRINGER. REPAIRED IAW EA.SDR ASAA0410449Skin · nickedPAE - EXTERIOR SKIN HAS NICKS. REPAIRED SKIN IAW EA.SDR ASAA0410448Beam · corrodedPAE - CORROSION ON LONGITUDINAL BEAM. REMOVED AND REPLACED LONGITUDINAL BEAM.SDR ASAA0410447Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410446Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410445Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410444Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410443Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410442Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410441Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410440Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410439Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410438Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410437Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410436Sill · corrodedPAE - CORROSION ON AFT GALLEY DOOR MOP SILL. REPLACED MOP SILL.SDR ASAA0410434Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410430Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410431Frame · corrodedPAE - FRAME IS CORRODED. REMOVED CORRODED CAP, FABRICATED NEW CAP TO BE INSTALLED ON CARD NR 4846121.SDR ASAA0410433Stringer · crackedPAE - CRACKED STRINGER. REMOVED AND REPLACED STRINGER.SDR ASAA0410432Web · corrodedPAE - CORROSION ON THRESHOLD WEB AFT GALLEY DOOR CUT OUT. REMOVED AND REPLACED WEB.SDR ASAA0410429Frame · crackedPAE- CRACK IN FASTENER HOLE IN FRAME. REMOVED AND REPLACED FRAME.SDR ASAA0410425Shear Tie · corrodedCORROSION ON SHEAR TIE. REMOVED SHEAR TIE FABRICATED NEW SHEAR TIE AND INSTALLED.SDR ASAA0411428Skin · crackedPAE - 50 HOLES HAVE CRACK INDICATIONS AT SKIN LAP. REPAIRED DISCREPANT HOLES IAW EA. OVERSIZED .0312 INCH.SDR ASAA0410427Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED SKIN IAW EA.SDR ASAA0410426Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED SKIN IAW EA.SDR ASAA0410424Shear Tie · damagedPAE - FOUND 8 EACH, BACC HOLE IN SHEAR TIE. REMOVED AND REPLACED SHEAR TIE IAW SRM.SDR ASAA0410418Skin · crackedPAE- 5 HOLES WITH CRACK INDICATIONS. OVERSIZED HOLES AND INSTALLED REPAIR DOUBLERS.SDR ASAA0410422Angle · corrodedPAE - CORROSION ON UPPER FLANGE OF L-ANGLE. REMOVED CORROSION IN AN AREA 1 INCH X 20 INCHES. REMOVING .075 INCHES FROM AN ORIGINAL .200 INCHES, FOUND TO BE OUT OF LIMITS. REPAIRED IAW EA.SDR ASAA0410421Skin · damagedPAE - DAMAGE IN SKIN AT LAP. BLENDED DAMAGE AND INSTALLED REPAIR DOUBLERS.SDR ASAA0410420Skin · damagedPAE - SCRIBE MARKS IN SKIN AT LAP. BLENDED SCRIBE MARKS AND INSTALLED REPAIR DOUBLERS.SDR ASAA0410419Skin · gougedPAE- SKIN GOUGED UNDER LAP. BLENDED GOUGED SKIN AND INSTALLED REPAIR DOUBLER.SDR ASAA0410417Skin · damagedDAMAGE AT SKIN LAP. BLENDED DAMAGE AND INSTALLED REPAIR DOUBLER.SDR ASAA0410414Skin · scoredLOWER SKIN OF LAP IS SCORED BETWEEN THE CENTER AND LOWER ROW OF FASTNERS. REPAIRED SKIN IAW EA.SDR ASAA0410413Skin · scoredLOWER SKIN OF LAP IS SCORED BETWEEN THE CENTER AND LOWER ROW. REPAIRED SKIN IAW EA.SDR ASAA0410412Skin · damagedDAMAGE ON EXTERNAL SKIN. REPAIRED DAMAGE ON SKIN IAW EA.SDR ASAA0410411Skin · damagedDAMAGE ON EXTERNAL SKIN. REPAIRED DAMAGE IAW EA.SDR ASAA0410409Skin · dentedSTRINGER 14L AT BS 500-540 REQUIRES REWORK TO CHANGE SHIMMING REQUIREMENTS. REMOVED EXISTING REPAIR, FABRICATED -7, -6, AND -2 DOUBLER`S AND REINSTALLED.SDR ASAA0410403Lap Joint · damagedSCRIBE MARK IN EXTERNAL SKIN LAP JOINT. REPAIRED SCRIBE MARK ON SKIN LAP.SDR ASAA0410408Skin · damagedDAMAGE ON SKIN. REPAIRED DAMAGE ON SKIN.SDR ASAA0410407Skin · damagedDAMAGE ON SKIN. REPAIRED DAMAGE ON SKIN.SDR ASAA0410406Skin · damagedDAMAGE ON SKIN. REPAIRED DAMAGE ON SKIN.SDR ASAA0410405Skin · damagedDAMAGE ON SKIN. REPAIRED DAMAGE ON SKIN.SDR ASAA0410404Skin · damagedSKIN DAMAGED. REPAIRED DAMAGE ON SKIN LAP.SDR ASAA0410402Lap Joint · damagedDAMAGE ON EXTERNAL SKIN LAP JOINT. REPAIRED DAMAGE ON SKIN LAP.SDR ASAA0410401Butt Joint · damagedDAMAGE ON BUTT SPLICE. REMOVED AND REPLACED BUTT SPLICE.SDR ASAA0410400Floorbeam · corrodedCORROSION ON FLOORBEAM AT FLANGE AROUND NUT PLATE. REMOVED CORROSION, AND REPAIRED FLOORBEAM.
Back to N746AS