N919AN
Service difficulty reports · 213
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 = 'N919AN' 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 = 'N919AN' 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 AALA202305038507Stringer · unknownAIRCRAFT WAS IN BASE MAINTENANCE: MAJOR REPAIR VALIDATION, FOUND EXISTING STRINGER REPAIR BETWEEN STA. 312-328 STR 3L. NO COMPLIED WITH SRM AND PER AA EA# 343750 REQ REPAIR PER SRM 53-00-03 REPAIR 3.SDR AALA202305054097Frame · corrodedAIRCRAFT IN BASE MAINTENANCE: CORRODED FRAME LOCATED BETWEEN 312 AND 325, AND STR 23L. REPAIRED FRAME WITH REINFORCEMENT PER EA.SDR AALA202305052608Skin · crackedAIRCRAFT IN BASE MAINTENANCE: EXTERNAL POWER RECEPTACLE INTERNAL DOOR FRAME IS CRACKED / MISSING MATERIAL. LOCATED BETWEEN 235.8 AND 243.7 AND STR 21R AND 22R. INSTALLED DOUBLER REPAIR PER SRM.SDR AALA202305128264Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 400 TO BS 420 AT STR 26L. REPLACED INTERCOSTAL PER SRM 51-40-05. **SUPPLEMENTAL REPORT REQUIRED FOR AALA202305098264: SECTION 7 UPDATED TO REMOVE CORROSDR AALA202305098264Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FROM BS 400 TO BS 420 AT STR 26L. REPLACED INTERCOSTAL PER SRM 51-40-05.SDR AALA202304178487Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD PASSENGER CABIN RIGHT HAND INNER CORD LOCATED FROM BS 312 TO BS 328 AT RBL 58. REMOVED AND REPLACED CHORD PER SRM 51-40-02-OGSDR AALA202304180290Floor Support · crackedAIRCRAFT IN BASE MAINTENANCE: PASSENGER COMPARTMENT FLOOR SUPPORT CRACKED LOCATED AT STA 540 AND BUTT LINE 0. REMOVED AND REPLACED FLOOR SUPPORT.SDR AALA202304172919Seat Track · brokenAIRCRAFT IN BASE MAINTENANCE: SCALLOPED SECTION BROKEN OFF OF LEFT HAND SEAT TRACK LOCATED FROM BS 480 TO BS 500B + 10 INCHES AT LBL 45. REPLACED SEAT TRACK PER SRM 53-00-52-2R-4.SDR AALA202304183482Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: FORWARD WET AREA INTERCOSTAL CRACKED BETWEEN STA 278 TO STA 294 AND BUTT LINE 0. REMOVED AND REPLACED FORWARD WET AREA INTERCOSTAL.SDR AALA202304058272Skin · puncturedAIRCRAFT IN BASE MAINTENANCE: HAIL PUNCTURE IN LEFT HAND ELEVATOR UPPER SURFACE LOCATED AT ELEVATOR STA 76, 6.5 INCHES FROM TRAILING EDGE. REPAIRED SKIN PER SRM 51-70-04.SDR AALA202304051264Intercostal · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR SUPPORT INTERCOSTAL LOCATED FROM BS 951 TO BS 967 AT RBL 52. REPLACED INTERCOSTAL PER SRM 53-70-51-1A.SDR AALA202304055507Unknown · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON AFT PASSENGER CABIN FLOOR BEAM T CHORD LOCATED AT BS 986 AND FROM BL 0 TO RBL 50. REPLACED T CHORD PER DWG DBF-1555.SDR AALA202304052688Channel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND Z CHANNEL LOCATED AT BS 982 AND LBL 40. REPLACED CHANNEL PER DWG 147A5700 REV AA.SDR AALA202304053298Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 328 TO BS 344 AT LBL 46. REPLACED INTERCOSTAL PER DWG 141A5400.SDR AALA202304050622Web · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON LEFT HAND WEB LOCATED AT BS 986 AND LBL 40. FABRICATED AND INSTALLED NEW WEB PER DWG 147A5712.SDR AALA202304053248Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN INTERCOSTAL LOCATED FROM BS 312 TO BS 328 AT LBL 46. REPLACED INTERCOSTAL PER SRM 53-00-04-1A-1.SDR AALA202304053035Intercostal · crackedAIRCRAFT IN BASE MAINTENANCE: CRACK IN FORWARD CARGO COMPARTMENT INTERCOSTAL LOCATED FROM BS 500H TO BS 500I AT S26L. REPLACED INTERCOSTAL PER SRM 51-40-02 0G.SDR AALA202304057678Intercostal · out of toleranceAIRCRAFT IN BASE MAINTENANCE: ELONGATED HOLE IN FORWARD CARGO COMPARTMENT FLOOR STRUCTURE INTERCOSTAL LOCATED FORM BS 500F TO BS 500E AT S26L. REPLACED INTERCOSTAL PER SRM 51-40-02 OG.SDR AALA202304053355Transition Panel · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND TRANSITION PANEL LOCATED FROM BS 500I TO BS 500 AT S26R. REMOVED AND INSTALLED NEW TRANSITION PANEL PER SRM 53-00-53-2R.SDR AALA201911049005Trunnion · corrodedAIRCRAFT IN MOD VISIT: CORROSION ON FWD TRUNNION FITTING BORE AND FACE AT STA 601-616, BL0. REMOVED AND REPLACED RH TRUNNION FITTING IAW MCM 32-94-24.SDR AALA201911049006Trunnion · corrodedAIRCRAFT IN MOD VISIT: CORROSION ON FWD LH MLG TRUNION BORE FACES AT STA 601-616, BL0. REMOVED AND REPLACED LH MLG TRUNNION IAW MCM 32-94-24.SDR AALA2019042329043Indicator · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON APPROACH TO SAN THE LEADING EDGE FLAPS AND TRAILING EDGE FLAPS FAILED TO EXTEND, HYD PRESSURE NORMAL, FOLLOWED QRH PROCEDURES. MAINTENANCE ACCOMPLISHED BITE TEST OF FSEU AND FOUND MSG 27-58400 T/E FLAP INDICATION. ACCOMPSDR AALA2019042329002Control Unit · unreliableAIRCRAFT WAS GROUNDED: PILOT REPORTS ON APPROACH TO SAN THE LEADING EDGE FLAPS AND TRAILING EDGE FLAPS FAILED TO EXTEND, HYD PRESSURE NORMAL, FOLLOWED QRH PROCEDURES. MAINTENANCE ACCOMPLISHED BITE TEST OF FSEU AND FOUND MSG 27-58400 T/E FLAP INDICATION. ACCOMPSDR AALA201904086001Panel · crackedAIRCRAFT IN BASE MAINTENANCE: CRACKED SHROUD PANEL ON THE R1 DOOR CUTOUT FRAME AT FORWARD LOWER CORNER STOP PAD FITTING AT UPPER OUTBOARD CORNER OF FITTING. REPLACED SHROUD PANEL PER AARD 51-00-05-1 AND EA 292456.SDR AALA201904042002Strap · corrodedAIRCRAFT IN BASE MAINTENANCE: CORROSION ON R1 DOOR LOWER CHORD STRAP AT BS 295 AND RBL 55. REPLACED STRAP PER AARD 51-00-05-1.SDR AALA201901159004Skin · corrodedCORROSION FOUND ON THE LEFT WING LOWER SKIN BETWEEN WINGLET AND OUTBOARD DRY BAY ACCESS PANEL. THE AIRCRAFT WAS GROUNDED. THE CORROSION WAS REMOVED, FOUND TO BE WIITHIN LIMITS IAW EA 288932.SDR AALA201801129042Sign · missingAIRCRAFT WAS NOT GROUNDED. FORWARD ENTRY EMERGENCY EXIT SIGN MISSING. REMOVED AND REPLACED FORWARD ENTRY LIGHT EXIT SIGN PER AMM 33-51-01-960-802.SDR AALA201801049015Lens · missingMISSING EXIT SIGN COVER NEAR FIRST CLASS GALLEY, BENEATH STORAGE AREA. MAINTENANCE INSTALLED EXIT SIGN COVER NEAR FIRST CLASS GALLEY.SDR AALA201712159028Girt Bar · out of adjustAIRCRAFT WAS NOT GROUNDED. DOOR 1R GIRT BAR DIFFICULT TO ENGAGE AND DOES NOT STAY IN PLACE ONCE ENGAGED IN DISARM POSITION. ADJUSTED 1R DOOR GIRT BAR HANGERS PER AMM 25-66-00. OPERATIONAL CHECK NORMAL. OK FOR SERVICE.SDR AALA201708219048Lens · looseAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT AT THE RIGHT AFT GALLEY HAS A LOOSE LENS COVER. ADJUSTED LENS COVER PER AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA201708159034Lens · missingTHE AIRCRAFT WAS NOT GROUNDED. AFT RIGHT EXIT SIGN COVER MISSING. REPLACED MISSING LENS COVER PER AMM 33-51-01.SDR AALA201707039038Stop Fitting · missingTHE AIRCRAFT WAS NOT GROUNDED. 4R GIRT BAR RETAINER MISSING. FOUND GIRT BAR MISSING STOP ASSEMBLY. REPLACED SLEEVE ON GIRT BAR.SDR AALA201703149002Ufi · malfunctionedAIRCRAFT WAS NOT GROUNDED. CENTER TANK LEFT FUEL PUMP LOW PRESSURE LIGHT ILLUMINATED WITH FUEL IN CENTER TANK. ACCOMPLISHED FIM 28-22-00-810-801. RESET LEFT UNIVERSAL FAULT INTERRUPTER IAW FIM 28-22-00-810-822. OPERATIONAL CHECK GOOD.SDR AALA20170302011Lens · missingAIRCRAFT WAS NOT GROUNDED. EMERGENCY EXIT LIGHT BY THE G2 WALL HAS A MISSING LENS COVER. INSTALLED LENS COVER IAW AMM 33-51-01. OPERATIONAL CHECK GOOD.SDR AALA20170215037Bracket · dirtyAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE IS DIFFICULT TO DISARM, ESPECIALLY ON RIGHT SIDE OF GIRT BAR. CLEANED DEBRIS FROM DOOR MOUNTED ESCAPE SLIDE BRACKET IAW AMM 25-66-02. OPERATIONAL CHECK GOOD.SDR AALA20170207019Bracket · dirtyAIRCRAFT WAS NOT GROUNDED. R1 DOOR EMERGENCY EVACUATION SLIDE IS DIFFICULT TO ARM. CLEARED DEBRIS FROM GIRT BAR FLOOR BRACKET. OPERATIONAL CHECK GOOD.SDR AALA20170116001Rib · crackedRIGHT HORIZONTAL STABILIZER LEADING EDGE RIB AT HSS 56 IS CRACKED. REPAIRED THE RIB IAW SRM 51-40-02 AND EA 265980.SDR AALA20170115008Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL AT APPROXIMATELY FUSELAGE BS 1016, RBL 28 IS CORRODED. REMOVED AND REPLACED THE INTERCOSTAL IAW 51-00-05-1 AND DRAWING 148A0922.SDR AALA20170114005Plate · corrodedAFT PRESSURE BULKHEAD LEFT CLOSURE PLATE AT BS 1016, RBL 40 IS CORRODED. REMOVED AND REPLACED THE PLATE IAW SRM 51-40-02.SDR AALA20170114002Plate · corrodedAFT PRESSURE BULKHEAD LEFT CLOSURE PLATE AT BS 1016 AND LBL 40 IS CORRODED. REMOVED AND REPLACED THE PLATE IAW 51-00-05.SDR AALA20170112001Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL AT APPROXIMATELY BS 1025 BETWEEN LBL 26.36 AND LBL 40 IS CORRODED. REMOVED AND REPLACED INTERCOSTAL IAW 51-00-05.SDR AALA20170110001Web · corrodedNOSE LANDING GEAR WHEEL WELL TOP PANEL WEB IS CORRODED AT APPROXIMATELY RBL 6 BETWEEN BS 251.6 AND 259.5. REPAIRED WEB IAW SRM 51-70-13-2R-1 AND EA 266171.SDR AALA20170111021Intercostal · corrodedAFT PRESSURE BULKHEAD INTERCOSTAL AT APPROXIMATELY BS 1025 BETWEEN LBL 16.73 AND LBL 26.30 IS CORRODED. REMOVED AND REPLACED INTERCOSTAL IAW 51-00-05.SDR AALA20170107009Floorbeam · corrodedCABIN FLOORBEAM AT BS 993 IS CORRODED BETWEEN RBL 33 AND RBL 46. REMOVED AND REPLACED FLOORBEAM IAW SRM 51-40-02 AND DRAWING 147A5700.SDR AALA20170107008Support · corrodedCABIN FLOOR WALL SUPPORT BETWEEN RRIGHT FORWARD AND RIGHT AFT G6 FLOOR GALLEY MOUNTS IS CORRODED. REMOVED AND REPLACED SUPPORT IAW SRM 51-10-02 AND DRAWING 147A5710.SDR AALA20170107007Support · corrodedCABIN FLOOR WALL SUPPORT AT APPROXIMATELY FUSELAGE BS 993 BETWEEN RBL 33 AND 43 IS CORRODED. REMOVED AND REPLACED SUPOORT IAW SRM 51-10-02 AND DRAWING 147A5710.SDR AALA20170106018Web · corrodedCABIN FLOOR WEB AT BS 986.5 IS CORRODED BETWEEN LBL 33 AND LBL 40. REMOVED AND REPLACED WEB IAW 51-00-05 AND SRM 51-40-02.SDR AALA20170106010Floor Support · corrodedCABIN FLOOR SUPPORT AT LBL 32.10 BETWEEN BS 990.5 AND 1010 IS CORRODED. REMOVED AND REPLACED THE FLOOR SUPPORT IAW 51-00-05, AND SRM 51-40-02.SDR AALA20170105027Support Angle · corrodedR2 DOOR THRESHOLD SUPPORT ANGLE BETWEEN BS 985.5 AND 1006, RBL 44 IS CORRODED. REMOVED AND REPLACED ANGLE IAW 51-00-05, AND SRM 51-40-02.SDR AALA20170105009Bulkhead Web · corrodedWEB UPPER FLANGE AT BS 1023 BULKHEAD AND APPROXIMATELY RBL 43 IS CORRODED. REMOVED AND REPLACED BULKHEAD WEB IAW 51-00-05, SRM 51-40-02, AND DRAWING 147A5700.
Back to N919AN