N915AN
Service difficulty reports · 241
Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. 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 = 'N915AN' AND registry_match = 'registration' 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 = 'N915AN' AND registry_match = 'registration' 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 AALA20160219005Baffle · bentFORWARD CARGO AREA BAFFLE BENT AT STATION 500C - 500D ON LT SIDE, AT STRINGER 25L. INSTALLED SERVICEABLE BAFFLE ASSEMBLY IAW REPAIR DOCUMENT 53-00-01 & SRM 51-10-02. ACFT IN BASE MX.SDR AALA20160218008Floorbeam · corrodedAFT CARGO, NUMEROUS AREAS OF CORROSION ON FLOOR PANEL SUPPORT LT ANGLE, AT LOWER END OF STATION 947.5 BLK, BETWEEN APPROX LBL 12 & RBL 18. INSTALLED NEW FLOOR PANEL SUPPORT LT ANGLE, AT LOWER END OF STATION 947.5 IAW AARD 51-00-05-1. ACFT IN BASE MX.SDR AALA20160217004Fitting · corrodedCORROSION ON PRESS BULK HEAD FITTING AT STRINGER 23L. COMPLETED INSTALLATION OF 23L STRINGER SPLICE REPAIR & FITTING REPLACEMENT AT AFT PRESS BULKHEAD STATION 996 - 1016 IAW SRM M 53-00-03-2R-1 & AARD 51-00-05-1. ACFT IN BASE MX.SDR AALA20160216015Splice Plate · corrodedAFT CARGO NUMEROUS AREAS OF CORROSION ON FLOOR PANEL SPLICE PLATE AT STATION 887, BETWEEN RBL 18 & LBL 12. INSTALLED FLOOR PANEL SPLICE PLATE IAW AARD 51-00-05-1. ACFT IN BASE MX.SDR AALA20160216010Angle · corrodedLEFT TRANSITION PANEL, Z ANGLE, HAS NUMEROUS AREAS OF LIGHT CORROSION, FROM STATION 727F - 727G. BLENDED OUT LIGHT CORROSION IAW SRM 51-10-02. ALODINED & PRIMED BLENDED AREAS IAW SRM 51-20-01-0G. ACFT IN BASE MX.SDR AALA20160216007Transition Panel · corrodedAFT CARGO, LT TRANSITION PANEL, Z ANGLE, STATION 727I+12 - 847, HAS AREAS OF CORROSION. ACCOMPLISHED A TRANSITION PANEL SPLICE IAW SRM 53-00-53-2R-5 & REPAIR DOCUMENT 51-00-05-1. ACFT IN BASE MX.SDR AALA20160215001Angle · corrodedAFT CARGO AREA, CORROSION ON RT TRANSITION PANEL, Z ANGLE, FROM STATION 727H - 727I. ACCOMPLISHED SPLICE REPAIR OF TRANSITION PANEL FROM STATION 727H+11 - 767 IAW SRM 53-00-53-2R-5. ACFT WAS IN BASE MX.SDR AALA20160212008Threshold · corrodedFORWARD CARGO DOOR JAMB THRESHOLD WEB HAS CORROSION ON UPPER & LOWER FACE, FWD & AFT CORNERS. REMOVED THRESHOLD WEB & REPLACED WITH SERVICEABLE WEB IAW SRM 51-10-02-0G & 51-40-02. ACFT IN BASE MX.SDR AALA20160218004Pressure Deck · crackedPRESSURE DECK STATION 663, RBL 25 - 45, CRACKED IN WW UPPER FWD WALL WEB. COMPLETED SRM REPAIRS TO RT WEB PLATE ASSEMBLY, PN 111A1111-1, IAW SRM 57-10-10-2R-3 REPAIR 3 ALT.2. REPAIR COMPLETED ON BOTH SIDES OF WEB. ACFT IN BASE MX.SDR AALA20160211011Pressure Deck · crackedPRESSURE DECK STATION 663, LBL 25 - 45, CRACKED IN WW UPPER FWD WALL WEB. COMPLETED SRM REPAIRS TO LT WEB PLATE ASSEMBLY, PN 111A1111-1, IAW SRM 57-10-10-2R-3 REPAIR 3 ALT 2. REPAIR COMPLETED ON BOTH SIDES OF WEB. ACFT IN BASE MX.SDR AALA20160211014Intercostal · crackedINTERCOSTAL AT STATION 312 - 294, RBL 45 IS CRACKED. REPAIRED INTERCOSTAL 141A5410-11, FLOORBOARD HOLE WITH NESTED ANGLE REPAIR IAW SRM 53-10-51-2R REPAIR 6. ACFT IN BASE MX.SDR AALA20160210003Support Angle · corrodedGALLEY SUPPORT ANGLE CORRODED, AT STATION 993, RBL 34. R & R GALLEY SUPPORT ANGLE IAW AARD 51-00-05-1 & SRM 51-40-02. ACFT IN BASE MX.SDR AALA20160209001Skin · dentedFORWARD CARGO DOOR HAS A DENT 7 INCHES X 2 INCHES X .072 INCHES DEEP ON EXTERIOR SKIN, LOCATED SLIGHTLY FWD & ABOVE DOOR HANDLE. CUT OUT DAMAGED AREA & INSTALLED EXTERNAL DOUBLER IAW SRM 52-00-01-2R & EA 258030. ACFT IN BASE MX.SDR AALA20160208005Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED, BETWEEN STATION 344 & 360, LBL 12. INSTALLED NEW SERVICEABLE INTERCOSTAL IAW AARD 51-00-05. ACFT IN BASE MX.SDR AALA20160208004Intercostal · crackedCABIN FLOOR INTERCOSTAL CRACKED AT STATION 335, LBL 45. INSTALLED NEW INTERCOSTAL AT LBL 45, STATION 335 IAW AARD 51-00-05. ACFT IN BASE MX.SDR AALA20160208001Stiffener · corrodedVERTICAL STIFFENER AT STATION 1125, AT APU INLET CUT OUT IS CORRODED. R & R VERTICAL STIFFENER AT STATION 1125, APU INLET, IAW AARD 51-10-05 & DWG 148A8650. ACFT IN BASE MX.SDR AALA20160207004Intercostal · crackedFLOOR LBL 1 INTERCOSTAL, BETWEEN BEAMS 344 & 360 IS CRACKED. INSTALLED NEW INTERCOSTAL, BETWEEN STATION 344 & 360 IAW AARD 51-00-05 & DWG 141A5400. ACFT IN BASE MX.SDR AALA20160207003Intercostal · crackedFLOOR INTERCOSTAL LBL 45, AT STATION 321, IS CRACKED. INSTALLED NEW INTERCOSTAL AT LBL 45, STATION 321, IAW AARD 51-00-05. ACFT IN BASE MX.SDR AALA20160207002Intercostal · crackedCABIN FLOOR INTERCOSTAL, BETWEEN FLOORBEAMS 312 & 328 AT RBL 31 IS CRACKED. INSTALLED NEW INTERCOSTAL, BETWEEN FLOORBEAMS 312 & 328, AT RBL 31, IAW SRM 51-10-02 & AARD 51-00-05. ACFT IN BASE MX.SDR AALA20160205004Floor Support · crackedCABIN FLOORBOARD SUPPORT ANGLE CRACKED AT STATION 540, LBL 2. INSTALLED NEW SERVICEABLE FLOORBOARD SUPPORT ANGLE IAW AARD 51-00-05-1. ACFT IN BASE MX.SDR AALA20160105010Sign · damagedAIRCRAFT WAS GNDED. EXIT LIGHT SIGN, ON AISLE SIDE, OUTSIDE FIRST CLASS GALLEY IS DAMAGED. R & R LIGHT ASSEMBLY IAW AMM 33-51-01. SYS CHECKED NORMAL.SDR AALA20151104003Skin · crackedTWO CRACKS IN LT HORIZONTAL STABILIZER SKIN, APPROX STATION 120.3, FWD & AFT OF DRAIN HOLES. INSTALLED 2 EACH FILLERS, 1 DOUBLER & FAY SEALED EDGE IAW SRM 55-10-01-2R-11, ON LT LOWER HORIZONTAL SURFACE.SDR AALA20151021016Pressure Panel · crackedFOUND WEB CRACKED, MPN 111A1101001, BETWEEN LBL 31.83 - RBL 43.80, STATION 663.75. CUT OUT CRACKS & INSTALLED DOUBLERS IAW EA 255485.SDR AALA20140222003Skate Angle · crackedLT HAND FUSELAGE CHORD SPLICE BULKHEAD STATION 540 BETWEEN STRINGER 22 TO 23 LT, AFT ROW SECOND FROM TOP HOLE HAS CRACK INDICATION. INSTALLED DOUBLER, TRIPLER & NEW SKATE ANGLE IAW EA B737-53-033706.SDR AALA20140222002Fitting · damagedRT HAND MLG FWD TRUNNION FITTING SEALANT CUT AROUND UPPER FUSE PIN. REPLACED FWD TRUNNION FITTING IAW EA B737-57-033693.SDR AALA20140210007Intercostal · crackedINTERCOSTAL FROM STATIONS 312 TO 328 CRACKED. REPLACED INTERCOSTAL IAW AARD 51-10-05-1.SDR AALA20140210002Angle · corrodedCORROSION ON UPPER AUXILIARY POWER UNIT INLET BOX ANGLE AT STATION 1088, FWD SIDE. REPLACED UPPER ANGLE IAW DRAWING 148A0924 & AARD 51-10-05-1.SDR AALA20131029004Intercostal · corrodedCORROSION ON INTERCOSTAL AT LBL 52 & STATION 947. REPLACED INTERCOSTAL.SDR AALA20131028011Floorbeam · corrodedCORROSION ON AFT FLANGE OF FLOORBEAM AT STATION 987 & RBL 21. REPLACED T CHORD.SDR AALA20131028010Floorbeam · corrodedCORROSION ON AFT FLANGE OF FLOORBEAM AT STATION 987 & RBL 18. REPLACED T CHORD.SDR AALA20131028009Floorbeam · corrodedCORROSION ON FLOORBEAM AT RBL & STATION 986. REPLACED T CHORD.SDR AALA20131028008Floorbeam · corrodedCORROSION ON FLOORBEAM REPAIR AT RBL & STATION 986. REPLACED T CHORD IAW SRM.SDR AALA20131027005Angle · corrodedRT Z ANGLE HAS CORROSION ON AFT END AT RBL 32 & STATION 1016. REPLACED Z ANGLE.SDR AALA20131026009Bolt · missingFOUND SEAT TRACK BOLTS MISSING AT STATION 727B AT LBL 45.5. OVERSIZED HOLES WERE BROUGHT UP TO LARGER SIZE IAW EA B737-53-032156.SDR AALA20131026008Floorbeam · corrodedCORROSION ON FLOORBEAM AT RBL 33 & STATION 986. REPLACED T CHORD IAW SRM.SDR AALA20131026007Angle · corrodedRT CREASE ANGLE UNDER RT NR 2 DOOR CORRODED. REPLACED RT HAND CREASE ANGLE.SDR AALA20131026006Web · corrodedRT NR 2 WEB UNDER THRESHOLD FROM STATIONS 950 TO 994 FASTENER HOLES CORRODED. REPLACED WEB IAW AARD 51-00-05.SDR AALA20131026005Floorbeam · corrodedCORROSION ON FLOORBEAM AT STATION 986 & RBL 43. REPLACED T-CAP.SDR AALA20131026004Angle · corrodedZ ANGLE FROM STATIONS 986 & 1016 CORRODED. REPLACED Z ANGLE AT LBL 3.SDR AALA20131026018Seat Track · crackedPERFORMED HFEC OPEN HOLE INSPECTION ON SPLICE STRAP AT SEAT TRACK AT STATION 727B & RBL 24.75, FOUND CRACKS ON INBD & OTBD SIDE. REAMED HOLES, FABRICATED NEW REPAIR FILLERS, & COMPLETED IAW EA B-737-53-032156.SDR AALA20131026017Seat Track · crackedPERFORMED HFEC OPEN HOLE INSPECTION ON FWD SECTION OF SEAT TRACK AT STATION 727B & RBL 24.75, FOUND CRACKS ON INBD & OTBD SIDE. CUT-OUT CRACKED AREA, REAMED HOLES & ACCOMPLISHED REPAIR IAW EA B737-53-032156.SDR AALA20131026016Seat Track · crackedPERFORMED HFEC OPEN HOLE INSPECTION ON SPLICE STRAP AT SEAT TRACK AT STATION 727B & RBL 45.50, FOUND CRACKS ON INBD & OTBD SIDE. REAMED HOLES, CUT OUT CRACKED AREA & ACCOMPLISHED REPAIR IAW J1707 & EA B737-53-032156.SDR AALA20131026015Seat Track · crackedPERFORMED HFEC OPEN HOLE INSPECTION ON FWD SECTION OF SEAT TRACK AT STATION 727B & RBL 45.50, FOUND CRACKS ON INBD & OTBD SIDE. REAMED HOLES, CUT OUT CRACKED AREA & ACCOMPLISHED REPAIR IAW ECO J1707 & EA B737-53-032156.SDR AALA20131026014Seat Track · damagedRBL 24.75 SEAT TRACK, INBD & OTBD FLANGE HOLE ELONGATED, AT STATION 727B. REAMED HOLES & ACCOMPLISHED REPAIR IAW EA B737-53-032156.SDR AALA20131026013Seat Track · crackedPERFORMED HFEC OPEN HOLE INSPECTION ON SPLICE STRAP AT SEAT TRACK AT STATION 727B & RBL 45.50, FOUND CRACKS ON INBD & OTBD SIDE. CUT OUT CRACKED AREA & ACCOMPLISHED REPAIR IAW ECO J1707AA & EA B737-53-032156.SDR AALA20131026012Seat Track · crackedPERFORMED HFEC OPEN HOLE INSPECTION ON FWD SECTION OF SEAT TRACK AT STATION 727B & LBL 45.50, FOUND CRACKS ON INBD & OTBD SIDE. REAMED HOLES & ACCOMPLISHED REPAIR IAW EA B737-53-032156.SDR AALA20131026011Strap · crackedLBL 45.50 SPLICE STRAP CRACKED AT RADIOUS, STATION 727B. REPLACED SPLICE STRAP IAW ECO J1707AA & EA B737-53-032156.SDR AALA20131026010Seat Track · crackedLBL 45.50 FWD SEAT TRACK CRACKED AT FASTENER HOLE, FWD OF STATION 727B. OVERSIZED HOLES IAW EA B737-53-032156.SDR AALA20131025006Web · corrodedDAMAGE TO WEB AT STATION 1006 & RBL 3. INSTALLED STRAP PIECE.SDR AALA20131025005Floorbeam · corrodedCORROSION ON FLOOR BEAM AT LBL 43 & STATION 986. INSTALLED REPAIR ANGLES & FILLER IAW SRM 53-00-51-2R & EA B737-53-.32143.
Back to N915AN