N742AS
Service difficulty reports not matched to an aircraft · 548
They name N742AS, 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 = 'N742AS' 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 = 'N742AS' 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 ASAA0610378Stringer · corrodedFOUND STRINGER CORRODED. REPAIRED STRINGER PER SRM 53 10 3 FIG 1.SDR ASAA0610381Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51 10 1 AND 51 70 1.SDR ASAA0610380Stiffener · crackedFOUND FLOORBEAM STIFFENER CRACKED. REPLACED STIFFENER WITH FABRICATED REPAIR PART PER SRM 51 20 01 FIG 7 AND 51 30 02.SDR ASAA0610371Frame · corrodedFOUND FRAME CORRODED. FRAME WEB REPAIRED PER SRM 53 10 04 FIG 8.SDR ASAA0610369Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 53 10 4 FIG 8.SDR ASAA0610372Frame · corrodedFOUND FRAME TO SKIN CORRODED. FRAME TO SKIN REPAIRED PER SRM 51 10 4.SDR ASAA0610370Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51 10 1 AND 53 10 1.SDR ASAA0610368Tie Clip · corrodedFOUND TIE CLIP CORRODED. REPLACED TIE CLIP IAW SRM 51 30 2 AND 51 30 05.SDR ASAA0610367Tie Clip · corrodedFOUND TIE CLIP CORRODED. REPLACED TIE CLIP.SDR ASAA0610366Shear Tie · corrodedFOUND SHEAR TIE CORRODED. FABRICATED AND REPLACED SHEAR TIE PER SRM 51 30 02.SDR ASAA0610365Tie Clip · corrodedFOUND TIE CLIP CORRODED. REPLACED TIE CLIP PER SRM 51 30 02.SDR ASAA0610331Skin · crackedFOUND RT WING LE SKIN CRACKED AT NUMBER 4 SLAT ACTUATOR CUTOUT. REPAIRED PER SRM 57 30 4 FIG 5.SDR ASAA0610330Skin · crackedRT WING LE SKIN CRACKED AT NR 5 SLAT CENTER STOP. REPAIRED PER SRM 57 30 4 FIG 5.SDR ASAA0610332Tank · crackedFOUND RT WING FUEL TANK CRACKED. REPAIRED IAW SB 737 57 1186 ERO 5287 AND ASA EA 5710 01127.SDR ASAA0610356Spar · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION. ERO 5334 PARTS 1 TO 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235 CARRIED OUT.SDR ASAA0610355Spar · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION, ERO 5334 PARTS 1 TO 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235 CARRIED OUT.SDR ASAA0610354Spar · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION. ERO 5334 PARTS 1 TO 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235 CARRIED OUT.SDR ASAA0610353Spar · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION. ERO 5334 PARTS 1 TO 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235 CARRIED OUT.SDR ASAA0610352Spar · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION, ERO 5334 PARTS 1 TO 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235 CARRIED OUT.SDR ASAA0610351Spar · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION. ERO 5334 PARTS 1 TO 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235 CARRIED OUT.SDR ASAA0610350Structure · corrodedCARRY OUT CASCADE ERO 5344 RT HORIZ STAB FRONT AND REAR SPAR BUSHING INSPECTION AND REPLACEMENT DUE TO CORROSION. ERO 5334 PARTS 1 TO PART 16 AS APPLICABLE TO RT HORIZ STAB AND AS EA 5510 01235.SDR ASAA0610349Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED CORRODED FLOORBEAM PER EA 5310 02589.SDR ASAA0610348Frame · crackedFOUND FWD PASSENGER CABIN FRAME CRACKED. REPAIRED CRACKED FRAME PER SRM 53 10 4 FIG 11.SDR ASAA0610342Stringer Clip · corrodedFOUND TIE CLIP CORRODED. REPLACED TIE CLIP IAW SRM 51 30 02 AND 51 30 05.SDR ASAA0610341Shear Tie · gougedFOUND SHEAR TIE GOUGED. REPLACED SHEAR TIE IAW SRM 53 10 2.SDR ASAA0610340Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51 20 1 AND 51 30 02.SDR ASAA0610339Stringer Clip · corrodedFOUND TIE CLIP CORRODED. INSTALLED FABRICATED REPAIR PART PER SRM 51 30 2 PG 8 PARAGRAPH 8.SDR ASAA0610338Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REPAIRED SHEAR TIE IAW SRM 53 10 4 FIG 9A.SDR ASAA0610337Frame · corrodedFOUND FRAME CORRODED. REPAIRED CORRODED FRAME SECTION PER SRM 53 10 4.SDR ASAA0610336Stringer · crackedFOUND STR 17R CRACKED AT TIE CLIP RIVET, STR 17R REPAIRED IAW SRM 52 10 3.SDR ASAA0610334Stringer Clip · crackedFOUND TIE CLIP CRACKED. REPLACED TIE CLIP PER SRM 51 30 02 AND 53 10 01 FIG 1.SDR ASAA0610333Sill · corrodedFOUND SILL CORRODED. REPLACED CORRODED SILL PER SRM 53 10 2.SDR ASAA0610328Stringer · corrodedFOUND STR 24 LT CORRODED. REPAIRED PER SRM 53 10 3 FIG 1 AND EA 5310 02603.SDR ASAA0610347Floorbeam · maint errorFOUND FLOORBEAM HAS DOUBLE DRILLED HOLES. REPAIRED FLOORBEAM WITH FABRICATED REPAIR PART.SDR ASAA0610346Shear Tie · corrodedFOUND SHEAR TIE CORRODED. REPLACED SHEAR TIE PER SRM 51 30 2.SDR ASAA0610344Shear Tie · corrodedFOUND SHEAR TIE CORRODED. SHEAR TIE ANGLE REPLACED WITH FABRICATED REPAIR PART PER SRM 51 20 1.SDR ASAA0610343Stringer Clip · crackedFOUND TIE CLIP CRACKED. REPLACED CRACKED TIE CLIP PER SRM 51 30 5.SDR ASAA0610335Tie Clip · crackedFOUND TIE CLIP CRACKED. REPLACED TIE CLIP PER SRM 53 30 02 FIG 11.SDR ASAA0610329Shear Tie · crackedFOUND MAIN CARGO DOOR INTERIOR FRAME TO SKIN WEB CRACKED. REPAIRED PER SRM 51 40 3 FIG 1.SDR ASAA0610327Shear Tie · crackedFOUND MAIN CARGO DOOR FRAME TO SKIN CRACKED. REPAIRED PER SRM 51 40 30 FIG 1.SDR ASAA0610326Shear Tie · crackedFOUND FRAME TO SKIN ATTACH ANGLE CRACKED. REPLACED ANGLE PER SRM 51 40 3 FIG 1.SDR ASAA0610325Angle · crackedFOUND MAIN CARGO DOOR NR 1 LATCH SUPPORTING ANGLE CRACKED. LATCH REPAIRED IAW SRM 53 30 02 AND EA 5230 01269.SDR ASAA0610310Stringer · corrodedFOUND STRINGER CORRODED. STRINGER SPLICE REPAIRED IAW SRM 53 10 1 AND EA 5310 02588.SDR ASAA0610309Stringer · corrodedFOUND STRINGER CORRODED. REPAIRED STRINGER PER SRM 53 10 3 AND EA 5310 02582.SDR ASAA0610308Fitting · corrodedFOUND STRINGER END FITTING CORRODED. REPLACED END FITTING PER SRM 51 20 1.SDR ASAA0610289Sill · corrodedFOUND L2 DOOR SILL ANGLE CORRODED. REPLACED SILL CHORD IAW SRM 53 30 2.SDR ASAA0610298Skin · dentedFOUND FUSELAGE SKIN DENTED. REPAIRED DENTED SKIN IAW SRM 53 30 3 FIG 23.SDR ASAA0610306Stringer · gougedFOUND STRINGER GOUGED. REPAIRED GOUGED STRINGER PER EA 5310 02605 AND ERO 5549.SDR ASAA0610305Stringer · corrodedFOUND STRINGER CORRODED. REPAIRED STRINGER IAW SRM 53 10 3 FIG 1.SDR ASAA0610304Floorbeam · corrodedFOUND FLOORBEAM CORRODED. REPAIRED FLOORBEAM IAW EA 5310 02602 AND ERO 5606.
Back to N742AS