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.

N4648SKoehn Danny · Montezuma, KSBuilt 1975 · S/N E-767 N464ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 40714 N464BHPajarito Investments LLC · Salt Lake City, UTBuilt 2014 · S/N 525-0858 N464DCDelta Charlie Aviation LLC · Glendale, AZBuilt 1979 · S/N 421C0709 N464MCAtlas Air Inc · Purchase, NYBuilt 1992 · S/N 26341 N4651SScranton Christian · Walnut Creek, CABuilt 1975 · S/N E-766 N4655BMartinaire Aviation LLC · Addison, TXS/N 208B0160 N4657ATessos Air Service Inc · Wilmington, DES/N TH-41 N465BKDodson International Parts Inc · Rantoul, KSS/N BB-382 N465JKDodeca Resources Inc · Henderson, NVBuilt 2017 · S/N 525-0949 N465MCAtlas Air Inc · Purchase, NYBuilt 1990 · S/N 24784 N465SAGilmore Air LLC · Boca Raton, FLBuilt 2002 · S/N E-3465 N465TASouthwest Aviation Specialties LLC · Tulsa, OKS/N LJ630 N465TWSierra American Corp · Wilmington, DES/N 23465 N4661MF & W Aviation Co LLC · Wilmington, DEBuilt 1978 · S/N E-1249 N4662BRedding Aero Enterprises Inc · Redding, CAS/N 208B0161 N4667BUnited States Department Of State · Melbourne, FLS/N 208B0163 N4668MBeechcraft Heritage Museum · Tullahoma, TNBuilt 1978 · S/N E-1252 N466JWWf Construction Inc · La Verne, CAS/N 421C0241 N466MW1977 Holdings LLC · Visalia, CABuilt 1987 · S/N BB-1273 N466YAZimin Transportation LLC · South Naknek, AKS/N FL-662 N4673SGear Up Aviation LLC · Yukon, OKBuilt 1975 · S/N E-768 N4674BRedding Aero Enterprises Inc · Redding, CAS/N 208B0165 N4678AIflyjctc82 LLC · Macomb, ILBuilt 1970 · S/N E-229 N467AMBank Of Utah Trustee · Salt Lake City, UTBuilt 1984 · S/N 441 N467ASAlaska Airlines Inc · Seatac, WABuilt 2014 · S/N 36362 N467TWSierra American Corp · Wilmington, DES/N 23466 N4687BMartinaire Aviation LLC · Addison, TXS/N 208B0167 N4687KNova Aviation LLC · Kemah, TXBuilt 2025 · S/N 525-1185 N468ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 41735 N468BCassels William E · Phoenix, AZBuilt 1947 · S/N D-1120 N468ESAir Roc Group LLC · Canandaigua, NYBuilt 1990 · S/N 650-0185 N468PN Fl Servicing LLC · Santa Rosa Beach, FLBuilt 2000 · S/N TH-1965 N468SPPacific Mission Aviation · Hagatna, GUBuilt 1998 · S/N BB1639 N469ASAlaska Airlines Inc · Seattle, WABuilt 2014 · S/N 41702 N469BUnited States Construction Corporation · Pompano Beach, FLBuilt 1978 · S/N LJ-803 N469CJHerndon Aviation LLC · Kokomo, INBuilt 1980 · S/N 421C1018 N469DNAerosam Equipment LLC · Beaver, PABuilt 1998 · S/N 560-0469 N469ESRickman Joby · Lipan, TXBuilt 1995 · S/N 560-0311 N469RJDodson International Parts Inc · Rantoul, KSBuilt 1986 · S/N 258067 N469SLAngely Air LLC · Lewes, DEBuilt 1982 · S/N BB-1036 N469TSDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 1968 · S/N 149 N46AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N LJ-1582 N46BRCds Aviation Consulting LLC · Dover, DEBuilt 1981 · S/N BB-852 N46CECentury Equipment Company Inc · Salt Lake City, UTBuilt 1994 · S/N BB1492 N46CPKtas LLC · New York, NYS/N E-2430 N46CVSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1972 · S/N LJ-568 N46DMEdwards John Guerrant · Stoneville, NCBuilt 1979 · S/N TH-1048 N46EWLexington Turbo LLC · Southborough, MABuilt 2013 · S/N 525-0802 N46HW2j2g LLC · Wilmington, DES/N TH-2119

Back to AD 2006-16-18 R1