# Service difficulty reports: N9627R, cancelled Jan 18, 2017 A list on [N9627R, cancelled Jan 18, 2017](https://openairdocs.org/deregistered/N9627R-2017-01-18.md). Matched to this aircraft by N-number and event date, checked against the reported serial number, make and model. Newest first. Page 1 of 2 · 55 reports - [SDR AALA20150421010](https://openairdocs.org/sdr/AALA20150421010.md): Module · failed · Apr 21, 2015 · N9627R · Doug DC983 · Aircraft Fuel Distribution System > FUEL INDICATION READING LESS THAN ANTICIPATED. DIVERTED, EMERGENCY NOT DECLARED, AND LANDING WAS UNEVENTFUL. ACFT REFUELED & DEPARTED. REPLACED STANDARDIZED ELECTRONIC MODULE. - [SDR AALA20150314001](https://openairdocs.org/sdr/AALA20150314001.md): Regulator Valve · faulty · Mar 14, 2015 · N9627R · Doug DC983 · Cabin Cooling System > AIR INTERRUPT, RETURNED & EMER DECLARED. LANDING UNEVENTFUL & ACFT NOT OVERWEIGHT. DURING CLIMB FLIGHT CREW NOTED FUMES & ODOR IN COCKPIT. R & R LT & RT AIR CONDITIONING PRESS REGULATOR VLVS IAW AMM 21-31-01. R & R LT & RT COALESCER BAGS IAW AMM 21-20-02. - [SDR AALA20141208003](https://openairdocs.org/sdr/AALA20141208003.md): Battery Pack · discharged · Dec 5, 2014 · N9627R · Doug DC983 · Emergency Lighting > FOUND AFT CABIN OVERHEAD EMER LIGHTS BY LAVATORIES INOPERATIVE. R & R BATTERY PACK IAW 33-53-00. SYS CHECKED NORMAL. - [SDR AALA20141208002](https://openairdocs.org/sdr/AALA20141208002.md): Battery Pack · discharged · Dec 5, 2014 · N9627R · Doug DC983 · Emergency Lighting > MID CABIN OVERHEAD CEILING EMER LIGHTS INOPERATIVE. R & R BATTERY PACK BF-104 AT ROW 20 IAW AMM 33-53-00. SYS CHECKED NORMAL. - [SDR AALA20141208001](https://openairdocs.org/sdr/AALA20141208001.md): Battery Pack · discharged · Dec 5, 2014 · N9627R · Doug DC983 · Emergency Lighting > FIRST CLASS CABIN OVERHEAD CEILING EMER LIGHTS INOPERATIVE. R & R BATTERY PACK IAW AMM 33-53-00. SYS CHECKED NORMAL. - [SDR AALA20141205005](https://openairdocs.org/sdr/AALA20141205005.md): Unknown · odor · Dec 5, 2014 · N9627R · Doug DC983 · Air Distribution System > AIR INTERRUPT, RETURNED & EMER DECLARED. LANDING UNEVENTFUL. ACFT WAS OVERWEIGHT. DURING CLIMB THROUGH 10,000 FEET A STRONG BURNT RUBBER SMELL WAS REPORTED IN CABIN BUT DISSIPATED QUICKLY. ACCOMPLISHED MCM 21-96-01 WITH NO FINDINGS. R & R BOTH LT & RT AIR - [SDR AALA20140703015](https://openairdocs.org/sdr/AALA20140703015.md): Unknown · odor · Jul 3, 2014 · N9627R · Doug DC983 · Air Distribution System > INFLIGHT FLIGHT ATTENDANTS REPORTED SMOKE ODOR IN AFT CABIN. EMER DECLARED FLIGHT DIVERTED & LANDED WITHOUT INCIDENT. ACFT REMOVED FROM SERVICE. ACCOMPLISHED PACK BURN WITH NO FAULTS FOUND. SYS GND CHECKED NORMAL OPERATION CLOSED. - [SDR AALA20131125014](https://openairdocs.org/sdr/AALA20131125014.md): Shutoff Valve · inoperative · Nov 25, 2013 · N9627R · Doug DC983 · Engine Oil Distribution (Airframe Furnished) > LAS CREW REPORTED RT HAND ENG HIGH OIL TEMPERATURE INDICATION. ACCOMPLISHED QRH & SHUT DOWN RT HAND ENG IN FLIGHT, SINGLE ENG TIME 22 MINUTES. EMERGENCY DECLARED FLIGHT RETURNED LAS LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED AIR FUEL H - [SDR AALA20130910018](https://openairdocs.org/sdr/AALA20130910018.md): Engine · surges · Sep 10, 2013 · N9627R · Doug DC983 · Engine (Turbine/Turboprop) > DFW CREW REPORTED LT ENGINE SURGES FOLLOWED BY ENGINE VALVE LIGHT ILLUMINATED. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED LT HAND ENGINE AT DFW ON 9/12/2013. SYSTEM GROUND CHECKED NORMAL OPERATIO - [SDR AALA20130215006](https://openairdocs.org/sdr/AALA20130215006.md): Generator · failed · Feb 15, 2013 · N9627R · Doug DC983 · AC Generator-Alternator > DFW - CREW REPORTED MULTIPLE INTERMITTANT POWER INTERRUPTIONS FOLLOWED BY RIGHT HAND GENERATOR FAILURE INDICATIONS. EMERGENCY DECLARED FLIGHT RETURNED DFW LANDED WITHOUT INCIDENT. AIRCRAFT REMOVED FROM SERVICE. REPLACED GENERATOR, CONSTANT SPEED DRIVE, OIL - [SDR AALA20120923011](https://openairdocs.org/sdr/AALA20120923011.md): Sense Line · loose · Sep 23, 2012 · N9627R · Doug DC983 · Cabin Pressure Sensor > ORD - CREW REPORTED UNABLE TO PRESSURIZE AIRCRAFT AFTER TAKEOFF. THE OUTFLOW VALVE WAS CLOSED AND LEFT PACK SHOWED 50 ON THE PRESSURE GAUGE. RIGHT PACK WAS ON A PLACARD INOPERATIVE. EMERGENCY DECLARED FLIGHT RETURNED ORD LANDED WITHOUT INCIDENT. AIRCRAFT R - [SDR AALA20110815LGA01](https://openairdocs.org/sdr/AALA20110815LGA01.md): Spring · broken · Aug 14, 2011 · N9627R · Doug DC983 · Emergency Exits > FOUND SPRING BROKEN ON AFT FUSELAGE EMERGENCY EXIT PRESSURE BULKHEAD DOOR ARM ASSEMBLY. REPLACED BROKEN SPRING IAW AMM 53-5302-2. - [SDR AALA20110205TUL03](https://openairdocs.org/sdr/AALA20110205TUL03.md): Frame · cracked · Feb 5, 2011 · N9627R · Doug DC983 · Fuselage Main, Frame > THE 1510 CANT FRAME CRACKED ABOVE LEFT LOWER TAIL CONE LATCH. INSTALLED DOUBLER PER EA MD80-53-015073 1/27/2011. - [SDR AALA20110205TUL02](https://openairdocs.org/sdr/AALA20110205TUL02.md): Cusp Web · corroded · Feb 5, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > CUSP SECTION STATIONS 579 TO 598 CORRODED BEYOND MANUAL LIMITS. INSTALLED NEW SECTION OF CUSP. - [SDR AALA20110203TUL07](https://openairdocs.org/sdr/AALA20110203TUL07.md): Web · corroded · Feb 3, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > CABIN HAS CORROSION IN SUB FLOOR WEBBING BETWEEN AFT SERVICE DOOR OPENING, NUMBER 2 SEAT TRACK AND BETWEEN STATIONS 1136 TO 1174. INSTALLED TITANIUM SPLICE REPAIR DOUBLER PER AARD 53-20-00-16. - [SDR AALA20110203TUL06](https://openairdocs.org/sdr/AALA20110203TUL06.md): Doubler · corroded · Feb 3, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > CABIN - FUSELAGE DOUBLER CORRODED ON TOP OF RIGHT CUSP AT STATION 592. INSTALLED NEW FUSELAGE SPLICE DOUBLER RIGHT STATIONS 585 TO 592 PER SRM 51-30-05. - [SDR AALA20110203TUL05](https://openairdocs.org/sdr/AALA20110203TUL05.md): Cusp Web · damaged · Feb 3, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > SEVERAL DAMAGED HOLES IN LEFT CUSP STATIONS 1089 TO 1098 AT NUMBER 2 SEAT TRACK FLANGE. INSTALLED REPAIR DOUBLER AT LEFT CUSP STATIONS 1080 TO 1098 AT THE NUMBER 2 SEAT TRACK PER AARD 53-20-00-16. - [SDR AALA20110203TUL04](https://openairdocs.org/sdr/AALA20110203TUL04.md): Cusp Web · corroded · Feb 3, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > CORROSION ON BOTTOM SIDE OF RIGHT CUSP STATION 898. INSTALLED CUSP DOUBLER IAW AARD 53-20-00-16 AND SRM 51-30-05. - [SDR AALA20110201TUL01](https://openairdocs.org/sdr/AALA20110201TUL01.md): Seat Track · corroded · Feb 1, 2011 · N9627R · Doug DC983 · Fuselage, Seat/Cargo Attach Fittings > SEAT TRACK NUMBER 4 TOP FLANGE OUT OF LIMITS. SPLICED IN NEW SECTION OF SEAT TRACK PER SRM 51-30-01. - [SDR AALA20110131TUL07](https://openairdocs.org/sdr/AALA20110131TUL07.md): Intercostal · cracked · Jan 31, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > INTERCOSTAL BETWEEN CABIN FLOORBEAMS STATIONS 1287 TO 1309 IS CRACKED. REMOVED CRACKED INTERCOSTAL AND INSTALLED NEW INTERCOSTAL PER AA DRAWING EDK1904, SRM 51-30-05 AND SRM 51-30-02. - [SDR AALA20110131TUL05](https://openairdocs.org/sdr/AALA20110131TUL05.md): Web · corroded · Jan 31, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > WEB AFT OF DOOR OPENING HAS CORROSION LONGERON 26 TO 25 RIGHT. INSTALLED WEB SPLICE DOUBLER PER SRM 51-7-0-04. - [SDR AALA20110131TUL02](https://openairdocs.org/sdr/AALA20110131TUL02.md): Skin · dented · Jan 31, 2011 · N9627R · Doug DC983 · Cargo/Baggage Doors > AFT CARGO DOOR HAS EXCESSIVE DENTS ON EXTERIOR SKIN. REMOVED AND REPLACED EXTERIOR SKIN ON AFT CARGO DOOR PER ESO 80174. - [SDR AALA20110129TUL01](https://openairdocs.org/sdr/AALA20110129TUL01.md): Shear Tie · cracked · Jan 29, 2011 · N9627R · Doug DC983 · Fuselage Internal Mounting Structure > CABIN HAS A CRACK IN FORWARD SHEAR TIE ON RIGHT AFT LAVATORY WALL STATION 1307 ABOVE LONGERON 16. INSTALLED NEW SHEAR TIE PER AARD 51-10-00-5 AND BOEING DRAWING 9912243-543. - [SDR AALA20110128TUL04](https://openairdocs.org/sdr/AALA20110128TUL04.md): Skin · damaged · Jan 28, 2011 · N9627R · Doug DC983 · Cargo/Baggage Doors > MID CARGO DOOR: OUTER SKIN REPAIR HAS HIGH RIVETS AND DENTS, MARKED. INSTALLED OUTER SKIN DOUBLER AT MID CARGO DOOR SRM 52-05 FIGURE 1 SHEET 1. - [SDR AALA20110128TUL03](https://openairdocs.org/sdr/AALA20110128TUL03.md): Cusp Web · corroded · Jan 28, 2011 · N9627R · Doug DC983 · Fuselage Miscellaneous Structure > CORROSION OUT OF LIMITS, LEFT SIDE CUSP, STATION 717. CUT OUT CORRODED AREA AND INSTALLED DOUBLER PER AARD 53-20-00-16. - [SDR AALA20110126TUL18](https://openairdocs.org/sdr/AALA20110126TUL18.md): Skin · dented · Jan 26, 2011 · N9627R · Doug DC983 · Fuselage Main, Plate/Skin > DENT STATION 218 IN RED STRIPE RIGHT SIDE. INSTALLED INTERNAL DOUBLER PER SRM 53-04-00 FIGURE 38 SHEET 20 AND 22. - [SDR AALA20091105TUL04](https://openairdocs.org/sdr/AALA20091105TUL04.md): Frame · cracked · Nov 5, 2009 · N9627R · Doug DC983 · Fuselage Main, Frame > ONE INCH CRACK IN UPPER J-ANGLE, FORWARD SIDE OF FRAME STATION 1418 AT LONGERON 2 LEFT. FABRICATED AND INSTALLED DOUBLER AT FRAME 1418 AND LONGERON 2 LEFT PER ENGINEERING AUTHORIZATION MD80-53-007990. - [SDR AALA20091104TUL14](https://openairdocs.org/sdr/AALA20091104TUL14.md): Fitting · cracked · Nov 4, 2009 · N9627R · Doug DC983 · Fuselage Main, Longeron/Stringer > LONGERON 20 FITTING IS CRACKED AT LOWER FLANGE ABOVE FLAP TRACK RIGHT SIDE. INSTALLED DOUBLER ON LONGERON 20 PER AARD 53-10-00-18 MSR 023198. - [SDR AALA20091103TUL17](https://openairdocs.org/sdr/AALA20091103TUL17.md): Stop Fitting · cracked · Nov 3, 2009 · N9627R · Doug DC983 · Cargo/Baggage Doors > MID CARGO DOOR FORWARD MID STOP CASTING CRACKED. REMOVED AND REPLACED STOP-PAD FITTING PER ESO-80174. - [SDR AALA20091103TUL16](https://openairdocs.org/sdr/AALA20091103TUL16.md): Stop Fitting · cracked · Nov 3, 2009 · N9627R · Doug DC983 · Cargo/Baggage Doors > FORWARD CARGO DOOR AT LOWER DOOR STOP CASTING CRACKED. REMOVED AND REPLACED DOOR-STOP FITTING PER ESO-80174. - [SDR AALA20091103TUL15](https://openairdocs.org/sdr/AALA20091103TUL15.md): Skin · cracked · Nov 3, 2009 · N9627R · Doug DC983 · Fuselage Main, Plate/Skin > APPROXIMATELY 1 INCH CRACK IN FUSELAGE SKIN AT LEFT STATION 1474. STOP DRILLED CRACK AND INSTALLED DOUBLER PER SRM 53-01-00. - [SDR AALA20090720SFO01](https://openairdocs.org/sdr/AALA20090720SFO01.md): Battery Pack · discharged · Jul 19, 2009 · N9627R · Doug DC983 · Emergency Lighting > SFO - OVERHEAD EMERGENCY LIGHTS IN CABIN INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS IN CABIN. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20090720SFO02](https://openairdocs.org/sdr/AALA20090720SFO02.md): Skin · damaged · Jul 14, 2009 · N9627R · Doug DC983 · Fuselage Main, Plate/Skin > FUSELAGE DAMAGED AT STATION 905 BETWEEN LONGERONS RIGHT 2 & RIGHT 5. CUT OUT DAMAGED AREA AND INSTALLED DOUBLER, TRIPLER & FINGER DOUBLERS PER EA MD80-53-006823. - [SDR AALA20072486](https://openairdocs.org/sdr/AALA20072486.md): Flashlight · inoperative · Dec 20, 2007 · N9627R · Doug DC983 · Emergency Equipment > AUS - EMERGENCY FLASHLIGHT AT LEFT NUMBER ONE DOOR INOPERATIVE. REPLACED PORTABLE LIGHT ASSEMBLY AT LEFT NUMBER ONE DOOR. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20071267](https://openairdocs.org/sdr/AALA20071267.md): Control Valve · leaking · Jul 7, 2007 · N9627R · Doug DC983 · Engine Thrust Reverser > SFO ON GROUND T1951/07JUL - AFTER LANDING FLIGHT ATTENDANTS REPORTED SMOKE IN CABIN. TURNED OFF APU BLEED AIR AND SMOKE BEGAN TO DISSIPATE. FOUND THRUST REVERSER HYDRAULIC LEAK AT CONTROL VALVE B NUT. TIGHTENED NUT AND NO LEAKS FOUND. REPLACED APU DUE TO H - [SDR AALA20070011](https://openairdocs.org/sdr/AALA20070011.md): Connector · dirty · Jan 1, 2007 · N9627R · Doug DC983 · Light System Wiring > DFW - AFT EMERGENCY FLOOD LIGHT AT STAIR WELL INOPERATIVE. CLEANED CONNECTOR FOR AFT EMERGENCY FLOOD LIGHT AT STAIR WELL. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20070009](https://openairdocs.org/sdr/AALA20070009.md): Lens · missing · Jan 1, 2007 · N9627R · Doug DC983 · Emergency Lighting > MIA - EMERGENCY LIGHTS AT SEAT ROW 3 MISSING LENS. REPLACED LENS FOR EMERGENCY LIGHTS AT SEAT ROW 3. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20070010](https://openairdocs.org/sdr/AALA20070010.md): Connector · loose · Jan 1, 2007 · N9627R · Doug DC983 · Light System Wiring > DFW - EMERGENCY LIGHT AT OVERWING EXIT SIGN INOPERATIVE. RESEATED CONNECTOR FOR EMERGENCY LIGHT AT OVERWING EXIT SIGN. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20070008](https://openairdocs.org/sdr/AALA20070008.md): Bulb · burned out · Jan 1, 2007 · N9627R · Doug DC983 · Emergency Lighting > DFW - EMERGENCY FLOOD LIGHT IN COCKPIT INOPERATIVE. RELAMPED EMERGENCY FLOOD LIGHT IN COCKPIT. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20060886](https://openairdocs.org/sdr/AALA20060886.md): Battery Pack · inoperative · Oct 18, 2006 · N9627R · Doug DC983 · Emergency Lighting > SFO - EMERGENCY LIGHTS AT RIGHT AND LEFT OVERWING EXIT INOPERATIVE. REPLACED BATTERY PACK FOR EMERGENCY LIGHTS AT RIGHT AND LEFT OVERWING EXIT. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20060885](https://openairdocs.org/sdr/AALA20060885.md): Bulb · inoperative · Oct 18, 2006 · N9627R · Doug DC983 · Emergency Lighting > SFO - EMERGENCY LIGHTS AT CENTER AISLE CEILING AT SEAT ROWS 23, 24, AND 26 INOPERATIVE. RELAMPED EMERGENCY LIGHT AT CENTER AISLE CEILING AT SEAT ROWS 23, 24, AND 26. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20050015](https://openairdocs.org/sdr/AALA20050015.md): Battery Pack · inoperative · Jan 9, 2005 · N9627R · Doug DC983 · Emergency Lighting > BOS - EMERGENCY LIGHTS AT FORWARD AND AFT RAFT STORAGE LOCATION INOPERATIVE. REPLACED BATTERY PACK IN OVERHEAD BIN FOR EMERGENCY LIGHTS AT FORWARD AND AFT RAFT STORAGE LOCATION. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040890](https://openairdocs.org/sdr/AALA20040890.md): Battery Pack · inoperative · Aug 23, 2004 · N9627R · Doug DC983 · Emergency Lighting > DFW - OVERHEAD EMERGENCY LIGHTS AT ROW 29 INOPERATIVE. REPLACED BATTERY PACK FOR OVERHEAD EMERGENCY LIGHTS AT ROW 29. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR AALA20040889](https://openairdocs.org/sdr/AALA20040889.md): Connector · loose · Aug 23, 2004 · N9627R · Doug DC983 · Electrical Connectors > AISLE EMERGENCY EXIT ARROW LIGHT AT FORWARD FIRST CLASS INOPERATIVE. REPINNED CONNECTOR FOR FORWARD EMERGENCY EXIT ARROW LIGHT IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION. (CLOSED) - [SDR AALA20040426](https://openairdocs.org/sdr/AALA20040426.md): Battery Pack · corroded · Apr 4, 2004 · N9627R · Doug DC983 · Emergency Lighting > LGA - CEILING EMERGENCY LIGHTS IN FIRST CLASS INOPERATIVE. CLEANED CORROSION ON NUMBER 2 EMERGENCY BATTERY PACK IN FIRST CLASS. SYSTEM GROUND CHECKED NORMAL OPERATION. - [SDR ZWOA0207101](https://openairdocs.org/sdr/ZWOA0207101.md): Wire · damaged · Jul 9, 2002 · N9627R · Doug DC983 · Emergency Lighting > RIGHT OVERWING FLOOR EGRESS LIGHTS INOP. REPLACED WIRE SECTION AND REPLACED MISSING COVERS. LENS MFG PN 0105607 3015MI-932831/ COVER MFG PN 0105601003 PA57-932841/ WIRE SECTION MFG PN 0105606 0055MI-93289 LAST CHECK C PERFORMED IN STL 11/16/2001. --CLOSED-- - [SDR ZW0A0206301](https://openairdocs.org/sdr/ZW0A0206301.md): Terminal · Jun 13, 2002 · N9627R · Doug DC983 · Emergency Lighting > THE EGRESS LIGHTS WERE INOPERATIVE FROM ROW 26 AFT. REPLACED TERMINAL BOARD THAT MAY HAVE BEEN ACCIDENTLY KICKED BY A PASSENGER. CHECK-C 11-16-01 STL. --CLOSED-- - [SDR ZW0A0109701](https://openairdocs.org/sdr/ZW0A0109701.md): Battery · discharged · Oct 16, 2001 · N9627R · Doug DC983 · Emergency Lighting > BOTH COCKPIT EMERGENCY LIGHTS FAILED TO ILLUMINATE. TIGHTENED WIRE TERMINAL AT B5-23 AND REPLACED THE BATTERIES IN THE POWER SUPPLY. - [SDR ZW0A0105702](https://openairdocs.org/sdr/ZW0A0105702.md): Power Supply · Jul 24, 2001 · N9627R · Doug DC983 · Emergency Lighting > THE EMERGENCY LIGHTS AT THE COCKPIT DOOR STAYED ON WHEN POWER REMOVED. REPLACED THE POWER SUPPLY. CHECK-C 12-17-00 JFK. --CLOSED-- - [SDR ZW0A0104201](https://openairdocs.org/sdr/ZW0A0104201.md): Light · inoperative · Jun 25, 2001 · N9627R · Doug DC983 · Emergency Lighting > THE EXIT LIGHT AT THE FWD EXIT DOOR HAD LENS FALLING OFF, THE COCKPIT CEILING EMERGENCY EXIT LIGHT WAS INOPERATIVE, THE EGRESS EXIT LIGHT AT THE AFT GALLEY DOOR WAS INOPERATIVE, THE EGRESS LIGHT ON THE FLOOR FROM SEAT 30D TO AFT LAV WAS INOPERATIVE, AND THE E Next page: https://openairdocs.org/deregistered/N9627R-2017-01-18/reports.md?page=2 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 = 'N9627R' AND deregistration_id = 'N9627R-2017-01-18' ORDER BY difficulty_date DESC ``` This list as a web page: https://openairdocs.org/deregistered/N9627R-2017-01-18/reports --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.