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.

N77MS5foot Face Flight Inc Trustee · Wilmington, DEBuilt 1983 · S/N E-2116 N77NBDodson International Parts Inc · Rantoul, KSBuilt 1978 · S/N LJ818 N77NFNate Holyoke Builders Inc · Holden, MEBuilt 2004 · S/N 20800382 N77NGNorthrop Grumman Systems Corp · El Segundo, CABuilt 2016 · S/N FL-1048 N77PGJjo Aero LLC · Keller, TXBuilt 1991 · S/N E-2680 N77PVSalazar Leasing LLC · Yukon, OKBuilt 1980 · S/N LA-68 N77RZRieger Joseph M · Ashland, ORBuilt 2009 · S/N 20800512 N77SFSeneca Foods Corp · Penn Yan, NYBuilt 1996 · S/N 650-7072 N77TGBarron 421 LLC · Newark, DEBuilt 1999 · S/N FL-250 N77VKPontiac Flying LLC · Pontiac, ILBuilt 1970 · S/N E-221 N77WCWest Coast Aircraft Sales LLC · Santa Ana, CABuilt 2001 · S/N FL-327 N77WFKt Aviation LLC · Las Cruces, NMBuilt 1972 · S/N LW-4 N77WMWhiskey Mike Aero LLC · Wilmington, DEBuilt 1986 · S/N LJ-1133 N77XJDavid L Samani Md Inc · Lincoln, NES/N TH-1993 N78Federal Aviation Administration · Oklahoma City, OKBuilt 1988 · S/N FF-13 N780ABEagle Wings Aviation LLC · Canton, MABuilt 1994 · S/N 525-0073 N780BABoeing Aircraft Holding Co · Renton, WABuilt 1990 · S/N 24310 N780CBQuality Liquid Feeds Inc · Dodgeville, WIBuilt 2008 · S/N 560-0790 N780CWCasella Major Account Services LLC · Rutland, VTS/N BB-1924 N780DCAllard Air Services Inc · Scottsdale, AZBuilt 2016 · S/N 525-0910 N780DWBemo23 Assembly LLC · New York, NYBuilt 1998 · S/N 258378 N780FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0277 N780YPack Larry L · Grand Blanc, MIBuilt 1978 · S/N TH-935 N7818RRkn Aviation LLC · Cincinnati, OHBuilt 1968 · S/N E129 N781FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0278 N781HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2004 · S/N BB1854 N78285Umb Bank N A Trustee · Salt Lake City, UTBuilt 2004 · S/N 33452 N782ADLs Aviation LLC · Hattiesburg, MSBuilt 2016 · S/N FL-1073 N782ALAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N BB-1940 N782FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0280 N7835ASouthwest Airlines Co · Dallas, TXBuilt 2005 · S/N 34294 N78379Bottrell John E II · Yukon, OKBuilt 1962 · S/N 500A-1265-88 N783ALAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N BB-1946 N783DLAdams Aviation Services Inc Trustee · Wilmington, DEBuilt 2021 · S/N 525-1075 N783FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0281 N783ZAZair Force One LLC · Mendenhall, MSBuilt 1998 · S/N FL-217 N78438United Airlines Inc · Chicago, ILBuilt 2009 · S/N 33533 N7843ABank Of Utah Trustee · Salt Lake City, UTBuilt 2006 · S/N 35786 N78448United Airlines Inc · Chicago, ILBuilt 2012 · S/N 40003 N7844ABank Of Utah Trustee · Salt Lake City, UTBuilt 2007 · S/N 35118 N7847AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34297 N7848AUmb Bank Na Trustee · Salt Lake City, UTBuilt 2005 · S/N 34298 N784APDaniel C Salas Harvesting Inc · Hanford, CABuilt 2011 · S/N FL-747 N784FEFederal Express Corp · Memphis, TNBuilt 1991 · S/N 208B0282 N784XABank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 33784 N78501United Airlines Inc · Chicago, ILBuilt 2006 · S/N 31602 N78506United Airlines Inc · Chicago, ILBuilt 2006 · S/N 32832 N78509United Airlines Inc · Chicago, ILBuilt 2008 · S/N 31638 N78511United Airlines Inc · Chicago, ILBuilt 2008 · S/N 33459 N78524United Airlines Inc · Chicago, ILBuilt 2010 · S/N 31642

Back to AD 2006-16-18 R1