Registered aircraft · 11,798

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  ORDER BY n_number"

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 n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-16-18-R1')
ORDER BY n_number

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.

N834RMInfinity Properties LLC · Summerset, SDS/N 421C-0834 N834UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-963 N8355Premier Plus Aviation Inc · Fort Pierce, FLBuilt 1979 · S/N 421C0668 N835DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31945 N835MABank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 208B2335 N835NNBank Of Utah Trustee · Salt Lake City, UTBuilt 2010 · S/N 29577 N835UPWheels Up Partners LLC · New York, NYBuilt 2014 · S/N FL-965 N836DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31947 N836EVoss Danielle · Dover, NHBuilt 1982 · S/N E-2059 N836JBReis James C · Lake Ozark, MOBuilt 2000 · S/N E3312 N836LGFly A36 LLC · Browntown, WIBuilt 2001 · S/N E-3405 N836NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31095 N836TPSale Reported · BristolSale reported, pending cancellationBuilt 1984 · S/N E-2124 N836UPKansas State University · Salina, KSBuilt 2014 · S/N FL-966 N8378GPrecision Guidance LLC · Bloomington, ILBuilt 1977 · S/N 421C0310 N837DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31948 N837EGZachariah Craig Powell · Salina, KSS/N E-2467 N837NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 30908 N837PFSoutheastern Red Holdings LLC · Wellington, FLBuilt 2018 · S/N 525-1010 N838BBE D Santos & Associates LLC · Wilmington, DES/N 258301 N838DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31949 N838GVTatonduk Outfitters Ltd DBA · Fairbanks, AKS/N 208B0838 N838NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 31097 N838PSNocom Aviation LLC · Stratford, TXBuilt 1983 · S/N BB-1084 N838UPTj Air Holdings Inc Trustee · Wilmington, DEBuilt 2015 · S/N FL-980 N839DNDelta Air Lines Inc · Atlanta, GABuilt 2015 · S/N 31950 N839MABank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 208B2392 N839NNWilmington Trust Co Trustee · Wilmington, DEBuilt 2010 · S/N 29557 N839SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 42083 N83AVEllis Andrew N · Cocoa Beach, FLBuilt 1983 · S/N TH-1385 N83CTFeliz Belize LLC · Pinetop, AZS/N E-370 N83EPRegistered aircraftBuilt 1989 · S/N 5600021 N83FEG&C Aviation LLC · Wilmington, DEBuilt 1977 · S/N LW-219 N83FNGh Equipment LLC · Dover, DEBuilt 1975 · S/N 007 N83FTR E E Inc · Beaumont, TXBuilt 1998 · S/N BB-1621 N83GGCec Aviaiton Services LLC · Windsor, CABuilt 1983 · S/N E-2101 N83HAFly My Ultra LLC · Sellersburg, INS/N 5600487 N83KACcs Enterprises LLC · Maryville, TNBuilt 1983 · S/N BB-1111 N83KBTechnology Service Corp · Arlington, VABuilt 2008 · S/N FL-616 N83KEAirtrex Registration Corp Trustee · Wichita, KSS/N FL-436 N83KKLowe Aviation Co · Macon, GABuilt 1996 · S/N TH-1781 N83MDFielding William · Delray Beach, FLS/N NA0286 N83PWMotion Skies LLC · Rocky Mount, NCBuilt 1987 · S/N BB-1283 N83RWEhr Ventures LLC · Jourdanton, TXBuilt 1991 · S/N LJ-1271 N83TYTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1999 · S/N 288 N83WEMiner'S Inc · Hermantown, MNBuilt 1978 · S/N LW-289 N83WTTurrentine Mark W Md · Indianapolis, INBuilt 1993 · S/N E-2802 N83ZAOp Partner Inc · Odessa, TXBuilt 1992 · S/N 5600176 N84Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-19 N8401ACommercial Property Services Group LLC · Wichita, KSBuilt 1977 · S/N 421C0443

Back to AD 2006-16-18 R1