Registered aircraft · 11,795

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.

N100AGDodson Intl Parts Inc · Rantoul, KSBuilt 2005 · S/N 258747 N100AZNnww Holdings LLC · San Angelo, TXS/N 421C1051 N100BEBemis Manufacturing Co · Sheboygan Falls, WIBuilt 2004 · S/N FL-403 N100BRIsr Aviation LLC · Wilmington, DEBuilt 1981 · S/N LA-116 N100BZHartwell Holdings LLC · Dover, DEBuilt 1984 · S/N FA-32 N100CUJani King Aviation LLC · Addison, TXBuilt 1977 · S/N 104 N100ECMark IV Aviation LLC · Denton, TXBuilt 1990 · S/N FL-4 N100FJAvw Equipment Co Inc · Maywood, ILS/N 118 N100GG1mk Leasing LLC · Lindale, TXBuilt 1977 · S/N 501-0020 N100HLRail Transloading Services LLC · San Antonio, TXBuilt 1997 · S/N 258345 N100HSAir Works Ltd · Wilmington, DES/N E-3506 N100JPAviation Consulting LLC · Ada, MIS/N TH-1683 N100KBExecutive Air Taxi Corp · Bismarck, NDBuilt 1979 · S/N LJ-820 N100KUNion LLC · New Century, KSBuilt 1981 · S/N 183 N100LCozumel Leasing LLC · Wilmington, DEBuilt 1977 · S/N 421C0313 N100MLMl Aviation LLC · Boulder, COBuilt 1972 · S/N TH-249 N100PFPony Express Aviation LLC · Miami Beach, FLBuilt 2000 · S/N 525-0390 N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N100PZAeromotors LLC · St James, MOBuilt 1974 · S/N TH-554 N100QTSouthwest Aviation Inc · Marshall, MNBuilt 1976 · S/N LJ689 N100SYAerodan Aviation LLC · Alpharetta, GABuilt 1990 · S/N 560-0054 N100TWTexas La Flyers LLC · Monroe, LABuilt 1978 · S/N BE-51 N100UXAlpine Aviation Inc · Provo, UTBuilt 1994 · S/N UE-100 N100VReserve Aviation LLC · Dallas, TXBuilt 1978 · S/N LJ-796 N100VQNational Aviation Academy Of Mississippi Inc · Clearwater, FLS/N 140 N100WPTads LLC · Kansas City, KSBuilt 1990 · S/N 560-0073 N100XHBiggs Aircraft Inc · Wellston, OKBuilt 1999 · S/N E-3249 N100YPJk LLC · Ridgeville, SCBuilt 1988 · S/N 222 N10123Sandy Wings LLC · Wilmington, DEBuilt 1971 · S/N 107 N101AJCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 36-008 N101CGGrant Aviation Inc · Anchorage, AKBuilt 2015 · S/N 208B5191 N101GPBankruptcy Services LLC · Wilmington, DEBuilt 2025 · S/N 525-1402 N101JWKorndawg LLC · Johnstown, OHBuilt 2017 · S/N 525-0950 N101KMHolliday Dean M Trustee · Klamath Falls, ORBuilt 1985 · S/N E-2253 N101RRSky High Aviation LLC · Chino, CABuilt 1982 · S/N 5010241 N101RSWillfish LLC · Vero Beach, FLBuilt 2016 · S/N 208B5289 N101SGSe Aviation LLC · Tupelo, MSBuilt 2001 · S/N BB-1785 N101SNGorsuch Aviation LLC · Lancaster, OHBuilt 1981 · S/N BE-118 N101TAHatch Hyrum G · Gilbert, AZBuilt 1977 · S/N 421C0331 N101TNHillsborough County Sheriffs Office · Tampa, FLS/N 20800587 N101USky West Aviation Inc Trustee · Albuquerque, NMBuilt 2001 · S/N 525-0454 N101WYWyoming Department Of Transportation · Cheyenne, WYS/N 560-0620 N101XWJoby Aero Inc · Santa Cruz, CABuilt 1993 · S/N 208B0382 N1021WGreystone Enterprises Inc · Oklahoma City, OKBuilt 1973 · S/N E-401 N1022GWelcome Grove LLC · West Sacramento, CABuilt 2017 · S/N 525-0974 N1026VPa1 208b-0319 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0319 N1027CFacchiano Vincent R · Belvidere, ILS/N E-3010 N1027JMagic Carpet LLC · Wilmington, DES/N 560-0564 N1029YPa1 208b-0325 LLC · Fort Lauderdale, FLBuilt 1992 · S/N 208B0325 N102CCPj Squared LLC · San Antonio, TXBuilt 1972 · S/N E-383

Back to AD 2006-16-18 R1