N794AS
Service difficulty reports not matched to an aircraft · 126
They name N794AS, 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 = 'N794AS' 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 = 'N794AS' 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 ASAA1047748Web · corrodedAFT PIT ENTRY WEB IS CORRODED. REMOVED AND REPLACED WEB.SDR ASAA1047721Shear Tie · corrodedSHEAR TIE AFT SIDE CORRODED ON FWD SIDE OF FRAME AT STA 747 BETWEEN STR 26R 27R. REMOVED, FABRICATED AND INSTALLED NEW SHEAR TIE.SDR ASAA1047689Intercostal · corrodedAFT CARGO PIT INTERCOSTAL CORRODED STA 847. REMOVED DAMAGED INTERCOSTAL AND INSTALLED REPLACEMENT.SDR ASAA1047703Stringer · corrodedAFT PIT STRINGER 27L SPLICE DOUBLER BETWEEN FRAMES 867 847 CORRODED UPPER SURFACE. REMOVED CORRODED SPLICE DOUBLER AND INSTALLED NEW SPLICE.SDR ASAA1047724Web · corrodedAFT WET AREA LT WEB STATION 1006 TO 1016 IS CORRODED. REMOVED, FABRICATED AND INSTALLED NEW WEB.SDR ASAA1047723Shear Web · corrodedAFT WET AREA SHEAR WEB AREA 986 TO 1016 LT SIDE IS CORRODED. REMOVED, FABRICATED AND INSTALLED NEW WEB.SDR ASAA1047762Frame · crackedFRAME AT STA 827 CRACKED BETWEEN STR 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047761Frame · crackedFRAME AT STA 787 CRACKED BETWEEN STR 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047760Frame · crackedFRAME AT STA 380 CRACKED BETWEEN STR 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047759Frame · crackedFWD CABIN STA 440 ABOVE STR 9L FRAME CRACKED. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047758Frame · crackedFRAME CRACKED BETWEEN STRINGERS 8 & 9. CUT OUT DAMAGE, FABRICATED DOUBLERS AND INSTALLED.SDR ASAA1047757Skin · crackedAC GROUND CONNECTION DOOR LANDING CRACKED ALONG THE RIGHT EDGE OF THE CUTOUT. CUT OUT DAMAGED AREA, FABRICATED FILLER AND DOUBLER AND INSTALLED.SDR ASAA1047711Shear Tie · corrodedAFT PIT SHEAR TIE FWD SIDE OF FRAME CORRODED. CUT OUT DAMAGED AREA, FABRICATED AND INSTALLED SHEAR TIE REPAIR.SDR ASAA1047704Sill · corrodedR2 DOOR MOP SILL CORRODED. REMOVED CORRODED MOP SILL, INSTALLED NEW MOP SILL.SDR ASAA1047692Intercostal · crackedINTERCOSTAL TO SKIN ATTACH ANGLE CRACKED AT STA 291. REMOVED DAMAGED INTERCOSTAL AND INSTALLED REPLACEMENT.SDR ASAA1047691Intercostal · crackedINTERCOSTAL TO SKIN ATTACH ANGLE CRACKED AT STA 291. REMOVED DAMAGED INTERCOSTAL AND INSTALLED REPLACEMENT.SDR ASAA1047690Attach Angle · crackedINTERCOSTAL TO SKIN ATTACH ANGLE CRACKED AT STA 291. REMOVED DAMAGED INTERCOSTAL AND INSTALLED REPLACEMENT.SDR ASAA1047688Threshold · corrodedAFT GALLEY DOOR CUTOUT THRESHOLD WEB CORRODED. REMOVED DAMAGED WEB, FABRICATED AND INSTALLED NEW WEB.SDR ASAA1047685Floorbeam · corrodedAFT CABIN FLOORBEAM AT STA 947 LBL 6 IS CORRODED. REPAIRED FLOORBEAM.SDR ASAA1047684Stringer Clip · corrodedSTRINGER CLIP CORRODED BS 907 STR 8R. INSTALLED NEW CLIP.SDR ASAA1047747Shear Tie · corrodedAFT PIT SHEAR TIE IS CORRODED BETWEEN STR 26R AND 27R BOTH SIDES OF THE SHEAR TIE. REPAIRED SHEAR TIE.SDR ASAA1047720Structure · crackedLEFT WING LOWER CHORD IS CRACKED BETWEEN STRINGER 2 & 3 WBL 135.5. CUT OUT DAMAGED SECTION AND INSTALLED REPAIR TEE.SDR ASAA1047746Shear Tie · corrodedAFT PIT SHEAR TIE AT STA 727F IS CORRODED BETWEEN STR 26R AND 27R BOTH SIDES OF THE SHEAR TIE. REPAIRED SHEAR TIE.SDR ASAA1047686Frame · corrodedAFT PIT FRAME IS CORRODED ON UNDERSIDE OF UPPER FLANGE AT HI-LOK Z-ANGLE ATTACH POINT. CUT OUT DAMAGED AREA OF FRAME, FABRICATED REPAIR ANGLE AND 2 EACH FILLERS AND INSTALLED.SDR ASAA1047687Shear Tie · corrodedFWD CARGO PIT FRAME STA 500B CORRODED BETWEEN 28L AND 28R. CUT OUT DAMAGED SHEAR TIE ON FRAME, FABRICATED AND INSTALLED REPLACEMENT SHEAR TIE.SDR ASAA1047756Skin · chafedNR 4 SLAT I/B END LWR SURFACE CHAFED AT PREVIOUS REPAIR. REMOVED PREVIOUS REPAIR BONDED NEW REPAIR.SDR ASAA0844091Skin · dentedRT IB AFT FLAP IS DENTED ON UPPER SURFACE 1" AFT OF FWD SPAR AND 7" IB OF OB END. REPAIRED DENT DAMAGE ON UPPER SURFACE OF RT IB AFT FLAP 1" AFT OF FWD SPAR AND 7" IB OF OB END IAW SRM 51 70 10 REPAIR 4 PG 201.SDR ASAA0844090Skin · dentedRT IB AFT FLAP IS DENTED ON UPPER SURFACE 1.5" AFT OF FWD SPAR AND 51" IB OF OB END. REPAIRED DENT DAMAGE ON UPPER SURFACE OF RT IB AFT FLAP 1.5" AFT OF FWD SPAR AND 51" IB OF OB END IAW SRM 51 70 10 REPAIR 4 PG 201.SDR ASAA0844116Skin · gougedRT OB MID FLAP LOWER SURFACE SKIN GOUGED. REMOVED DAMAGE FABBED FILLERS AND DOUBLERS INSTALLED REPAIR IAW EA 13093 AND SRM 57 53 01 FIG 201.SDR ASAA0844105Skin · gougedRT OTBD MID FLAP LOWER SURFACE GOUGED. REMOVED DAMAGED AREA FABRICATED FILLERS AND DOUBLER INSTALLED REPAIR IAW SRM 57-53-01 FIG 201 EA 13093.SDR ASAA0844092Flap Track · crackedNR 1 FLAP TRACK CRACKED ON IB UPPER FLANGE. REMOVED CRACKED FLAP TRACK INSTALLED REPLACEMENT TRACK IAW B737 400 MM 27 51 49.SDR ASAA0844045Skin · crackedLT WING NR 1 SLAT CRACK ON LOWER TE AT RIVET 19" FROM OB OF ACTUATOR MARKED. REPAIRED LT WING NR 1 SLAT IAW B737 400 SRM 57 43 01 FIG 201.SDR ASAA0844081Fitting · gougedRT AILERON O/B CORNER FWD EDGE FITTING IS GOUGED. REMOVED GOUGED FITTING INSTALLED REPLACEMENT FITTING IAW B737 SRM 51 40 02.SDR ASAA0640949Stringer Clip · crackedTIE CLIP CRACKED. CRACKED TIE CLIP REPLACED WITH FABRICATED REPAIR PART IAW SRM 51 04 02.SDR ASAA0640948Skin · damagedLEFT OUTBOARD MIDFLAP UPPER SURFACE CHAFED AT OUTBOARD END. LEFT OUTBOARD MIDFLAP UPPER SURFACE REPAIRED IAW SRM 51 70 10 REPAIR 4.SDR ASAA0640947Skin · chafedLEFT OUTBOARD MIDFLAP L/E CHAFED AT INBOARD END. LEFT OUTBOARD MIDFLAP L/E CHAFED AREAS AT INBOARD END REPAIRED AND MADE SERVICEABLE ON WING AND ADJUSTMENT CHECK CARRIED OUT AND FOUND SERVICEABLE IAW SRM 57 53 01 AND AMM 27 51 34 501.SDR ASAA0640946Skin · chafedLEFT INBOARD MIDFLAP UPPER SURFACE INBOARD EDGE SKIN CHAFED. LT INBOARD MIDFLAP UPPER SKIN CHAFED AREAS REPAIRED ON WING AND MADE SERVICEABLE AND GAP CHECK CARRIED OUT FOUND SERVICEABLE IAW SRM 57 53 01 AND AMM 27 51 04 401.SDR ASAA0540618Floorbeam · corrodedOKC - FOUND FLOORBEAM UPPER CHORD CORRODED AT BS 986.5. REMOVED UPPER CHORD, FABRICATED AND INSTALLED REPAIR PARTS IAW ASA EA 5310-02512. (M)SDR ASAA0540617Stiffener · damagedOKC - FOUND DURING ACCOMPLISHMENT OF EO 5710-01108, 1 FASTENER HOLE COMMON TO LBL 6.15 STIFFENER WAS OVERSIZED BEYOND ALLOWABLE DIAMETER TO REMOVED DAMAGE. REAMED HOLE TO .388/.391 DIAMETER, INSTALLED FASTENER IAW ASA EA 5710-01123. (M)SDR ASAA0540616Frame · damagedOKC - FOUND BS 277 FRAME WEB DAMAGED AT BS 17-18 LEFT DOUBLER REPAIR. REMOVED DAMAGED SECTION OF WEB, FABRICATED AND INSTALLED REPAIR ANGLE IAW ASA EA 5310-02511. (M)SDR ASAA0540615Repair · unknownOKC - FOUND INTERIM EXTERNAL DOUBLER REPAIR PREVIOUSLY INSTALLED AT BS 279, STRINGER 17-18 LEFT. REMOVED INTERIM REPAIR, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW ASA EA 5310-02513. (M)SDR ASAA0540592Skin · chafedOKC - NR 1 SLAT T/E LOWER SURFACE IS CHAFED AND CRACKED AT O/B CORNER. REMOVED DAMAGE, FABRICATED AND INSTALLED REPAIR FILLER AND DOUBLER IAW B737-400 SRM 51-70-10. (M)SDR ASAA0540591Skin · gougedOKC - MULTIPLE SKIN GOUGES BELOW AFT PIT DOOR SCUFF PLATE LOWER FORWARD AREA. SKIN REPAIR PER B737-400 SRM 53-00-01 FIG 201 REPAIR IS CATEGORY "B", HOLES HAVE BEEN ZERO TIMED. (M)SDR ASAA0540572Tab · bentOKC - FOUND RIGHT ELEVATOR TAB BENT AT T/E. PREPPED AREA, BONDED REPAIR PER B737-400 SRM 51-70-05 FIGURE 8. (M)SDR ASAA0540560Crease Beam · corrodedPAE - FOUND FORWARD CABIN CREASE BEAM CORRODED AT INNER CHORD, SEVERAL AREAS AT L1 DOOR. REMOVED AND REPLACED CREASE BEAM INNER CHORD IAW B737-400 SRM 51-40-02 PAGE 2. (M)SDR ASAA0540559Shear Tie · corrodedPAE - AFT CARGO COMPARTMENT CORRODED SHEAR TIE AT BS 787 BETWEEN STRINGER 26 RIGHT AND 27 RIGHT. REMOVED CORRODED SECTION OF SHEAR TIE, FABRICATED AND INSTALLED IAW 737-400 SRM 53-00-07 FIGURE 201. (M)SDR ASAA0540549Skin · delaminatedOKC - NR 5 SLAT INBOARD TRAILING EDGE IS DELAMINATED. REMOVED DAMAGE, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW 737-400 SRM 51-70-10. (M)SDR ASAA0540548Skin · chafedOKC - FOUND NR 1 SLAT LOWER T/E IS CHAFED. REMOVED DAMAGE, FABRICATED AND INSTALLED FILLER AND DOUBLER IAW 737-400 SRM 51-70-10. (M)SDR ASAA0540547Web · corrodedOKC - FOUND WEB AROUND L1 DOOR CUTOUT CORRODED AT BS 344, WL 208.5. REMOVED WEB, FABRICATED AND INSTALLED REPLACEMENT WEB IAW 737-400 SRM 51-30-01 FIGURE 7 AND DWG 6517685. (M)SDR ASAA0540544Skin · damagedOKC - FOUND RIGHT OUTBOARD AFT FLAP IS DAMAGED. REMOVED DAMAGE, FABRICATED AND INSTALLED CORE AND DOUBLER PER B737-200 SRM 51-70-10. (M)
Back to N794AS