N617AS
Service difficulty reports not matched to an aircraft · 83
They name N617AS, 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 = 'N617AS' 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 = 'N617AS' 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 ASAA0772319Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL SPLICE TEE BS 727D+6 CORRODED SPLICE TEE REPLACED.SDR ASAA0772318Channel · corrodedFWD CARGO PIT LT ZEE CHANNEL BS 500D TO 438 LBL 21 REPLACED CORRODED SECTION FROM BS 438 TO 500D WITH MADE REPAIR PART IAW B737 700 SRM 53 00 53 REPAIR E FIG 202.SDR ASAA0772342Housing · crackedUPPER FUSELAGE ANTI COLLISION LIGHT HOUSING SCREW HOLES CRACKED REPLACED UPPER FUSELAGE ANTI COLLISION LIGHT HOUSING WITH REPLACEMENT PART NR 30 2505 3 PO NR 113319 IAW B737 700 SRM 51 40 02.SDR ASAA0772344Floor Support · brokenFLOORBOARD SUPPORT CHANNEL BROKEN AT BS 540 WL 208 RBL 2. REPAIRED WITH REPAIR PART.SDR ASAA0772337Floorbeam · corrodedCABIN FLOORBEAM BS 344 LBL 12 CORRODED REPAIRED WITH REPAIR PART.SDR ASAA0772335Intercostal · crackedFWD CABIN INTERCOSTAL CRACKED BS 328 TO 344 LBL 46, REPAIRED WITH REPAIR PART.SDR ASAA0772334Intercostal · crackedFWD CABIN INTERCOSTAL CRACKED BS 312 TO 328 LBL 46. REPAIRED WITH REPAIR PART.SDR ASAA0772333Intercostal · crackedFWD CABIN INTERCOSTAL CRACKED BS 294 TO 277 BL 0. REPAIRED WITH REPAIR PART.SDR ASAA0772332Intercostal · crackedFWD CABIN INTERCOSTAL CRACKED BS 312 TO 328 RBL 31. REPAIRED WITH REPAIR PART.SDR ASAA0772330Intercostal · corrodedAFT CABIN CORROSION FOUND ON INTERCOSTAL LBL 50 BS 947 TO 967. INTERCOSTAL REPLACED WITH NEW PART.SDR ASAA0772329Channel · corrodedAFT CABIN CORROSION FOUND ON ZEE CHANNEL BS 992 RBL 37, REPAIRED WITH REPAIR PART.SDR ASAA0772328Shear Web · dentedAFT CABIN DENT FOUND ON SHEAR WEB AT RBL 33.5 BS 1016+5. REPLACED WITH MADE REPAIR PART FOR BOEING ENG DWG 147A5712 AND B737 700 SRM 51 40 02.SDR ASAA0772327Shear Web · corrodedAFT CABIN CORROSION FOUND ON SHEAR WEB RBL 33 BS 1016+3. REPLACED WITH MADE REPAIR PART IAW BOEING ENG DWG 147A15712 AND B737 700 SRM 51 40 02.SDR ASAA0772331Floorbeam · corrodedAFT CABIN CORROSION FOUND ON BS 947 FLOORBEAM LBL 53 AROUND CLIP NOT HOLE LOCATION REPAIRED WITH REPAIR PART.SDR ASAA0772338Doubler · corrodedFWD CARGO PIT RADIO ANTENNA DOUBLER FOUND CORRODED AT BS 500 BS 500A BL 0, FWD CARGO RADIO ANTENNA DOUBLER REPLACED WITH REPAIR PART.SDR ASAA0772346Floor Panel · corrodedAFT CARGO PIT FLOOR PANEL FROM STA 767+6 TO 887 CORRODED ALONG PANEL EDGES AND CRACKED AT STA 792. REPLACED WITH MADE REPAIR PART IAW B737 700 SRM 53 60 53 KG1 AND 51 40 05 AND BOEING ENG DWG 453A2610.SDR ASAA0772339Floor Support · corrodedCORROSION FOUND ON TOP AND BOTTOM OF FWD CARGO PIT FLOOR SUPPORT INTERCOSTAL AT BS 500 TO BS 500A RBL 21.00. CORROSION BLENDED OUT AND FOUND TO BE BEYOND ALLOWABLE LIMITS IAW B737 700 SRM 53 00 53. MADE AND INSTALLED REPAIR PART IAW B737 200 SRM 51 40 05 ANDSDR ASAA0772336Angle · corrodedFWD CARGO PIT ZEE ANGLE FOUND CORRODED AT BS 500A TO 500D RBL21 FWD CARGO PIT ZEE ANGLE BS 500D RBL21. REPAIRED IAW B737 700 SRM 53 30 53 AND SRM 53 00 53 REPAIR 5.SDR ASAA0772326Floor Support · corrodedAFT CARGO PIT CORROSION ON FLOOR SUPPORT RAIL BS 767+6 LBL B REPAIRED WITH MADE REPAIR PART.SDR ASAA0671047Skin · lightning strikeUPON GVI PER TC 78011000 FOUND LIGHTNING STRIKE ON FUSELAGE SKIN.SDR ASAA0570047Skin · bentPAE - BELT LOADER CONTACTED AIRCRAFT FUSELAGE SKIN AT FORWARD CARGO DOOR CUTOUT AFT EDGE. CUT OUT DAMAGE AND INSTALLED REPAIR IAW SRM 53-00-01 NR 24. (M)SDR ASAA0570014Support · corrodedDURING MAINTENANCE CHECK, FOUND CORROSION ON FLOOR TO SIDEWALL SUPPORT AT BS 767. REPAIR IAW SRM. (K)SDR ASAA0570015Frame · bentPAE - DURING MAINTENANCE CHECK, FOUND FORWARD FRAME CLOSURE WEB BENT, AFT CARGO DOOR CUT OUT. REPAIR IAW SRM 51-40-02. (M)SDR ASAA0470001Battery Pack · dischargedSEA - DURING MAINTENANCE CHECK, FOUND FLOOR TRACK LIGHT INOPERATIVE AT ROW 15C. REPLACED BATTERY PACK, OPS CHECKED GOOD. (M)SDR ASAA0370018Strap · corrodedOAK - DURING C-CHECK, FOUND FLOOR PANEL SUPPORT STRAP IS CORRODED AT FS 887. REPLACED STRAP PER MM 51-40-02. (M)SDR ASAA0370016Cargo Track · corrodedOAK - DURING MAINTENANCE C-CHECK, FOUND CORROSION ON FLOOR TIE DOWN TRACK. SPLICE IN NEW SECTION PER SRM. (M)SDR ASAA0370017Angle · corrodedOAK - DURING MAINTENANCE C-CHECK, FOUND CORROSION ON FLOOR Z-ANGLE. REPLACED WITH NEW 'Z' ANGLE PER SRM. (M)SDR ASAA0370015Floor Support · corrodedOAK - DURING MAINTENANCE C-CHECK, FOUND CORROSION ON FLOOR SUPPORT RAIL. SPLICED FLOOR SUPPORT RAIL PER SRM. (M)SDR ASAA0270012Structure · gougedSEA - DURING MAINTENANCE CHECK, A GOUGE WAS FOUND IN THE PNEUMATIC ACCESS DOOR SURROUND STRUCTURE. CLEANED UP GOUGE AND INSTALLED REPAIR STRAP PER EA5310-02109. (M)SDR ASAA0270011Skin · dentedSEA - DURING MAINTENANCE CHECK, FOUND A DENT IN AFT CARGO DOOR. REPAIRED DENT WITH DOUBLER PER EA 5230-01176. (M)SDR ASAA0270004Fire Detector · malfunctionedDURING CLIMB, THE FORWARD CARGO FIRE WARNING LIGHT CAME ON. PILOT FIRED FIRE EXTINGUISHER BOTTLE AND RETURNED TO AIRPORT. INSPECTED FORWARD CARGO COMPARTMENT, THERE WERE NO SIGNS OF A FIRE. DUST FROM A LIVE SHIPMENT OF BIRDS WAS THE LIKELY CAUSE OF THE FIRESDR ASAA0170004Wire · disconnectedSEA - DURING LINE MAINTENANCE, THE EMERGENCY TRACK LIGHTS WERE FOUND TO BE INOPERATIVE IN ROWS 15 THROUGH 18. RE-CONNECTED THE TRACK LIGHT WIRES AT ROW 18. THE LIGHTS THEN OPERATED NORMALLY. (M)SDR ASAA0070002Roller · lack of lubePDX - PRIOR TO FLIGHT 313, THE FLIGHT ATTENDANT REPORTED THAT THE L1 DOOR HANDLE WOULD NOT UNLOCK. LUBRICATED DOOR ROLLERS AND THE DOOR OPERATED NORMALLY. (M)
Back to N617AS