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.

N8FHIron Sky Capital LLC · Lubbock, TXBuilt 1997 · S/N LJ-1477 N8FJCheap Thrills I LLC · Salida, COBuilt 1969 · S/N E-187 N8FMSky Dawg LLC · Winterville, NCBuilt 1997 · S/N E-3068 N8GALambeth Air LLC · Sitka, AKS/N 421C0842 N8GUAugusta Aviation Inc · Hilton Head Island, SCBuilt 1985 · S/N LJ-1103 N8HTServicetec LLC · Kalamazoo, MIBuilt 1978 · S/N 421C0618 N8KBBiddulph Oldsmobile Inc · Phoenix, AZBuilt 1978 · S/N BB-446 N8LTAviation Enterprises Inc · Marietta, GABuilt 1980 · S/N 173 N8MDDeneb US LLC · Santa Rosa, CABuilt 2024 · S/N FL-1341 N8NAN8na LLC · Atlantic Beach, FLBuilt 1981 · S/N BB-950 N8NGRetail Contracting Group Inc · Oakdale, MNBuilt 1969 · S/N TH-19 N8NXExecutive Aviation Group Inc · Saint Petersburg, FLBuilt 1980 · S/N BB-774 N8RLDumbo Enterprises LLC · West Hartford, CTBuilt 2001 · S/N 525-0429 N8TZTh Aero Services LLC · Leawood, KSBuilt 1983 · S/N E-2076 N8URLoberg Kirk · Jonesboro, ARBuilt 1999 · S/N TH-1917 N8WMBeardog Aviation LLC · Saint Augustine, FLBuilt 1977 · S/N E-1199 N8YMBeechjet Aviation Inc · Marietta, GABuilt 1985 · S/N RJ-04 N8YZFreeman William Joel · Moravian Falls, NCBuilt 1980 · S/N E1608 N9001QSaransor Properties LLC · Eden Prairie, MNBuilt 1970 · S/N TH-57 N900ACTurbo Air Charter LLC · Boise, IDBuilt 1978 · S/N LW282 N900AWBonanza Five Flying Club Inc · Roswell, GABuilt 1990 · S/N E-2524 N900BABillion Air LLC · Sioux Falls, SDBuilt 2009 · S/N FL-636 N900BBNical Aviation LLC · Austin, TXBuilt 1999 · S/N 284 N900CBHnl Group LLC · Minnetonka, MNS/N 421C0837 N900CTRoughneck Supply LLC · Muskogee, OKBuilt 1995 · S/N LJ-1398 N900DSOwens Aviation Inc · Dallas, TXBuilt 1993 · S/N 525-0032 N900DUDelta Air Lines Inc · Atlanta, GABuilt 2018 · S/N 62779 N900DZCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1974 · S/N LJ-618 N900EN900e LLC · Lewes, DEBuilt 1993 · S/N 560-0206 N900JAJ A Aero Inc · Sugar Grove, ILBuilt 2002 · S/N 208B0935 N900JTDbl Flight Services LLC · Dayton, OHBuilt 1982 · S/N 257147 N900KBN900kb LLC · California, MDBuilt 1977 · S/N TH-863 N900LMMiller Aviation LLC · West Palm Beach, FLS/N S550-0145 N900MCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 525-1126 N900MTLincoln Ventures LLC · North Highlands, CABuilt 1983 · S/N LJ1048 N900NXAlva Family Holdings LLC · Fort Denaud, FLBuilt 1976 · S/N TH-723 N900PSAero Air Charter Holding LLC · Pensacola, FLBuilt 1991 · S/N 560-0118 N900TMRed Top Aviation Inc · Martinsville, INBuilt 1978 · S/N E-1302 N900WAWright Air Service Inc · Fairbanks, AKBuilt 1998 · S/N 208B0659 N9016VDowns Richard K · Prospect, KYBuilt 1971 · S/N E-287 N9017VPost60 LLC · Lake Oswego, ORS/N E-274 N901ABAngel Brothers Enterprises Ltd · Baytown, TXBuilt 1995 · S/N 560-0302 N901ANAmerican Airlines Inc · Fort Worth, TXBuilt 1999 · S/N 29503 N901BABismarck Air Medical LLC · Bismarck, NDBuilt 1980 · S/N BB-674 N901CAYurok Tribe Construction Corp · Weaverville, CAS/N 208B5735 N901DDTdbd Holdings LLC · Lexington, NES/N LJ-1726 N901DNBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 32006 N901FFFlightline Holdings II LLC · New Orleans, LABuilt 1980 · S/N BB-637 N901GGLong Bay Partners LLC · Missoula, MTBuilt 2015 · S/N 525-0901 N901JEDodson International Parts Inc · Rantoul, KSBuilt 1982 · S/N LJ-1030

Back to AD 2006-16-18 R1