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 ASAA0410643Web · crackedPAE - DURING D-CHECK, FOUND WEB CRACKED AT LOWER END. REMOVED AND REPLACED WEB PER SRM. (M)SDR ASAA0410641Skin · damagedPAE - FOUND DURING D-CHECK, DAMAGE ON SKIN LAP, MAIN CARGO DOOR. REPAIRED PER EA 5230-01250. (M)SDR ASAA0410644Angle · damagedPAE - FOUND DURING D-CHECK, DAMAGE IN FASTENER HOLE ON L ANGLE. REMOVED AND REPLACED L ANGLE PER SRM. (M)SDR ASAA0410618Skin · damagedPAE - DURING D-CHECK, FOUND DAMAGE ON EXTERNAL SKIN AT BS 907, STRINGER 14L. REPAIRED PER EA 5330-01846. (M)SDR ASAA0410622Shear Tie · crackedPAE - DURING D-CHECK, FOUND SHEAR TIE ANGLE CRACKED. REMOVED AND REPLACED SHEAR TIE PER SRM. (M)SDR ASAA0410615Spar · crackedPAE - DURING D-CHECK, FOUND HORIZ STAB CENTER SECTION, UPPER AFT SPAR CHORD IS CRACKED. REPAIRED PER EA 5210-01203. (M)SDR ASAA0410609Skin · damagedPAE - FOUND DURING D-CHECK, DAMAGE ON SKIN A LAP. REPAIRED PER EA 5330-01835. (M)SDR ASAA0410608Skin · damagedPAE - DURING D-CHECK, DAMAGE ON SKIN AT LAP. REPAIRED PER EA 5330-01835. (M)SDR ASAA0410639Bear Strap · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON BEAR STRAP AT BS 348. REPAIRED PER EA 5310-02415. (M)SDR ASAA0410610Skin · gougedPAE - DURING D-CHECK, FOUND FUSELAGE SKIN GOUGED AT BTM OF MAIN CARGO DOOR CUTOUT, FUSELAGE STATION 398. REPAIRED PER EA 5330-01861. (M)SDR ASAA0410611Stringer Clip · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON STRINGER CLIP. REMOVED, FABRICATED AND INSTALLED STRINGER CLIP PER SRM. (M)SDR ASAA0410613Frame · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON FRAME DOUBLER AT BS 787, STRINGER 23R, WL 156. REMOVED, FABRICATED AND INSTALLED FRAME DOUBLER PER SRM. (M)SDR ASAA0410612Stringer Clip · corrodedPAE - DURING D-CHECK, FOUND CORROSION ON STRINGER CLIP. REMOVED, FABRICATED AND INSTALLED STRINGER CLIP PER SRM. (M)SDR ASAA0410580Skin · gougedPAE - GOUGES IN SKIN AT BOTTOM OF MAIN CARGO DOOR CUTOUT. REPAIRED IAE EA.(K)SDR ASAA0410599Stringer · damagedPAE - ELONGATED FASTENER HOLE IN STRINGER. REMOVED DISCREPANT AREA, INSTALLED REPAIR STRINGER SPLICE. (M)SDR ASAA0410662Skin · damagedPAE- D-CHECK, DAMAGE ON EXTERNAL SKIN. REPAIRED IAW EA.SDR ASAA0410600Skin · damagedPAE -DAMAGE ON SKIN. REPAIRED IAW EA.SDR ASAA0410589Skin · damagedDAMAGE ON EXTERNAL SKIN LAP. REPAIRED IAW EA.SDR ASAA0410588Skin · lightning strikePAE - LIGHTING STRIKE HOLE IN EXTERNAL SKIN. REPAIRED IAW EA.SDR ASAA0410587Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED IAW EA.SDR ASAA0410586Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED IAW EA.SDR ASAA0410585Skin · damagedPAE - DAMAGE ON SKIN LAP. REPAIRED IAW EA.SDR ASAA0410598Skin · damagedPAE - FOUND DAMAGE ON SKIN. REPAIRED PER EA. (M)SDR ASAA0410592Skin · damagedPAE - DAMAGE ON EXTERNAL SKIN AT LAP JOINT. REPAIRED PER EA. (M)SDR ASAA0410591Skin · damagedPAE - DAMAGEON EXTERNAL SKIN. REPAIRED PER EA. (M)SDR ASAA0410597Floorbeam · corrodedPAE - FOUND CORROSION ON FLOORBEAM AT FASTENER HOLE UPPER AND LOWER SURFACE OF UPPER FLANGE. REPLACED STUB BEAM. (M)SDR ASAA0410596Splice · corrodedPAE - FOUND CORROSION ON STRINGER SPLICE. REMOVED AND REPLACED STRINGER SPLICE AND CLIP. (M)SDR ASAA0410595Stringer · corrodedPAE - FOUND CORROSION ON STRINGER. REMOVED AND REPLACED STRINGER. (M)SDR ASAA0410584Web · corrodedPAE - CORROSION ON WEB RT SIDE OF E AND E DOOR CUTOUT. REMOVED AND REPLACED.SDR USAA0410583Skin · damagedPAE - DAMAGE ON EXTERNAL SKIN. REPAIRED IAW EA.SDR ASAA0410582Skin · damagedDAMAGE ON EXTERNAL SKIN LAP JOINT, 2 INCH LONG. REPAIRED IAW EA.SDR ASAA0410581Skin · damagedPAE - DAMAGE ON EXTERNAL SKIN LAP JOINT, 18 INCHES LONG. REPAIRED IAW EA.SDR ASAA0410579Skin · damagedPAE - DAMAGE ON EXTERNAL SKIN LAP 4 INCHES LONG. REPAIRED IAW EA.SDR ASAA0410578Skin · damagedPAE - DAMAGE ON EXTERNAL SKIN LAP 6 INCHES LONG. REPAIRED IAW EA.SDR ASAA0410577Skin · damagedPAE - MULTIPLE OUTER PLY DAMAGE ON RUDDER L/E. REPAIRED IAW EA.SDR ASAA0410576Support Angle · crackedPAE - SUPPORT ANGLE CRACKED. REMOVED, FABRICATED NEW ANGLE AND INSTALLED.SDR ASAA0410575Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM UPPER FLANGE. REMOVED CORROSION, FABRICATED REPAIR PARTS AND INSTALLED.SDR ASAA0410574Skin · damagedPAE - SCRIBE MARK IN SKIN. REPAIRED IAW EA.SDR ASAA0410573Stringer · corrodedPAE - CORROSION ON STRINGER. REPLACED STRINGER.SDR ASAA0410572Frame · damagedPAE - FRAME DAMAGED. REPAIRED FRAME BY INSTALLING DOUBLER.SDR ASAA0410571Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM ON TOP OF LWR FLANGE LWR SURFACE. REPAIRED IAW EA.SDR ASAA0410570Floorbeam · corrodedPAE - CORROSION ON FLOORBEAM ON TOP OF LWR FLANGE AROUND NUTPLATE. REMOVED CORROSION AND REPAIRED FLOORBEAM.SDR ASAA0410569Stringer · chafedPAE - STRINGER CHAFED AT WIRE BUNDLE STANDOFF. REPAIRED STRINGER IAW SRM.SDR ASAA0410603Web · corrodedPAE - FOUND CORROSION AT AFT CARGO DOOR CUTOUT FOWARD FRAME CLOSEOUT PANEL FASTENER HOLES. REPLACED AFT CARGO DOOR CLOSEOUT WEB. (M)SDR ASAA0410602Sill · corrodedPAE - CORROSION ON MOPSILL, REPLACED. (M)SDR ASAA0410590Skin · dentedPAE - DENT IN EXTERNAL SKIN UNDER PREVIOUSLY INSTALLED REPAIR. REPAIRED PER EA. (M)SDR ASAA0410605Skin · damagedPAE - FOUND DAMAGED ON SKIN. REPAIRED PER EA. (M)SDR ASAA0410604Floorbeam · corrodedPAE - FOUND CORROSION LOWER FLOORBEAM. REPAIRED TRANSVERSE BEAM PER EA. (M)SDR ASAA0410601Skin · damagedPAE - DAMAGE ON SKIN. REPAIRED PER EA. (M)SDR ASAA0410594Skin · damagedPAE - FOUND DAMAGED ON EXTERNAL SKIN AT LAP JOINT. REPAIRED PER EA. (M)
Back to N746AS