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 ASAA0610176Attach Angle · corrodedFRAME TO SKIN ATTACH ANGLE CORRODED. REPAIRED ATTACH ANGLE PER SRM 53 10 1 FIG 1.SDR ASAA0610175Attach Angle · corrodedFRAME TO SKIN ATTACH ANGLE CORRODED. REPAIRED BY MADE UP REPAIR PART PER SRM 53 10 1.SDR ASAA0610173Rivet · corrodedCORROSION ON RIVETS. REPAIRED PER SRM 53 10 3 FIG 1.SDR ASAA0610172Door Frame · crackedMAIN CARGO DOOR FRAME TO SKIN WEB CRACKED. REPAIRED PER SRM 53 10 4 FIG 10.SDR ASAA0610171Door Frame · crackedMAIN CARGO DOOR INTERIOR FRAME TO SKIN WEB CRACKED. REPAIRED PER SRM 53 10 1 FIG 10.SDR ASAA0610162Skin · crackedFUSELAGE SKIN CRACKED AT BS 533-535 ABOVE STRINGER 15R. REPAIRED PER EA5330 02037.SDR ASAA0610161Frame · dentedFRAME DENTED. FABBED REPAIR PART PER SRM 51-40-03.SDR ASAA0610160Attach Angle · corrodedFRAME TO SKIN ATTACH ANGLE CORRODED. REPAIRED ATTACH ANGLE PER SRM 53-10-1 FIG 1.SDR ASAA0610159Attach Angle · corrodedFRAME TO SKIN ATTACH ANGLE CORRODED. FABBED REPAIR PART PER SRM 52-10-1.SDR ASAA0610133Frame · crackedFRAME ATTACH AT BS 294.5 STR 12C CRACKED WEB. WEB AT BS 294.5 STR 12L FABRICATED IAW SRM 57 20 1 FIG 3 7 8 9.SDR ASAA0610007Stringer Clip · corrodedYXX - FOUND STRINGER 24L AT BS 907 CORRODED TIE CLIP. REMOVED AND REPLACED TIE CLIP PER B737-200 SRM 51-30-02 FIG 8. (M)SDR ASAA0610008Stringer Clip · crackedYXX - FOUND TIE CLIP AT BS 400, STRINGER 3 RT IS CRACKED. REMOVED AND REPLACED TIE CLIP PER B737-200 SRM 53-10-05 FIG 3. (M)SDR ASAA0610005Stringer Clip · crackedYXX - FOUND PASSENGER CABIN INTERIOR, AT BS 420, STRINGER 1 RIGHT, TIE CLIP CRACKED. REPAIRED WITH FABRICATED REPAIR PART FROM CASCADE, P/N 0000A51503-9, AND B737-200 SRM 51-30-02. (M)SDR ASAA0510173Keelbeam · corrodedYXX - FOUND CORROSION ON RIGHT KEEL BEAM AT BS 636. RIGHT KEEL BEAM REPLACED IAW B737-200 SRM. (M)SDR ASAA0510172Keelbeam · corrodedYXX - FOUND CORROSION ON RIGHT KEEL BEAM AT BS 636. LEFT KEEL BEAM REPLACED IAW B737-200 SRM. (M)SDR ASAA0510171Skin · chafedYXX - FUSELAGE SKIN LEFT BS 262 3.5 INCHES ABOVE NLG DOOR CUTOUT CHAFED. SKIN CHAFED REPAIRED IAW B737-200 SRM. (M)SDR ASAA0510170Rib · wornYXX - FOUND LEFT WING RIB BETWEEN AILERON AND FORE FLAP T/E ANGLE SUPPORT CHANNEL HAS WEAR DAMAGE. REMOVED AND REPLACED SUPPORT ANGLE IAW B737-200 SRM. (M)SDR ASAA0510169Stringer Clip · corrodedYXX - FOUND AFT CARGO PIT TIE CLIP HAS CORROSION AT BS 747 AND STRINGER 26R. REMOVED AND REPLACED TIE CLIP AT AFT CARGO BS 747 AND 26R IAW B737-200 SRM. (M)SDR ASAA0510168Skin · corrodedYXX - FOUND FUSELAGE SKIN BULGING AT BS 535 STRINGER 28 LEFT KEEL BEAM. REMOVED AND REPLACED KEEL BEAM AND REPAIRED SKIN IAW B737-200 SRM. (M)SDR ASAA0510167Stringer Clip · crackedYXX - FOUND AFT CARGO TIE CLIP CRACKED AT BS 787 STRINGER 24R. REMOVED AND REPLACED TIE CLIP IAW B737-200 SRM. (M)SDR ASAA0510166Keelbeam · damagedYXX - FOUND BS 535 BETWEEN LEFT AND RIGHT KEEL BEAMS SUPPORT ANGLES HAS LOW EDGE MARGIN AT FASTENER HOLE. REMOVED AND REPLACED ANGLE IAW B737-200 SRM. (M)SDR ASAA0510165Angle · damagedYXX - FOUND U-CHANNEL AT AFT CARGO PIT DOOR SILL HAS ELONGATED HOLES FROM PREVIOUS REPAIR. REMOVED AND REPLACED U-CHANNEL IAW B737-200 SRM. (M)SDR ASAA0510164Stringer · crackedYXX - FOUND CRACKED STRINGER AT BS 836 STRINGER 26R. REMOVED AND REPLACED STRINGER 26R IAW B737-200 SRM. (M)SDR ASAA0510163Wedge · dentedYXX - FOUND RIGHT NR 6 SLAT T/E WEDGE UPPER SURFACE HAS A DENT AT SLAT STATION 346.53 AND 4.5 INCH FROM T/E. PERMANENT REPAIR COMPLETED IAW B737-200 SRM 51-40-20 REPAIR 7 FIG 16. (M)SDR ASAA0510162Wedge · dentedYXX - FOUND RIGHT NR 6 SLAT T/E WEDGE UPPER SURFACE HAS A DENT AT SLAT STATION 359.03 AND 1.5 INCHES FROM T/E. PERMANENT REPAIR COMPLETED IAW B737-200 SRM 51-40-20 REPAIR 11 FIG 20. (M)SDR ASAA0510161Skin · delaminatedYXX - FOUND RIGHT NR 6 SLAT FS 540, UPPER EDGE HAS DAMAGE. PERMANENT REPAIR COMPLETED IAW B737-200 SRM 51-40-20 REPAIR 14 FIG 23. (M)SDR ASAA0510185Stringer · corrodedOB SIDE OF STR 26L AT B-STA 986 CORRODED. REMOVED AND REPLACED STRINGER 26L IAW SRM. (K)SDR ASA0510184Door Frame · crackedDOOR FRAME ON FUSELAGE IS CRACKED (AFT END FWD FRAME. REPLACED IAW SRM. (K)SDR ASAA0510183Skin · corrodedFUSELAGE SKIN BULGE AT B-STRA 535, STR 28, LT. REPAIRED IAW SRM. (K)SDR ASAA0510182Web · dentedDENT ON WEB ON LT WING RSS 497 APPROX 10 INCHES AFT OF REAR SPAR. REPAIRED IAW SRM. (K)SDR ASAA0510181Bracket · corrodedA BRACKET AT B-STA 847, STRINGER 18R FOUND CORROED. BRACKET REPLACED WITH THE REPAIR PART AT BSTA 847 STRINGER 18R IAW SRM. (K)SDR ASAA0510180Splice · corrodedFRAME SPLICE AT BSTA 847, STRINGER 27R FOUND CORRODED. FRAME SPLICE AT BSTA 847, STRINGER 27R REPLACED WITH MADE REPAIR PART IAW SRM. (K)SDR ASAA0510179Shear Tie · corrodedAFT CARGO PIT B-STA 807 IB OF STRINGER 27L FRAME TO SKIN SHEAR TIE AFT FACE CORROSION FOUND AS MARKED. REMOVED AND REPLACED SHEAR TIE IAW SRM. (K)SDR ASAA0510178Skin · corrodedFUSELAGE SKIN BULGING AT BS 535, STR 28 LT KEELBEAM. KEELBEAM REPLACED AND SKIN REPAIRED. (K)SDR ASAA0510177Splice · corrodedCORROSION ON STRINGER 26L END SPLICE AT BS 540. REMOVED AND REPLACED END SPLICE IAW SRM. (K)SDR ASAA0510176Stiffener · corrodedCORROSION FOUND ON VERTICAL STIFFENER LOCATED AT BS 328, RBL 14, WL 150, IN E AND E BAY. REMOVED AND REPLACED VERTICAL STIFFENER IAW SRM. (K)SDR ASAA0510175Stringer Clip · corrodedAFT CARGO B-STA 747, STR 21L TIE CLIP CORRODED. REMOVED AND REPLACED TIE CLIP IAW SRM. (K)SDR ASAA0510174Stringer Clip · corrodedAFT CRGO B-STA 747, STR 22L TIE CLIP CORRODED. REMOVED AND REPLACED TIE CLIP IAW SRM. (K)SDR ASAA0510160Skin · delaminatedYXX - FOUND RIGHT NR 6 SLAT FOUND WITH DELAMINATION ON UPPER SURFACE MID-SPAN AT SLAT STATION 327, 359.03, 346.53 AND FS 540. PERMANENTLY REPAIRED IAW B737-200 SRM. (M)SDR ASAA0510159Skin · damagedYXX - IMPACT DAMAGE ON OUTBOARD T/E O RIGHT INBOARD MID FLAP. RIGHT INBOARD MID FLAP IMPACT DAMAGE LOCATION REPAIRED IAW B737-200 SRM 51-40-20 REPAIR NR 2. (M)SDR ASAA0510158Skin · delaminatedYXX - NR 3 SLAT DELAMINATED AT OUTBOARD END LOWER SURFACE SLAT STATION 124.27. PERMANENT REPAIR COMPLETED. (M)SDR ASAA0510156Shear Tie · corrodedYXX - AFT CARGO PIT SHEAR TIE HAS CORROSION OUTBOARD OF RIGHT KEELBEAM, STRINGER 27R BS 767. REMOVED AND REPLACED SHEAR TIE IAW B737-200 SRM. (M)SDR ASAA0510153Floor Support · damagedYXX - FOUND FLOOR SUPPORT FORMER AT BS 813 RBL 21 ELONGATED HOLES. REMOVED AND REPLACED FORMER IAW B737-200 SRM. (M)SDR ASAA0510152Floor Support · damagedYXX - FOUND FLOOR SUPPORT FORMER AT BS 810 810 RBL 21 ELONGATED HOLES. REMOVED AND REPLACED FORMER IAW B737-200 SRM. (M)SDR ASAA0510151Floor Support · damagedYXX - FOUND FLOOR SUPPORT FORMER AT BS 801 RBL 21 ELONGATED HOLES. REMOVED AND REPLACED FORMER IAW B737-200SRM. (M)SDR ASAA0510150Floor Support · damagedYXX - FOUND FLOOR SUPPORT FORMER AT BS 793 RBL 21 ELONGATED HOLES. REMOVED AND REPLACED FORMER IAW B737-200SRM. (M)SDR ASAA0510149Floor Support · damagedYXX - FOUND FLOOR SUPPORT FORMER AT BS 790 RBL 21 ELONGATED HOLES. REMOVED AND REPLACED FORMER IAW B737-200 SRM. (M)SDR ASAA0510148Attach Angle · crackedYXX - FOUND INTERCOSTAL ATTACH ANGLE AT BS 791 CRACKED BETWEEN STRINGER 25-26 RT. ATTACH ANGLE REPLACED FROM BS 767-867. (M)SDR ASAA0510147Skin · dentedYXX - FOUND RIGHT INBOARD FLORE FLAP DENTED AND DELAMINATED AT OLD REPAIR AT BL 118. RIGHT INBOARD FORE FLAP AT WBL 118 DENTED AND DELAMINATED LOCATIONS REPAIRED IAW 737-200SRM. (M)SDR ASAA0510146Shear Tie · crackedYXX- SHEAR TIE CRACKED AT BS 787 STRINGER 26R AT HOLE. REPLACED SHEAR TIE IAW B737-200 SRM. (M)
Back to N742AS