N760AS
Service difficulty reports not matched to an aircraft · 283
They name N760AS, 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 = 'N760AS' 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 = 'N760AS' 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 ASAA0843900Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843898Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843897Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER EA 400 53EA 00267.SDR ASAA0843896Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843885Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLERS PER EA 400 53EA 00267.SDR ASAA0843884Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION. INSTALLED REPAIR ANGLES AND FILLER PER ASA EA 400 53EA 00267.SDR ASAA0843883Frame · crackedFRAME CRACKED. REMOVED DAMAGED SECTION INSTALLED REPAIR ANGLES AND FILLERS PER ASA EA 400 53EA 00267.SDR ASAA0843878Beam · crackedMAIN CABIN STUB BEAM CRACKED RT STA 601 RBL 65. TRIMMED OUT CRACKED AREA, FABRICATED AND INSTALLED REPAIR FILLER AND STIFFENING ANGLE IAW ASA EA 400 53EA 00269.SDR ASAA0843832Floorbeam · corrodedFLOORBEAM CORRODED STA 344. REMOVED CORRODED SECTION OF UPPER CHORD. FABRICATED AND INSTALLED REPLACEMENT CHORD REPAIR ANGLES CHORD AND STRAPS IAW ASA EA 40053EA 0227.SDR ASAA0843813Stringer Clip · corrodedSTRINGER CLIP CORRODED. REMOVED CORRODED STRINGER CLIP FABRICATED AND INSTALLED REPLACEMENT CLIP IAW B737 400 SRM 51 30 01 AND 51 40 02.SDR ASAA0843799Strap · gougedINTERCOSTAL TIE STRAP STA 295 IS GOUGED REMOVED GOUGED STRAP INSTALLED NEW STRAP IAW B737 400 SRM 51 40 02 ASA EA 400 53EA 00199.SDR ASAA0843798Intercostal · crackedINTERCOSTAL STA 295 STR 4L IS CRACKED REMOVED CRACKED INTERCOSTAL INSTALLED NEW INTERCOSTAL IAW B737 400 SRM 51 40 02.SDR ASAA0843797Sill · corrodedL1 DOOR CUTOUT SILL BEAM CHORD IS CORRODED. REMOVED CORRODED CHORD REPLACED SILL BEAM CHORD IAW B737 400 SRM 51 40 02 B DRAWING 65 17688 AND ASA EA 400 53EA 00208.SDR ASAA0843786Skin · chafedNUMBER 4 SLAT TE WEDGE LOWER SKIN IS CHAFED. REMOVED DAMAGED SECTION AND INSTALLED REPAIR FILLER AND DOUBLERS PER SRM.SDR ASAA0843778Floorbeam · corrodedFLOORBEAM CORRODED. REPLACED FLOORBEAM PER SRM 53 10 51.SDR ASAA0843749Skin · dentedNR 5 SLAT UPPER SURFACE HAS DENT. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843728Strap · corrodedFLOOR STRAP CORRODED STA 1016 LBL 2. REMOVED CORRODED STRAP, INSTALLED REPLACEMENT STRAP IAW B737 400 SRM 51 40 02.SDR ASAA0843727Structure · corrodedINNER CHORD AT R2 DOOR WAY IS CORRODED. REMOVED CORRODED INNER CHORD FABRICATED AND INSTALLED INNER CHORD IAW SRM 51 40 02.SDR ASAA0843726Shear Web · corrodedSHEAR WEB CORRODED AT STA 370 LT SIDE. REMOVED CORRODED AREA OF WEB, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 13.SDR ASAA0843724Shear Web · corrodedSHEAR WEB CORRODED LT STA 400. REMOVED CORRODED AREA OF WEB, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 13.SDR ASAA0843720Sill · corrodedR1 DOOR CUTOUT INNER CHORD MOP SILL IS CORRODED. REMOVED CORRODED MOP SILL AND INSTALLED NEW MOP SILL IAW B737 400 SRM 51 40 02.SDR ASAA0843718Stringer Clip · crackedCABIN FRAME STA 706 STRINGER CLIP CRACKED AT STA 10R. REMOVED DAMAGED CLIP, LOCATED DRILLED NEW CLIP AND INSTALLED IAW B737 400 SRM 51 40 03.SDR ASAA0843699Stringer Clip · crackedCABIN STRINGER CLIP CRACKED AT STA 500B STR 16R. REMOVED DAMAGED CLIP, LOCATED DRILLED AND INSTALLED REPLACEMENT STRINGER CLIP IAW B737 400 SRM 51 40 02 PG 2 AND 4 AND 51 40 05.SDR ASAA0843698Stringer Clip · crackedCABIN STRINGER CLIP CRACKED AT STA 380 STR 8. REMOVED DAMAGED CLIP, LOCATED DRILLED AND INSTALLED REPLACEMENT STRINGER CLIP IAW B737 400 SRM 51 40 02 PG 2 AND 4.SDR ASAA0843697Stringer Clip · crackedCABIN STRINGER CLIP CRACKED STA 907 STR 8R. REMOVED DAMAGED CLIP, LOCATED DRILLED AND INSTALLED REPLACEMENT STRINGER CLIP IAW B737 400 SRM 51 40 02 PG 2 AND 4.SDR ASAA0843830Skin · dentedRT INBD AFT FLAP UPPER SURFACE HAS DENT. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW SRM 51 70 10 REPAIR 4.SDR ASAA0843825Strap · corrodedAFT CARGO PIT DOOR OPENING SILL PLATE TAPERED STRAP CORRODED STA 775 TO STA 855 RBL 24. REMOVED DAMAGED STRAP LOCATED DRILLED INSTALLED A REPLACEMENT STRAP IAW B737 400 SRM 51 40 02.SDR ASAA0843824Web · corrodedAFT CARGO PIT DOOR SILL WEB CORRODED AROUND NUT PLATES ON LOWER SIDE STA 800 TO 847 RBL 20 TO RBL 28. REMOVED DAMAGED SILL WEB LOCATED DRILLED INSTALLED REPLACEMENT SILL WEB IAW SRM 51-40-02 PG 3SDR ASAA0843822Intercostal · corrodedAFT CARGO PIT CORRODED INTERCOSTAL STA 767 TO STA 787 RBL 24. REMOVED DAMAGED INTERCOSTAL LOCATED DRILLED INSTALLED REPLACEMENT INTERCOSTAL IAW B737 400 SRM 51 40 02 AND 51 40 05.SDR ASAA0843748Cargo Track · damagedCARGO TRACK TIE DOWN HAS DAMAGED LUGS STA 787. REMOVED DAMAGED SECTION OF TRACK, FABRICATED AND INSTALLED REPLACEMENT TRACK PLATES ANGLES IAW B737 400 SRM 53 00 50 REPAIR 2 FIG 201.SDR ASAA0843828Skin · dentedRT INBD FOREFLAP UPPER SURFACE DENTED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843827Skin · chafedRT INBD FOREFLAP UPPER SURFACE CHAFED ON INBD END. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843826Skin · dentedRT INBD FOREFLAP UPPER SURFACE DENTED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843823Web · corrodedFWD CARGO PIT DOOR THRESHOLD WEB CORRODED STA 452 TO STA 489 RBL 26 TO RBL 29. REMOVED DAMAGED THRESHOLD WEB LOCATED DRILLED INSTALLED REPLACEMENT WEB IAW B737 400 SRM 51 40 02 FIG 9 PG 31 33.SDR ASAA0843790Skin · dentedNUMBER 9 SPOILER UPPER SURFACE DENTED. INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843788Skin · dentedRIGHT INBOARD AFT FLAP LE IS DENTED. REMOVED DAMAGED SECTION AND INSTALLED REPAIR DOUBLER AND SPLICE PLATE PER SRM 57-53-01.SDR ASAA0843781Skin · dentedNUMBER 5 SPOILER UPPER SURFACE IS DENTED. INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843750Skin · dentedNR 7 SPOILER UPPER SURFACE DENTED. REMOVED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843834Skin · dentedNR 5 SPOILER LOWER SURFACE DENTED. REMOVED DAMAGED AREA FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 4.SDR ASAA0843812Skin · dentedNR 8 SPOILER LOWER SURFACE DENTED. PREPPED DENTED AREA FABRICATED AND INSTALLED REPAIR AND DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843769Skin · dentedNUMBER 7 SPOILER LOWER SURFACE DENTED. REMOVED DAMAGED SECTION. INSTALLED REPAIR FILLER AND DOUBLER PER SRM 51 70 10.SDR ASAA0843721Skin · puncturedNR 4 SPOILER LOWER SURFACE DENTED AND PUNCTURED AT WBL 114. PREPPED DAMAGED AREA, FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 10.SDR ASAA0843796Skin · dentedLT OTBD AFT FLAP DENTED ON LOWER SURFACE. PREPPED AREA FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843794Skin · dentedLT OTBD AFT FLAP LOWER SURFACE IS DENTED PREPPED AREA FABRICATED AND INSTALLED REPAIR DOUBLER IAW B737 400 SRM 51 70 10 REPAIR 2.SDR ASAA0843785Skin · dentedLEFT INBOARD MID FLAP TE WEDGE UPPER SURFACE IS DENTED. REMOVED DAMAGED SECTION AND INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843784Skin · dentedRIGHT OUTBOARD AFT FLAP LOWER SURFACE DENTED. REMOVED DAMAGED SECTION AND INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843783Skin · puncturedRIGHT INBOARD FOREFLAP DENTED AND PUNCTURED. REMOVED DAMAGED SECTION AND INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843774Skin · dentedNUMBER 2 SPOILER LOWER SURFACE IS DENTED. INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843771Skin · dentedNUMBER 1 SPOILER LOWER SURFACE DENTED. INSTALLED REPAIR DOUBLER PER SRM 51 70 10.SDR ASAA0843770Skin · dentedNUMBER 1 SPOILER LOWER SURFACE DENTED. INSTALLED REPAIR DOUBLER PER SRM 51 70 10.
Back to N760AS