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.

N25667Bushnell Alison M · Phelan, CABuilt 1973 · S/N E-468 N25675Todd James Michael · Angleton, TXBuilt 1973 · S/N E-472 N256CPSkymax Aero LLC · Chantilly, VAS/N S550-0033 N256DBNortheastern Gastroenterology Associates Pa · Summit Hill, PABuilt 1998 · S/N E-3081 N256JBBlossman Gas Of North Carolina Inc · Swannanoa, NCBuilt 1998 · S/N 525-0284 N256PMehrlich Rick · Mc Ewen, TNBuilt 1982 · S/N 501-0256 N256RPAfrica Inland Mission International Inc · Peachtree City, GABuilt 1995 · S/N 208B0463 N256VGitsis Nick Trustee · MakatiBuilt 1979 · S/N 151 N25704Arrison Frank J · Doylestown, PABuilt 1973 · S/N E-475 N25705United Airlines Inc · Chicago, ILBuilt 1998 · S/N 28766 N25720Smile Air LLC · Macomb, MIBuilt 1973 · S/N E-479 N25734Gardner Aviation LLC · Hot Springs, ARBuilt 1973 · S/N TH-390 N25798Hayek Investments LLC · Gulf Breeze, FLBuilt 1986 · S/N E-2308 N257GLAlpine Aviation Inc · Provo, UTBuilt 1996 · S/N UE-257 N257PLTavaero Jet Charter Corp · Houston, TXBuilt 1990 · S/N 258167 N257RMRmc Aviation LLC · Klamath Falls, ORBuilt 1998 · S/N 560-0485 N257SJN257sj Aviation Corp · Middletown, DEBuilt 1985 · S/N 55-118 N258AWCobra Aviation Services LLC · Oklahoma City, OKBuilt 1996 · S/N UE258 N258BBGhanimian Zaven · Encino, CABuilt 1977 · S/N TH-892 N258BVBrasil Vida Air Services LLC · Miami, FLS/N 560-0258 N258DTwin Engine Express LLC · Lewes, DEBuilt 1995 · S/N TH-1740 N258JYDodson International Parts Inc · Rantoul, KSS/N E-2343 N258MTK5 Aviation LLC · Lewes, DES/N TH-244 N258NCFidelis Flight Group Inc · Elm Springs, ARBuilt 1978 · S/N TH899 N258RPInternational Air Services Inc Trustee · Carson City, NVBuilt 1994 · S/N TH-1737 N258TNKrause Jason · Glendale, AZBuilt 1988 · S/N TH-1539 N259GCotton Tail Transportation LLC · Singer Island, FLBuilt 1975 · S/N BB-62 N259MMDavidson Bryan H · Sarasota, FLBuilt 1986 · S/N E-2311 N259RHAlliance Aviation Group LLC · Wilmington, DEBuilt 2001 · S/N 258529 N259SCCei Inc · Wilmington, DES/N LW17 N25BGSpearfish LLC · St Peters, MOBuilt 2000 · S/N 525-0363 N25CGMcdonough Aviation LLC · Montgomery, ALBuilt 1978 · S/N E-1297 N25DLTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 525-1419 N25EGGarcia Airways LLC · Virginia Beach, VABuilt 1989 · S/N 650-0167 N25FPEastern Stearman Inc Trustee · Leesburg, VABuilt 1992 · S/N E-2720 N25GRBarrosa LLC · Scottsbluff, NEBuilt 1996 · S/N LJ-1440 N25GZTvpx Aircraft Soultions Trustee · North Salt Lake, UTS/N S550-0011 N25JAPa1 208b-1212 LLC · Fort Lauderdale, FLBuilt 2006 · S/N 208B1212 N25LSBzaviation LLC · Saint Louis, MOBuilt 1994 · S/N E-2838 N25MJHb Flying LLC · Pampa, TXS/N E-3236 N25PJPjs Aviation LLC · Dunn, NCBuilt 2006 · S/N 525-0607 N25QGrant Janice · Friday Harbor, WABuilt 2001 · S/N E-3398 N25STLewis Garry L · Livingston, LABuilt 1982 · S/N 198 N25UPNewsome Jeffery S · Blackwell, OKBuilt 1977 · S/N E-987 N25WCMau Leasing LLC · Newark, DEBuilt 1998 · S/N BB-1640 N25WWRainey Aerial Ag Service Inc · Obion, TNBuilt 1976 · S/N E-842 N25XPRd Airways LLC · Channelview, TXS/N 258572 N260ACBank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 33597 N260AKAlaska Airlines Inc · Seattle, WABuilt 2016 · S/N 36349 N260AMQualitair LLC Trustee · MichelstadtBuilt 1998 · S/N 525-0260

Back to AD 2006-16-18 R1