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 ASAA0610302Seat Track · corrodedFOUND CORROSION ON SEAT TRACK BEAM. REPLACED SEAT TRACK BEAM PER EA 5310 02604 AND ERO 5698.SDR ASAA0610301Stringer · corrodedSTRINGER 18L CORRODED. REPAIRED PER SRM 53-10-03.SDR ASAA0610300Floorbeam · corrodedFLOORBEAM CAP CORRODED. REPAIRED FLOORBEAM CAP PER EA 5310 032374.SDR ASAA0610299Shear Tie · damagedSHEAR TIE HAS LOW EDGE MARGIN AT FASTENER HOLES. REPAIRED FRAME IAW EA 5330 020595.SDR ASAA0610297Stringer · corrodedSTRINGER CORRODED. REPAIRED STRINGER PER EA 5310 02574.SDR ASAA0610296Stringer · crackedSTRINGER CRACKED AT FASTENER HOLE. REPAIRED STRINGER IAW ERO 5373 AND EA 5310 02599.SDR ASAA0610295Stringer Clip · crackedTIE CLIP CRACKED. REPLACED TIE CLIP AND STRINGER 18R PER SRM 51-30-02.SDR ASAA0610294Frame · corrodedFRAME CORRODED. REPAIRED FRAME PER SRM 53-10-4 FIG 6.SDR ASAA0610293Frame · corrodedAFT CARGO PIT FRAME SPLICE CORRODED. REPLACED FRAME SPLICE PER SRM 53-10-1 FIG 1.SDR ASAA0610292Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED FLOORBEAM PER SRM 51-30-12 AND EA 5310 02601.SDR ASAA0610291Stringer · crackedFOUND STRINGER CRACKED. REPLACED STRINGER PER SRM 51 30 02 AND ERO 5735 AND EA 5360 01056.SDR ASAA0610290Floorbeam · corrodedFOUND FLOORBEAM CAP CORRODED. REPAIRED AFT CABIN FLOOR BEAM CAP IAW EA 5310 02232.SDR ASAA0610288Web · crackedFOUND WEB CRACKED BETWEEN STR 11C AND 12C AT FRAME ATTACH POINT REPAIRED WEB PER SRM 51 20 1 FIG 3 AND 51 30 2 FIG 3 AND 11.SDR ASAA0610287Stringer · crackedFOUND STRINGER 8R CRACKED. FABRICATED AND REPLACED CRACKED STRINGER PER SRM 51 30 05 AND EA 5310 02583.SDR ASAA0610303Floor Support · corrodedFOUND FLOOR SUPPORT CORRODED. REPAIRED FLOOR SUPPORT IAW SRM 51 30 5 51 30 2 AND AMM 20 50 11.SDR ASAA0610269Stringer · crackedSTRINGER CRACKED. REPAIRED PER SRM 53-10-3 FIG 1.SDR ASAA0610267Floorbeam · corrodedAFT CARGO PIT FLOORBEAM UPPER CHORD CORRODED. REPAIRED PER WORKCARD 4930579 ERO 5404 AND EA 5330 02503.SDR ASAA0610268Stringer · gougedAFT CARGO PIT STRINGER GOUGED. REPAIRED PER SRM 51-20-1 FIG 3, 7, 8, 9 AND 51-30-2.SDR ASAA0610266Stringer Clip · gougedAFT CARGO PIT TIE CLIP GOUGED. REPLACED PER SRM 51-30-2 AND 51-30-05.SDR ASAA0610264Reveal · crackedLWR FWD CORNER R2 DOOR REVEAL FASTENER HOLES CRACKED. REPLACED PER SRM 51-30-2 FIG 3.SDR ASAA0610262Shear Tie · misdrilledTIE CLIP HAS DOUBLE DRILLED HOLES. REPLACED TIE CLIP WITH FABRICATED REPAIR PARTS IAW SRM 51-10-1.SDR ASAA0610261Stringer Clip · corrodedCORRODED TIE CLIP. REPLACED TIE CLIP PER SRM 51-30-2.SDR ASAA0610263Stop Fitting · crackedR2 DOOR FITTING LOWER STOP FASTENER HOLES CRACKED. REPLACED FITTING PER SRM 51-30-2 FIG 11 & 13.SDR ASAA0610253Skin · dentedDENT IN THE VERTICAL STAB RIGHT SIDE 12 INCHES AFT OF UPPER DORSAL FIN. REPAIRED PER ASA EA 5530 01139 AND CASCADE AREOSPACE ERO 5492.SDR ASAA0610252Shear Tie · corrodedSHEAR TIE CORRODED. REPLACED WITH FABRICATED REPAIR PARTS PER SRM 53-10-4 AND 51-40-04.SDR ASAA0610248Rib · crackedLEFT HORZ STAB AFT STUB RIB ATTACH ANGLE DAMAGED CRACKED. REPLACED ATTACH ANGLE LEFT HORZ STAB INBOARD END AFT STAB RIB. ATTACH ANGLE REPLACED IAW SRM 51-30-2.SDR ASAA0610251Floorbeam · corrodedFLOORBEAM DOUBLER WEB CORRODED. REPLACED WITH FABRICATED REPAIR PART PER SRM 51-30-02 AND 51-30-5 FIG 3.SDR ASAA0610250Floorbeam · corrodedFLOORBEAM CORRODED. REPAIRED PER SRM 51-30-2.SDR ASAA0610249Floorbeam · corrodedCABIN FLOORBEAM CORRODED AT LOWER FLANGE. REPLACED WITH FABRICATED PARTS PER SRM 51-10-1 AND 51-30-02.SDR ASAA0610246Shear Tie · corrodedSHEAR TIE CORRODED. REPLACED WITH FABRICATED REPAIR PART PER SRM 51-30-02.SDR ASAA0610245Splice · corrodedFWD CARGO PIT STR 26R, STRINGER TERMINAL SPLICE CORRODED. REPLACED PER SRM 51-30-5 FIG 3 AND 53-10-01 FIG 1.SDR ASAA0610247Frame · corrodedFRAME CORRODED ON FRAME UNDER STRINGER LOWER LOBE FUSELAGE. FRAME UNDER STRINGER REPAIRED.SDR ASAA0610244Attach Angle · corrodedVERT STAB LEFT T/E AT RUDDER STA 174 PANEL ATTACH ANGLE HAS CORROSION. REPLACED PER SRM 55-30-1.SDR ASAA0610242Frame · corrodedCORRODED FRAME TO SKIN ATTACH ANGLE. REPAIRED FRAME PER SRM 53-10-4.SDR ASAA0610239Floorbeam · corrodedCORROSION ON FWD FLANGE OF FLOORBEAM. FLOORBEAM FWD WEB AND FLANGE REPAIRED PER EA 5310 02578.SDR ASAA0610238Strap · corrodedCORROSION ON FRAME REINFORCEMENT STRAP. REMOVED AND REPLACED PER SRM 51-20-05.SDR ASAA0610243Stringer Clip · corrodedTIE CLIP CORRODED. INSTALLED FABRICATED REPAIR PART PART SRM 51-30-02.SDR ASAA0610241Floorbeam · corrodedCABIN FLOOR SUPPORT BEAM CORRODED AT LWR FLANGE. REPLACED PER SRM 51-10-1 AND 51-30-2.SDR ASAA0610240Floor Skin · corrodedFLOOR DECK CORRODED. REPLACED FLOOR SKIN PER SRM 51-20-1, 51-30-2 FIG 3 AND 11.SDR ASAA0610215Skin · gougedFOUND SKIN GOUGED, REPAIRED PER SRM AND EA 5330 02051.SDR ASAA0610211Skin · chafedFOUND LT WING UPPER SKIN AT WBL 76.75 FM AFT EDGE OF SKIN FWD FOR 9.5" SKIN CHAFED. REPAIRED PER ERO 5279 AND EA 5720 01297.SDR ASAA0610214Skin · chafedFOUND LT WING UPPER SKIN CHAFED. REPAIRED PER ERO 5279 AND EA 5720 01297.SDR ASAA0610213Floorbeam · crackedFOUND FLOORBEAM AT BS 328 RBL 18 WEB CRACKED. REPAIRED FLOORBEAM WEB IAW SRM 51 40 02 FIG 1.SDR ASAA0610212Attach Bracket · crackedFOUND CRACKED NLG FWD SUPPORT FITTING TO WHEEL PRESSURE DECK ATTACH BRACKET. REPLACED ATTACH BRACKET PER SRM 51-20-1 AND 51-30-2.SDR ASAA0610210Bulkhead · corrodedNWW COMPARTMENT AFT PRESSURE BULKHEAD LT ACCESS HOLE AT BSTA 267 LWR CORNER BEAM HAS CORROSION. REPLACED PWR SRM 51 30 02.SDR ASAA0610180Skin · crackedFUSELAGE SKIN CRACKED AT BSTA 533 535 ABOVE STR 15R. SKIN CRACK REPAIRED PER EA 5330 02037.SDR ASAA0610174Stringer · corrodedSTRINGER CORRODED. REPAIRED PER ASA EA 5330 02046.SDR ASAA0610179Door Frame · crackedMAIN CARGO DOOR FRAME TO SKIN WEB AT BSTA 400 BETWEEN STR 11L AND STR 13 L CRACKED 13 PLACES. REPAIRED PER SRM 53 10 4 FIG 10.SDR ASAA0610178Stringer · corrodedSTR 26L AT BSTA 460 TO 480 CORRODED. REPAIRED PER SRM 53 10 3 FIG 1.SDR ASAA0610177Frame · dentedFRAME AT BSTA 500B BETWEEN STR 20R TO 21R DENTED. FRAME REPAIRED BY MADE REPAIR PART PER SRM 51 40 03.
Back to N742AS