# Service difficulty reports: N199UA, cancelled Nov 7, 2016

A list on [N199UA, cancelled Nov 7, 2016](https://openairdocs.org/deregistered/N199UA-2016-11-07.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 7 · 348 reports

- [SDR O2RR2016FA0000372](https://openairdocs.org/sdr/O2RR2016FA0000372.md): Rod End · corroded · Jun 24, 2016 · N199UA · Boeing 747422 · Aileron Control System
  > DURING FLIGHT CONTROL ACTUATION NOTICED THAT RT INBOARD AILERON DIDN`T MOVE. FURTHER INVESTIGATION SHOWED INBD AILERON POWER CONTROL PACKAGE INSTALLATION PISTON ROD END SEPARATED FROM THE PISTON. CORROSION VISIBLE ON ROD END. SEE PHOTOS.
- [SDR CALA2016040495248](https://openairdocs.org/sdr/CALA2016040495248.md): Light · inoperative · Mar 31, 2016 · N199UA · Boeing 747422 · Emergency Lighting
  > PER A CHECK, SEAT 10 LT, CEILING AISLE EMER EXIT LIGHT INOPERATIVE. REPLACED LIGHT BULB, TESTED OK.
- [SDR CALA2016033195242](https://openairdocs.org/sdr/CALA2016033195242.md): Light · inoperative · Mar 31, 2016 · N199UA · Boeing 747422 · Emergency Lighting
  > PER A CHECK, AISLE CEILING EMER EXIT LIGHT AT 38 LT, INOPERATIVE. REPLACED LAMP. OPERATIONS CHECKED OK.
- [SDR CALA2016033195241](https://openairdocs.org/sdr/CALA2016033195241.md): Light · inoperative · Mar 31, 2016 · N199UA · Boeing 747422 · Emergency Lighting
  > PER A CHECK, DOOR 4R, AFT EXIT SIGN, INOPERATIVE. REPLACED EMER EXIT LIGHT ASSEMBLY. OPERATIONS CHECKED OK.
- [SDR CALA2016033195240](https://openairdocs.org/sdr/CALA2016033195240.md): Light · inoperative · Mar 31, 2016 · N199UA · Boeing 747422 · Emergency Lighting
  > PER A CHECK, MID GALLEY, RT EMER EXIT LIGHT INOPERATIVE. RELAMPED MID GALLEY ONE EACH LL LT OPERATIONS CHECKED OK.
- [SDR CALA2016033195239](https://openairdocs.org/sdr/CALA2016033195239.md): Light · inoperative · Mar 31, 2016 · N199UA · Boeing 747422 · Emergency Lighting
  > PER A CHECK, SEAT EMER EXIT LIGHT ON ROW 45 - 53, AFT GALLEY EMER EXIT LIGHTS, TWO EACH 4L, FWD EXIT SIGN, ALL LT SIDE, ARE INOPERATIVE. REPLACED AFT GALLEY EMER EXIT LIGHT ASSEMBLY. OPERATIONS CHECKED ROW 45 - 53 AFT GALLEY SIDE LIGHTS TWO EACH, 4L FWD EXI
- [SDR CALA2016033195238](https://openairdocs.org/sdr/CALA2016033195238.md): Connector · disconnected · Mar 31, 2016 · N199UA · Boeing 747422 · Light System Wiring
  > PER A CHECK, SEAT 4C, LT AISLE EMER EXIT LIGHT INOPERATIVE. FOUND CONNECTOR AT CEILING PANEL NOT CONNECTED. SECURED CONNECTOR. OPERATIONS CHECKED OK.
- [SDR CALA2016033195237](https://openairdocs.org/sdr/CALA2016033195237.md): Light · inoperative · Mar 31, 2016 · N199UA · Boeing 747422 · Emergency Lighting
  > PER A CHECK, SEAT 3C, AISLE EMER EXIT LIGHT INOPERATIVE, RELAMPED. OPERATIONS CHECKED OK.
- [SDR CALA2015072194149](https://openairdocs.org/sdr/CALA2015072194149.md): Connector · unsecure · Jul 20, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > SEAT EMER EXIT LIGHTS ROWS 54H - 60H INOPERATIVE. SECURED THE EMER EXIT LIGHT CONN BY DOOR 5R. OPERATIONS CHECKED OK.
- [SDR CALA2015072194148](https://openairdocs.org/sdr/CALA2015072194148.md): Connector · unsecure · Jul 20, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > SEAT EMER EXIT LIGHT ON SEAT 52C INOPERATIVE. SECURED CONN ON SEAT LIGHT. OPERATIONS CHECKED GOOD.
- [SDR CALA2015072194147](https://openairdocs.org/sdr/CALA2015072194147.md): Light · inoperative · Jul 20, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > SEAT EMER EXIT LIGHT ON SEAT 50C INOPERATIVE. SECURED CONN ON SEAT LIGHT. OPERATIONS CHECKED GOOD.
- [SDR CALA2015072194146](https://openairdocs.org/sdr/CALA2015072194146.md): Light · inoperative · Jul 20, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > SEAT EMER EXIT LIGHT ON 22C INOPERATIVE. REPLACED SEAT EMER EXIT LIGHT. OPERATIONS CHECKED OK.
- [SDR CALA2015061593914](https://openairdocs.org/sdr/CALA2015061593914.md): Light · inoperative · Jun 11, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > OVER THE WING EMERGENCY EXIT LIGHT 2 RT FWD LIGHTS ARE INOPERATIVE. REPLACED RT FWD OVERWING LIGHT. OPERATIONS CHECKED GOOD.
- [SDR CALA2015061593913](https://openairdocs.org/sdr/CALA2015061593913.md): Battery · discharged · Jun 11, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > OVER THE WING EMER EXIT LIGHT 2 LT FWD ARE INOPERATIVE. REPLACED BATTERY PCN 563-1188 & CHARGER PCN 563-1046 IAW AMM 33-51-04. OPERATIONS CHECKED GOOD IAW AMM33-51-04 PG 207-208. ALSO RELAMPED & CLEANED LAMP SOCKETS.
- [SDR CALA2015061193897](https://openairdocs.org/sdr/CALA2015061193897.md): Connector · unsecure · Jun 10, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > EMERGENCY EXIT LIGHT SEAT 57C IS INOPERATIVE. SECURED LIGHT ASSEMBLY CONNECTOR. OPERATIONS CHECKED OK.
- [SDR CALA2015061193896](https://openairdocs.org/sdr/CALA2015061193896.md): Battery · discharged · Jun 10, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > EMERGENCY EXIT LIGHT SEAT 45H - 53H ARE DIM. REPLACED BATTERY ASSEMBLY AT DOOR 4. OPERATIONS CHECKED OK.
- [SDR CALA2015061193895](https://openairdocs.org/sdr/CALA2015061193895.md): Connector · damaged · Jun 10, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > EMERGENCY EXIT LIGHTS ON 45A-53A ARE ALL DIM. REPAIRED OTHER SEATS LIGHT ASSEMBLY CONNECTOR. ALL LIGHTS ARE WORKING GOOD.
- [SDR CALA2015061193894](https://openairdocs.org/sdr/CALA2015061193894.md): Connector · loose · Jun 10, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > EMERGENCY LIGHT ON SEAT 48C IS INOPERATIVE. SECURED THE CONNECTOR. OPERATIONS CHECKED OK.
- [SDR CALA2015061193893](https://openairdocs.org/sdr/CALA2015061193893.md): Connector · loose · Jun 10, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > EMERGENCY SEAT 33C IS INOPERATIVE. FOUND CONNECTOR LOOSE, RECONNECTED. OPERATIONS CHECKED OK.
- [SDR CALA2015061193892](https://openairdocs.org/sdr/CALA2015061193892.md): Light · inoperative · Jun 10, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > EMERGENCY EXIT LIGHT ON SEAT 43H IS INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPERATIONS CHECKED OK.
- [SDR CALA2015061193891](https://openairdocs.org/sdr/CALA2015061193891.md): Light · inoperative · Jun 10, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > EMERGENCY EXIT LIGHT ON 4A IS INOPERATIVE. REPLACED LIGHT ASSEMBLY. OPERATIONS CHECKED OK.
- [SDR CALA2015042393630](https://openairdocs.org/sdr/CALA2015042393630.md): Skin Panel · worn · Apr 23, 2015 · N199UA · Boeing 747422 · Fuselage Main, Plate/Skin
  > DURING ACCOMPLISHMENT OF EA 5300-01721 REV C OP 04, WEAR WAS FOUND ON THE PN 65B02706-80 SKIN PANEL AT APPROX STATION 2580, STRINGER 3R. THE BLEND OUT EXCEEDED ALLOWABLE LIMITS IN SRM 53-00-01. DAMAGE WAS CUT OUT & A REPAIR DOUBLER INSTALLED IAW ECRA 5330-04
- [SDR CALA2015042393629](https://openairdocs.org/sdr/CALA2015042393629.md): Skin Panel · worn · Apr 23, 2015 · N199UA · Boeing 747422 · Fuselage Main, Plate/Skin
  > DURING ACCOMPLISHMENT OF EA 5300-01721 REV C OP 02, WEAR WAS FOUND ON THE PN 65B02512-35 SKIN PANEL AT APPROX STATION 2589, STRINGER 3L. THE BLEND OUT EXCEEDED ALLOWABLE LIMITS IN SRM 53-00-01. DAMAGE WAS CUT OUT & A REPAIR DOUBLER INSTALLED IAW ECRA 5330-04
- [SDR CALA2015042393628](https://openairdocs.org/sdr/CALA2015042393628.md): Skin · damaged · Apr 23, 2015 · N199UA · Boeing 747422 · Fuselage Main, Plate/Skin
  > FUSE BELLY SKIN BS 520 - 740, STRINGER 44L - 44R HAS PITTING DAMAGE & EXISTING REPAIR DOUBLER BETWEEN BS 620 - 640 & STRINGER 44R - 46R. CF90 48, NOT IAW CURRENT SRM 53-00-01 REPAIR 1. REMOVED, REPLACED DOUBLER & REPAIR SKIN PITTING DAMAGE IAW ECRA 5330-0511
- [SDR CALA2015042393627](https://openairdocs.org/sdr/CALA2015042393627.md): Skin · damaged · Apr 23, 2015 · N199UA · Boeing 747422 · Fuselage Main, Plate/Skin
  > AD 90-25-05, FUS BS 1740 - 1960, STRINGER 46L - 46R BELLY SKIN FOUND PITTING. DAMAGED BELLY SKIN, PITTING DAMAGE REPAIRED IAW ECRA 5330-05103.
- [SDR CALA2015042393626](https://openairdocs.org/sdr/CALA2015042393626.md): Skin · corroded · Apr 23, 2015 · N199UA · Boeing 747422 · Fuselage Main, Plate/Skin
  > CEC COMPARTMENT BS 840 - 860, STRINGER 47L - 47R SKIN CORROSION. SKIN CORROSION REPAIRED IAW ECRA 5330-05102.
- [SDR CALA2015042393635](https://openairdocs.org/sdr/CALA2015042393635.md): Tension Tie · cracked · Apr 21, 2015 · N199UA · Boeing 747422 · Fuselage Miscellaneous Structure
  > MAIN DECK STATION 1220 TENSION TIE RT FRAME DOUBLER UPPER CORNER CRACK FOUND. R & R IAW DWG 65B26275 REV C & 65B6275 & ECRA 5310-06551.
- [SDR CALA2015042393634](https://openairdocs.org/sdr/CALA2015042393634.md): Connector · damaged · Apr 21, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > SEAT 2A - 3A CEILING EMER LIGHT INOPERATIVE. FOUND SEAT 2A - 3A CEILING EMER LIGHT WIRE RECEPTACLE DAMAGED. RECEPTACLE REPLACED & PLUG RECONNECTED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-00 & SWPM 20-72-26.
- [SDR CALA2015042393633](https://openairdocs.org/sdr/CALA2015042393633.md): Light · inoperative · Apr 21, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > L2 DOOR MOUNTED SLIDE LIGHT INOPERATIVE. L2 DOOR MOUNTED SLIDE LIGHT REPLACED. EMER LIGHT OPERATIONAL TEST CARRIED OUT FOUND NORMAL IAW AMM 33-51-05 REV 173 & 33-51-00.
- [SDR CALA2015042393632](https://openairdocs.org/sdr/CALA2015042393632.md): Light · inoperative · Apr 21, 2015 · N199UA · Boeing 767322 · Emergency Lighting
  > L5 DOOR MOUNTED SLIDE LIGHT INOPERATIVE. L5 DOOR MOUNTED SLIDE LIGHT ASSEMBLY REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-00 & 33-51-05.
- [SDR CALA2015042093624](https://openairdocs.org/sdr/CALA2015042093624.md): Light · interference · Apr 19, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > DOOR 5 CREW REST STAIR EMER EXIT SIGN FOUND DIM. EMER EXIT SIGN LAMPS REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-02.
- [SDR CALA2015042093623](https://openairdocs.org/sdr/CALA2015042093623.md): Light · inoperative · Apr 19, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > RIGHT FUSELAGE NR 1 & NR 2 EMER LIGHT FOUND INOPERATIVE. RT FUSELAGE NR 1 & 2 EMER LIGHT BATTERY WIRING CHECK CARRIED OUT & FOUND NORMAL. BATTERY CHARGER FUSE REPLACED, LIGHT LAMPS REPLACED, EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW 33-51-04, 33-51-03 &
- [SDR CALA2015042093620](https://openairdocs.org/sdr/CALA2015042093620.md): Wire · misinstalled · Apr 17, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > RIGHT FUSELAGE NR 3 & 4 EMER LIGHT FOUND INOPERATIVE. WIRING CHECK CARRIED OUT & FOUND NR 4 EMER LIGHT POWER TERMINAL & GND TERMINAL CROSS INSTALLED, TERMINAL REINSTALLED, WIRING RE-CHECKED & FOUND NORMAL. BATTERY CHARGER FUSE REPLACED, LIGHT LAMP REPLACED,
- [SDR CALA2015042093619](https://openairdocs.org/sdr/CALA2015042093619.md): Light · inoperative · Apr 17, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > LEFT FUSELAGE FWD, TWO EACH EMER LIGHT FOUND INOPERATIVE. WIRING CHECK CARRIED OUT & FOUND NORMAL. BATTERY CHARGER FUSE & LIGHT LAMPS REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-04 REV 17 3, AMM 33-51-03 REV 173, AMM 33051-00 REV 173
- [SDR CALA2015042093617](https://openairdocs.org/sdr/CALA2015042093617.md): Floorbeam · cracked · Apr 17, 2015 · N199UA · Boeing 747422 · Fuselage Main, Floor Beam
  > AFT CARGO BS 1560, RBL 20 FLOORBEAM WEB CRACK. AFT CARGO BS 1560, RBL 20 FLOORBEAM WEB CRACK REPAIRED IAW SRM 53-60-07 REP 8 & ECRA 5310-0644 5.
- [SDR CALA2015042093616](https://openairdocs.org/sdr/CALA2015042093616.md): Cable · broken · Apr 17, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > UPPER DECK AFTER AISLE WALL MOUNTED EEL CABLE FOUND BROKEN. UPPER DECK AFTER AISLE WALL MOUNTED EEL CABLES & AFTER LIGHT REPLACED. EEL TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-12 REV 173.
- [SDR CALA2015042093615](https://openairdocs.org/sdr/CALA2015042093615.md): Connector · defective · Apr 17, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > MAIN DECK RT STATION 740 - 780 CEILING EMER LIGHT FOUND INOPERATIVE. MAIN DECK RT STATION 740 - 780 CEILING EMER LIGHT CONNECTOR REPLACED. TEST FOUND NORMAL & CEILING SPEAKER TEST FOUND NORMAL IAW WDM 33-51-31 REV 124, WDM 23-31-42 REV 124, SWPM 20-72-26 REV
- [SDR CALA2015042093614](https://openairdocs.org/sdr/CALA2015042093614.md): Conduit · damaged · Apr 17, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > R1 DOOR EMER LIGHT WIRE PROTECTIVE CONDUIT FOUND DAMAGED. R1 DOOR EMER LIGHT WIRE PROTECTIVE CONDUIT REPLACED & SPRING ADJUSTED. TEST FOUND NORMAL IAW AMM 52-11-01, 33-51-00 REV 173 & WDM 33-51-21 REV 124.
- [SDR CALA2015042093613](https://openairdocs.org/sdr/CALA2015042093613.md): Light · inoperative · Apr 17, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > G1A GALLEY LT WALL MOUNTED EEL FOUND INOPERATIVE. G1A GALLEY LT WALL MOUNTED EEL REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-12 REV 173.
- [SDR CALA2015042093612](https://openairdocs.org/sdr/CALA2015042093612.md): Conduit · broken · Apr 17, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > L1 DOOR EMER LIGHT WIRE PROTECTIVE CONDUIT FOUND BROKEN. L1 DOOR EMER LIGHT WIRE PROTECTIVE CONDUIT REPLACED & SPRING ADJUSTED. TEST FOUND NORMAL IAW AMM 52-11-01 REV 173 AMM 33-51-00 REV 173, WDM 33-51-21 REV 124.
- [SDR CALA2015042093611](https://openairdocs.org/sdr/CALA2015042093611.md): Battery Pack · discharged · Apr 14, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > ZONE D RT SEAT MOUNTED EEL FOUND INOPERATIVE. ZONE D RT SEAT MOUNTED EEL TEST CARRIED OUT AFTER EMER BATTERY PACKS REPLACEMENT. BATTERY PACKS REPLACED BY TASK CARD 8203E4567. THE RESULT FOUND NORMAL IAW AMM 33-51-00 REV 173.
- [SDR CALA2015042093610](https://openairdocs.org/sdr/CALA2015042093610.md): Light · inoperative · Apr 14, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > DOOR 3 LAVATORY CTR & RT LAVATORY MOUNTED EEL FOUND INOPERATIVE. DOOR 3 LAVATORY CTR & RT LAVATORY MOUNTED EEL CABLES & LIGHTS REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-12 REV 173.
- [SDR CALA2015042093609](https://openairdocs.org/sdr/CALA2015042093609.md): Light · inoperative · Apr 14, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > G5 GALLEY LT WALL MOUNTED & FWD WALL MOUNTED EEL FOUND INOPERATIVE. G5 GALLEY LT WALL MOUNTED EEL & FWD WALL MOUNTED EEL CABLES & LT REPLACED. EMER LT TEST CARRIED OUT & FOUND NORMAL IAW 33-51-12 REV 173.
- [SDR CALA2015042093608](https://openairdocs.org/sdr/CALA2015042093608.md): Web · cracked · Apr 14, 2015 · N199UA · Boeing 747422 · Fuselage Miscellaneous Structure
  > MAIN DECK L4 MED FWD CUT OUT WEB AT UPPER AREA FOUND CRACK. CRACK REPAIRED IAW ECRA 5310-06463.
- [SDR CALA2015042093607](https://openairdocs.org/sdr/CALA2015042093607.md): Cable · broken · Apr 14, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > G1 & G1A GALLEY RT WALL MOUNTED EEL CABLE FOUND BROKEN. G1 & G1A GALLEY RT WALL MOUNTED EEL LIGHTS REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-12 REV 173.
- [SDR CALA2015042093606](https://openairdocs.org/sdr/CALA2015042093606.md): Web · cracked · Apr 14, 2015 · N199UA · Boeing 747422 · Fuselage Miscellaneous Structure
  > MAIN DECK L5 DOOR FWD CUT OUT FRAME PANEL FOUND THE WEB CRACKED BETWEEN STRINGER 21L & 22L. MAIN DECK L5 DOOR FWD CUT OUT FRAME PANEL WEB REPAIRED IAW SRM 53-60-15 REP 3 FIG 203 REV 92 & ECRA 5300-02150.
- [SDR CALA2015042093605](https://openairdocs.org/sdr/CALA2015042093605.md): Cable · broken · Apr 12, 2015 · N199UA · Boeing 747422 · Light System Wiring
  > DOOR 5 RT LAVATORY WALL MOUNTED EEL CABLE FOUND BROKEN. DOOR 5 RT LAVATORY WALL MOUNTED EEL CABLES REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-12 REV 173.
- [SDR CALA2015042093604](https://openairdocs.org/sdr/CALA2015042093604.md): Light · inoperative · Apr 12, 2015 · N199UA · Boeing 747422 · Emergency Lighting
  > DOOR 5 LT LAVATORY WALL MOUNTED EEL FOUND INOPERATIVE. DOOR 5 LT LAVATORY WALL MOUNTED EEL CABLES & LIGHT REPLACED. EMER LIGHT TEST CARRIED OUT & FOUND NORMAL IAW AMM 33-51-12 REV 173.
- [SDR CALA2015042093603](https://openairdocs.org/sdr/CALA2015042093603.md): Tension Tie · cracked · Apr 11, 2015 · N199UA · Boeing 747422 · Fuselage Miscellaneous Structure
  > MAIN DECK STATION 1160 TENSION TIE RT FRAME DOUBLER FOUND CRACK. MAIN DECK STATION 1160 TENSION TIE RT FRAME DOUBLER. R & R IAW SRM 51-40-02 REV 92 & SRM 53-40-07 REPAIR 8 REV 92.
- [SDR CALA2015042093602](https://openairdocs.org/sdr/CALA2015042093602.md): Tension Tie · cracked · Apr 11, 2015 · N199UA · Boeing 747422 · Fuselage Miscellaneous Structure
  > TENSION TIE RT STATION 1140 FAILSAFE CHORD CRACK FOUND. TENSION TIE RT STATION 1140 FAILSAFE CHORD REPAIRED IAW EA 5310-05635 OP19 STEP 10 & SRM 53-40-07 REPAIR 10 FIG 201 REV 92.

Next page: https://openairdocs.org/deregistered/N199UA-2016-11-07/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 = 'N199UA' AND deregistration_id = 'N199UA-2016-11-07'
ORDER BY difficulty_date DESC
```

This list as a web page: https://openairdocs.org/deregistered/N199UA-2016-11-07/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, except the copies of manufacturers’ service documents, which belong to their rights holders.
