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 AALA20170105006Web · corrodedCABIN FLOOR WEB AT BS 1015 IS CORRODED AT LBL 24. REMOVED AND REPLACED THE WEB IAW 51-40-02, SRM 51-40-02, AND DRAWING 147A5700.SDR AALA20161220007Mount · corrodedCABIN FORWARD WET FLOOR AREA HAS CORROSION AT BS 294, AFT OF THE G1 GALLEY OUTBOARD FORWARD FLOOR MOUNT. REPLACED INTERCOSTAL AND RUNNING FLOOR MOUNT IAW 51-00-05-1, DRAWING 141A5750-4 AND EA 266069.SDR AALA20161218006Transition Panel · corrodedCORROSION ON AFT CARGO COMPARTMENT LEFT SIDE TRANSITION PANEL SIDE PLATE BETWEEN BS 727+4 TO 847. REPLACED THE TRANSITION PANEL IAW SRM 53-00-53-2R-5.SDR AALA20161218004Cargo Track · corrodedCABIN FORWARD WET FLOOR AREA, THE FLOOR FITTING AT BS 344, LBL 48 IS CORRODED. REPLACED MOUNT FITTING / TIE DOWN ASSEMBLY IAW 51-00-05-1 AND DWG 141A5220.SDR AALA20161218003Angle · corrodedCABIN FORWARD WET FLOOR AREA, THE L1 DOOR CREASE ANGLE AT THE LOWER THRESHOLD IS CORRODED FROM BS 312 TO 344. REMOVED AND REPLACED THE CREASE ANGLE IAW 51-00-05-1 AND DRAWING 141A8112.SDR AALA20161218001Stiffener · corrodedCORROSION ON APU COMPARTMENT NR 2 STIFFNER. REPLACED THE STIFFNER IAW 51-00-05-1 AND 148A2410.SDR AALA20161217002Transition Panel · corrodedCORROSION ON LEFT TRANSITION PANEL BETWEEN BS 396 - 488, STRINGER 26L. INSTALLED NEW PANEL PER SRM 53-00-53.SDR AALA20161216002Floorbeam · corrodedTOP OF FLOORBEAM CORRODED AT BS 986.5 FROM LBL 29 TO RBL 4. REPAIRED THE FLOORBEAM IAW SRM 53-70-51-2R-4.SDR AALA20161216013Angle · corrodedFORWARD CARGO COMPARTMENT LEFT TRANSITION ANGLE AT S26L IS CORRODED BETWEEN BS 500C - 500E. REMOVED AND REPLACED TRANSITION ANGLE IAW SRM 53-00-53-2R-5.SDR AALA20161215033Plate · corrodedCORROSION ON AFT CARGO COMPARTMENT RIGHT SIDE TRANSITION PANEL SIDE PLATE BETWEEN BS 847 AND 867. REPLACED THE PLATE.SDR AALA20161215032Plate · corrodedCORROSION ON AFT CARGO COMPARTMENT RIGHT SIDE TRANSITION PANEL SIDE PLATE BETWEEN BS 767 AND 787. REPLACED THE PLATE.SDR AALA20161215031Plate · corrodedCORROSION ON AFT CARGO COMPARTMENT RIGHT SIDE TRANSITION PANEL SIDE PLATE BETWEEN BS 727+4 AND 767. REPLACED TRANSITION PANEL SIDE PLATE.SDR AALA20161215030Plate · corrodedCORROSION ON FORWARD CARGO COMPARTMENT RIGHT HAND SIDE TRANSITION PANEL SIDE PLATE BETWEEN BS 500A AND 500C. REPLACED TRANSITION PANEL SIDE PLATE BETWEEN BS 500A AND 500C.SDR AALA20161213008Plate · corrodedCORROSION ON FORWARD CARGO BAY LEFT TRANSITION PANEL SIDE PLATE BETWEEN BS 480 AND 500A. REPAIRED THE PLATE IAW SRM 53-00-53-2R.SDR AALA20161207002Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL BETWEEN FUSELAGE STATIONS 328 AND 344 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1 AND DRAWING 141A5410.SDR AALA20161207001Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL AT LBL 46 BETWEEN FUSELAGE STATIONS 312 AND 328 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1 AND DRAWING 141A5410.SDR AALA20161206024Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL AT LBL 14 BETWEEN FUSELAGE STATIONS 344 AND 360 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1 AND DRAWING 141A5410.SDR AALA20161206001Intercostal · crackedAIRCRAFT WAS IN BASE MAINTENANCE. INTERCOSTAL AT BL 0 BETWEEN FUSELAGE STATIONS 344 AND 360 IS CRACKED. REMOVED AND REPLACED INTERCOSTAL IAW AARD 51-00-05-1 AND DRAWING 141A5410 .SDR AALA20161219019Frame · corrodedCORROSION ON LOWER BULKHEAD FRAME SUPPORT AT BS 500L. REPLACED IAW 51-00-05.SDR AALA20161212001Web · corrodedCORROSION ON FORWARD CARGO BAY DOOR THRESHOLD WEB BETWEEN BS 440 AND 500. REPLACED THE DOOR THRESHOLD WEB.SDR AALA20161107019Lens · missingAIRCRAFT NOT GROUNDED. OVERHEAD BIN EMERGENCY EXIT LIGHT OVER SEAT 18A MISSING LENS. REPLACED LENS IAW AMM 33-51-03. OPERATIONAL TEST GOOD.SDR AALA20160804006Bulkhead Web · crackedVERTICAL PRESSURE WEB AT BS 663.75 IS CRACED AT APPROXIMATELY LBL 35. REPAIRED THE BULKHEAD WEB IAW EA 262406.SDR AALA20160727004Control Column · smokeSMOKE WAS OBSERVED COMING FROM THE FIRST OFFICER`S CONTROL YOKE AT THE NUMBER WHEEL. AN ELECTRICAL ODOR WAS ALSO NOTED AND THE YOKE WAS REPORTED TO BE WARN TO THE TOUCH. AIRCRAFT GROUNDED. MAINTENANCE REMOVED AND REPLACED THE CONTROL COLUMN REMINDER ASSEMBLYSDR AALA20160703001Bulkhead Web · crackedWHEEL WELL WEB HAS CRACKS AT BS 633, RBL 35 AND LBL 43. INSTALLED DOUBLER IAW EA 261790.SDR AALA20160617006Pseu · faultedAIRCRAFT WAS GROUNDED. EMERGENCY DECLARED. LANDING UNEVENTFUL. AIRCRAFT NOT OVERWEIGHT. DURING APPROACH THE T/E FLAPS DID NOT EXTEND BEYOND 2. FLAPS EXTENDED TO 15 BY USING ALTERNATE MODE. MAINTENANCE R & R PSEU IAW AMM 27-51-01. OPS CHECK NORMAL.SDR AALA20151222002Skin · corrodedAIRCRAFT WAS GNDED. FUSELAGE SKIN CORRODED AT LAVATORY VENT FROM STATIONS 907 - 927 & BETWEEN STRINGER 21L & 22L. ACCOMPLISHED SKIN REPAIR IAW EA 256952.SDR AALA20151012015Seat Track · crackedSTATION 727B, RBL 24.75 SEAT TRACK CTR MOUNT HOLE FOUND TO HAVE CRACK IN ONE OF THE ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA DRAFT 255075.SDR AALA20151012010Seat Track · crackedSTATION 727B, RBL 45.50 SEAT TRACK CTR MOUNT HOLE FOUND TO HAVE CRACK IN ONE OF THE ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA 255075.SDR AALA20151012009Seat Track · crackedSTATION 727B, RBL 45.50 SEAT TRACK CTR MOUNT HOLE FOUND TO HAVE CRACK IN ONE OF THE ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA DRAFT 255075.SDR AALA20151012008Seat Track · crackedSTATION 727B, RBL 24.75 SEAT TRACK FOUND TO HAVE CRACK IN THE 4 ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA 255071.SDR AALA20151012007Seat Track · crackedSTATION 727B, RBL 45.50 SEAT TRACK FOUND TO HAVE CRACK IN THE 4 ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA 255071.SDR AALA20151012006Seat Track · crackedSTATION 727B, LBL 24.75 SEAT TRACK FOUND TO HAVE CRACK IN THE 3 ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA 255071.SDR AALA20151012005Seat Track · crackedSTATION 727B, LBL 45.50 SEAT TRACK FOUND TO HAVE CRACK IN THE 4 ATTACH FASTENER HOLES. REPAIRED CRACKED FASTENER HOLES IAW EA DRAFT 255071.SDR AALA20140811003Stringer · corrodedAFT END OF STRINGER 25 RT CORRODED AT STATION 540 IN A/C DISTRIBUTION BAY. BLENDED OUT CORROSION IAW EA 53-036111.SDR AALA20140811001Skin · corrodedFUSELAGE SKIN HAS CORROSION IN AREA OF RT RAM AIR, STATIONS 500G TO 500H & LONGERONS 22 TO 24 LT. REMOVED CORROSION IAW SRM 51-10-02 & ACCOMPLISHED REPAIR IAW EA B737-53-036095.SDR AALA20140810003Support Beam · wornOUTBOARD FWD STRIKE PLATE WORN THROUGH FOR PNEUMATIC ACCESS DOOR LATCH. CUT OUT DAMAGE & INSTALLED REPAIR STRAP & FILLER IAW EA 737-57-036045.SDR AALA20140810001Spar · corrodedRIGHT FWD SPAR AT NR 2 BOOST PUMP HAS CORROSION AT LOWER BONDING JUMPER ATTACHMENT. REMOVED CORROSION FROM LOWER BONDING STRAP ATTACHMENT POINT ON SPAR IAW SRM 51-10-02.SDR AALA20140807004Skin · corrodedLOWER WING SKIN HAS CORROSION AT STATION 540 LONGERON 22 RT DRAG LINK. BLENDED CORROSION IAW EA B737-57-035989.SDR AALA20140807003Skin · corrodedLOWER WING SKIN HAS CORROSION AT STATION 540 & LONGERON 22 LT DRAG LINK BLENDED AREA IAW EA B737-57-035989.SDR AALA20140806002Panel · crackedAUXILIARY POWER UNIT INLET PLENUM CEILING PANEL IS CRACKED AT FASTENER HOLE AT CORNER. REPLACED CEILING PANEL IAW AMM 49-15-15.SDR AALA20140806001Angle · crackedAUXILIARY POWER UNIT INLET PLENUM INBD PANEL UPPER ANGLE IS CRACKED. REPLACED UPPER ANGLE ON INBD PLENUM PANEL IAW AMM 49-15-15.SDR AALA20140803002Stiffener · corrodedAUXILIARY POWER UNIT COMPARTMENT, RT STATION 1125 VERTICAL STIFFENER AT AFT SIDE OF INLET CUT OUT IS CORRODED. REPLACED VERTICAL STIFFENER IAW IPC 53-11-01, DWG 148A8650 & SRM 51-10-02.SDR AALA20140808007Angle · crackedAUXILIARY POWER UNIT INLET PLENUM UPPER FWD ANGLE CRACKED. REMOVED, WELDED & INSTALLED ANGLE IAW EA B737-53-036023.SDR AALA20131228003Engine · faultySYR INFLIGHT ORD-BOS. CREW REPORTED LT ENG SHUTDOWN IN FLIGHT DUE TO NO OIL QUANITY INDICATION & NO OIL PRESSURE INDICATION. EMERGENCY DECLARED FLIGHT DIVERTED SYR LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. FLIGHT FERRIED TO LGA FOR FURTHER MASDR AALA20131106001Skin · damagedDAMAGE TO FUSELAGE SKIN FROM STATIONS 807 TO 827 & STRINGERS 24 TO 27 LT. INSTALLED EXTERNAL DOUBLER REPAIR IAW EA B737-53-032267 & SRM 53-00-01-2R REPAIR 1.SDR AALA20130826017Light · defectiveEXIT INDICATOR LIGHT AT LT OVERWING EXIT DOOR DIM. REPLACED EXIT INDICATOR LIGHT AT LT OVERWING EXIT DOOR. OPERATIONS CHECKED NORMAL.SDR AALA20130716016Adiru · inoperativeLOSS OF AIRSPEED INDICATION, SPEED TRIM & AUTO THROTTLE. REPLACED RT AIR DATA INERTIAL REFERENCE UNIT. SYSTEM GROUND CHECKED NORMAL.SDR AALA20130616001Controller · failedPRESSURIZATION LOSS DURING CRUISE. EMERGENCY DESCENT ACCOMPLISHED & O2 MASKS DEPLOYED ON DESCENT. DESCENDING ON THE ARRIVAL CABIN ALT WARNING HORN ALONG WITH CABIN ALT WARNING LIGHT WERE ACTIVE. EMERGENCY DECLARED FLIGHT LANDED MEX WITHOUT INCIDENT. REPLACESDR AALA20121204003Battery Pack · dischargedEMERGENCY LIGHT 1417 IN FIRST CLASS CEILING INOPERATIVE. REPLACED BATTERY PACK IN FORWARD CEILING. OPS CHECK NORMAL.SDR AALA20120902001Pin · pulledAT ROW 25DEF SEAT MOUNTED EMERGENCY LIGHT INOPERATIVE. FOUND PIN AT CONNECTOR IN SIDEWALL AT SEAT IN ROW 25 PULLED OUT OF CONNECTOR. RE-INSTALLED PIN. OPS CHECK NORMAL.
Back to N919AN