N917AN
Service difficulty reports · 171
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 = 'N917AN' 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 = 'N917AN' 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 AALA20160702007Shield · corrodedFORWARD CARGO RIGHT TRANSITION PANEL ANGLE SHIELD BETWEEN BS 490-500A CORRODED OUT OF LIMITS. INSTALLED A NEW TRANSITION PANEL ANGLE SHIELD IAW AARD 51-00-05-1 AND EA 261639 DATED 6/28/16.SDR AALA20160702006Baffle · crackedFORWARD CARGO BAFFLE CRACKED AT BS 500H, STRINGER 26L, AFT SIDE. INSTALLED NEW SERVICEABLE BAFFLE IAW AARD 53-00-01 AND AARD 51-00-05-1.SDR AALA20160702005Angle · corrodedDURING MAINTENACE, FORWARD CARGO RIGHT TRANSITION PANEL ANGLE SHIELD CORRODED OUT OF LIMITS BS 420 - 440. INSTALLED A NEW TRANSITION PANEL ANGLE SHIELD IAW AARD 51-00-05-1 AND EA 261639.SDR AALA20160702004Support Angle · corrodedDURING MAINTENANCE, AFT G4 GALLEY LOW SEAL FLOORBEAM SUPPORT ANGLE HAS CORROSION AT BS 993, LBL 43. REMOVED AND REPLACED THE SUPPORT ANGLE IAW BLUEPRINT 147A5710, ITEM 1, PAGE 001 AND, AARD 51-00-05-1.SDR AALA20160701008Floor Support · corrodedDURING MAINTENANCE, AFT CARGO AFT WALL-FLOOR SUPPORT ANGLE CORRODED AT BS 947.5, 30 INCH LONG AREA. REMOVED AND REPLACED THE FLOOR SUPPORT IAW AARD 51-00-05-1 AND DRAWING 149A8117 SHEET 4.SDR AALA20160701007Support · corrodedDURING MAINTENANCE, AFT CARGO, RIGHT TRANSITION PANEL CORRODED AT THE ANGLE SUPPORT BS 887. INSTALLED THE ANGLE SUPPORT IAW SRM 51-10-02 PAR.8 AND DRAWING 146A7506.SDR AALA20160630010Floorbeam · corrodedACFT WAS IN BASE MAINTENANCE. CABIN FLOORBEAM AT FUSELAGE STA 328 IS CORRODED AT RBL 10. REPAIRED FLOORBEAM BETWEEN BL 0 AND RBL 54 IAW SRM 53-10-51-2R-7.SDR AALA20160630008Rib · crackedAIRCRAFT WAS IN BASE MAINTENANCE. LEFT HORIZONTAL STABILIZER RIB AT STABILIZER STA 92.7 IS CRACKED AT 4 STIFFENER LOCATIONS. REPAIRED RIB IAW SRM 55-10-09-2R-4 AND EA 261503.SDR AALA20160627009Web · corrodedAIRCRAFT WAS IN BASE MAINTENANCE. AFT GALLEY FLOOR WEB AT FUSELAGE STA 987 IS CORRODED AT RBL 31. REPAIRED WEB IAW SRM 51-70-13-2R-4.SDR AALA20160621016Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOOR INTERCOSTAL AT RBL 45 IS CRACKED AT FUSELAGE STA 320. R & R INTERCOSTAL IAW AARD 51-00-05-1R1 AND DWG 141A5400.SDR AALA20160620015Floor Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOOR PANEL SUPPORT AT FUSELAGE STA 540 IS CRACKED AT LBL 2. R & R SUPPORT IAW AARD 51-00-05-01.SDR AALA20160620005Floor Support · crackedAIRCRAFT WAS IN BASE MAINTENANCE. CABIN FLOOR PANEL SUPPORT AT FUSELAGE STA 540 IS CRACKED AT LBL 2. R & R SUPPORT IAW AARD 51-00-05-01.SDR AALA20160321010Socket · out of positionAIRCRAFT WAS GNDED, NR 4 TIRE BURST ON LANDING. ACCOMPLISHED FIM 32-42-00-810-806, FOUND PUSHED BACK SOCKET ON NR 4 ANTI-SKID TRANSMITTER T395. REPAIRED IAW FIM. ACCOMPLISHED SATISFACTORY ANTI-SKID CHECK IAW AMM 32-42-00.SDR AALA20151214004Skin · crackedAIRCRAFT WAS GNDED. 3 INCH CRACK IN RT HORIZONTAL STABILIZER LOWER SKIN 3 FEET AFT OF LE AT RIB STATION 138.70. ACCOMPLISHED DOUBLER REPAIR IAW SRM 55-10-01 TABLE 201 REPAIR 11.SDR AALA20151208009Seat Track · crackedCRACKS FOUND IN SEAT TRACK FASTENER ATTACH HOLES, LBL 24.75, STATION 727 B. REPAIRED FASTENER HOLES IAW EA 256578. ACFT IN BASE MX.SDR AALA20151208008Seat Track · crackedCRACKS FOUND IN SEAT TRACK FASTENER ATTACH HOLES, LBL 45.50, STATION 727B. REPAIRED FASTENER HOLES IAW EA 256578. ACFT IN BASE MX.SDR AALA20151208007Seat Track · crackedCRACKS FOUND IN SEAT TRACK FASTENER ATTACH HOLES, RBL 24.75, STATION 727 B. REPAIRED FASTENER HOLES IAW EA 256578. ACFT IN BASE MX.SDR AALA20151208006Seat Track · crackedCRACKS FOUND IN SEAT TRACK FASTENER ATTACH HOLES, RBL 45.50, STATION 727 B. REPAIRED FASTENER HOLES IAW EA 256578. ACFT IN BASE MX.SDR AALA20150825015Bulkhead · crackedCRACK IN UPPER WEB IN RT WW FWD BULKHEAD JUST INBD OF RBL 40. REPAIRED BULKHEAD WEB BETWEEN RBL 25 & RBL 48 IAW SRM 57-10-10-2R-3 FIGURE 204 & EA 253881.SDR AALA20150825014Bulkhead · crackedCRACK IN UPPER WEB IN LT WW FWD BULKHEAD AT APPROX LBL 35 & 40. REPAIRED BULKHEAD WEB BETWEEN LBL 25 - 48 IAW SRM 57-10-10-2R-3 FIG 204.SDR AALA20150727007Battery Pack · no testEMERGENCY EXIT LIGHTING BATTERY BACK PAC5026 FAILED SIC 2908 TEST AT SEAT POSITION 13DEF. R & R BATTERY PACK AT SEAT ROW 13DEF & PERFORMED TEST. SYSTEM CHECKED NORMAL.SDR AALA20140725008Frame · damagedSTATION 727D RT & 727I LT BETWEEN STRINGERS 21 & 22 LT DAMAGED. PERMANENT REPAIR ACCOMPLISHED IAW EA B737-53035805.SDR AALA20140725007Frame · damagedSTATION 787L BETWEEN STRINGERS 20 & 21 LT DAMAGED. PERMANENT REPAIR ACCOMPLISHED IAW B737-53-035900.SDR AALA20140722009Skin · corrodedCORROSION ON FUSELAGE SKIN AT STATION 540 & STRINGER 22 RT. REMOVED CORROSION & ACCOMPLISHED REPAIR IAW EA B737-53-035793.SDR AALA20140720001Skin · corrodedFUSELAGE SKIN HAS LIGHT CORROSION AROUND TWO FASTENERS AT STATION 927 BETWEEN STRINGER 21 & 22 LT. BLENDED OUT CORROSION, ACCOMPLISHED HIGH FREQUENCY EDDY CURRENT & INSTALLED DOUBLER IAW EA B737-53-035816.SDR AALA20140718004Skin · damagedSTATION 727D RT DAMAGED FROM STRINGERS 20 LT TO 20 RT. ACCOMPLISHED NESTED ANGLE REPAIR IAW B737-53-035805.SDR AALA20130815013Stiffener · damagedELONGATED HOLES IN INTERIOR STIFFENER AT BS 725, RBL 3 & WATER LINE 203. R&R STIFFENER IAW AARD 51-00-05-1.SDR AALA20120920009Floorbeam · corrodedFLOORBEAM AT FRAME STATION 927 RIGHT BUTTLINES 53 AND 54 CORRODED. INSTALLED DOUBLER PER AARD 53-00-00-7.SDR AALA20120920002Intercostal · corrodedINTERCOSTAL CORRODED FROM STATIONS 927 TO 947. REPLACED INTERCOSTAL PER AARD 51-00-05-1 REPAIR 1.SDR AALA20120717003Intercostal · crackedINTERCOSTAL FROM STATIONS 344 TO 360 BUTTLINE 0 CRACKED AT CLIP NUT. REPLACED INTERCOSTAL PER AARD 51-00-05-1.SDR AALA20110330MIA01Lamp · inoperativeEMERGENCY LIGHT SWITCH NOT ARMED LIGHT HAS ONE LAMP INOPERATIVE. REPLACED LAMP FOR EMERGENCY LIGHT SWITCH NOT ARMED LIGHT. OPS CHECK NORMAL.SDR AALA20101230TUL01Shroud · crackedEMERGENCY LIGHT AT 24D SHROUD CRACKED. REPLACED LIGHT ASSEMBLY FOR EMERGENCY LIGHT AT 24D. OPS CHECK NORMAL.SDR AALA20101230TPA02Lens · missingEMERGENCY LIGHT MISSING LENS AT 24D. REPLACED LENS FOR EMERGENCY LIGHT AT 24D. OPS CHECKS NORMAL.SDR AALA20101230TPA01Lens · missingEMERGENCY LIGHT RED LENS MISSING AT 13D. REPLACED RED LENS AT 13D FOR EMERGENCY LIGHT. OPS CHECKS NORMAL.SDR AALA20100818MIA01Valve · defectiveMIA - CREW REPORTED RIGHT WING BODY OVERHEAT LIGHT ILLUMINATED ON CLIMBOUT. FLIGHT RETURNED MIA LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LOOP ELEMENT RESISTANCE VALVES. SYSTEM GROUND CHECKED NORMAL OPERATION.SDR AALA20100506TUL09Floor Support · corrodedCORROSION ON FLOOR SUPPORT STRINGER. REPAIRED BY SPLICING IN A NEW SECTION.SDR AALA20100506TUL06Intercostal · corrodedCABIN FLOOR INTERCOSTAL HAS CORROSION. REMOVED AND REPLACED INTERCOSTAL PER SRM 51-10-02.SDR AALA20100506TUL05Floor Support · corrodedCARGO FLOOR SUPPORT (STRINGER) CORRODED. CUT OUT CORRODED SECTION OF SUPPORT AND SPLICED IN NEW SECTION FROM STATION 750 TO STATION 887. PER SRM 53-00-53-2R.SDR AALA20100427TUL05Frame · corrodedFRAME STATION 951 CORRODED BEYOND LIMITS. REPAIRED WITH A DOUBLER REPAIR.SDR AALA20100426TUL01Web · corrodedNUMEROUS AREAS OF CORROSION ON UPPER SURFACE OF WEB JUST INBOARD OF AFT CARGO DOOR SILL. INSTALLED NEW WEB AT CARGO DOOR OPENING PER SRM 51-10-02 AND BLIND FASTENERS INSTALLED PER SRM 51-40-02.SDR AALA20100425TUL05Frame · corrodedSTATION 967 CORROSION AROUND FASTENER REMOVED BEYOND LIMITS. INSTALLED FILLER, DOUBLER, AND TRIPLER REPAIR.SDR AALA20100425TUL04Angle · corrodedCORRODED CREASE ANGLE AT RIGHT NUMBER 1 DOOR. REPLACED WITH SERVICEABLE CREASE ANGLE.SDR AALA20100424TUL03Angle · corrodedAFT CARGO FLOOR STRUCTURE RIGHT Z-ANGLE HAS SEVERAL SMALL AREAS OF CORROSION. REMOVED AND REPLACED RIGHT Z-ANGLE STATION 727H TO STATION 767 PER SRM 53-00-53-2R REPAIR 5.SDR AALA20100418TUL04Intercostal · damagedINTERCOSTAL DAMAGED AT STATION 335 LEFT BUTTLINE 45. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02.SDR AALA20100418TUL03Intercostal · damagedINTERCOSTAL DAMAGED AT STATION 321 LEFT BUTTLINE 45. INSTALLED NEW INTERCOSTAL PER SRM 51-10-02.SDR AALA20091204LAX01Door · unsecureLEFT FORWARD CABIN DOOR DID NOT SEAL AFTER TAKEOFF, LOUD NOISE AND AIRCRAFT DID NOT PRESSURIZE. RETURNED TO LAX AND LANDED WITHOUT INCIDENT. FOUND LEFT FORWARD DOOR IN A FALSE LATCH CONDITION. INSPECTED AND RETURNED TO SERVICE.SDR AALA20090923DFW01Pump · failedDURING GEAR RETRACTION BOTH SYSTEM A HYDRAULIC LOW PRESSURE LIGHTS ILLUMINATED FOR A SHORT TIME. UPON REACHING CRUISE ENGINE HYDRAULIC A LIGHT ILLUMINATED FOLLOWED BY QUANTITY A DECREASING TO 15 PERCENT AT LANDING. LANDED DFW WITHOUT INCIDENT. REPLACED LEFTSDR AALA2009032400648Lamp · burned outDFW - EMERGENCY EXIT SIGN LIGHT AT LEFT NUMBER 2 DOOR INOPERATIVE. REPLACED LAMP FOR EMERGENCY EXIT SIGN.SDR AALA2009032400647Lamp · burned outDFW - EMERGENCY LIGHT AT 5E BULL NOSE INOPERATIVE. REPLACED LAMP FOR EMERGENCY LAMP AT 5E BULL NOSE.SDR AALA2009020800465Lens · brokenDFW - RIGHT FORWARD DOOR SIDE EXIT LENS BROKEN. REPLACED LIGHT ASSEMBLY AT RIGHT FORWARD DOOR SIDE EXIT.
Back to N917AN