Registered aircraft · 1,016

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-01-11-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-01-11-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-01-11-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-01-11-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-01-11-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-01-11-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.

N412TFBig Grand Aviation LLC · Jupiter, FLBuilt 2018 · S/N 20800611 N414CYLifesouth Community Blood Centers Inc · Gainesville, FLBuilt 2018 · S/N 208B5452 N415TTT & T Capital Inc · Bangor, MEBuilt 1993 · S/N 208B0365 N41GRRiley Aviation LLC · Wht Sphr Spgs, MTBuilt 2023 · S/N 208B5754 N41TEMaple Aviation LLC · New York, NYBuilt 2016 · S/N 208B5268 N420DZDesert Sand Aircraft Leasing Co Inc · Rosharon, TXBuilt 2001 · S/N 208B0909 N421SYBank Of Utah Trustee · Salt Lake City, UTBuilt 2021 · S/N 208B5636 N424AGDancing On A Dream Inc Trustee · Wilmington, DEBuilt 2008 · S/N 208B2013 N426KMKenmore Air Harbor LLC · Kenmore, WABuilt 1999 · S/N 20800306 N430TXTexas Department Of Public Safety · Austin, TXBuilt 2021 · S/N 20800682 N435MTSouthwest Aviation Solutions LLC · Las Vegas, NVBuilt 2007 · S/N 208B1305 N4365UWright Air Service Inc · Fairbanks, AKBuilt 1991 · S/N 208B0253 N437JPKachemak Bay Flying Service Inc · Huntsville, ALBuilt 2013 · S/N 208B5037 N438JPKalinin Partners LLC · Juneau, AKBuilt 2013 · S/N 208B5038 N4395WRoberts Aviation LLC · Acworth, GABuilt 2019 · S/N 208B5575 N43CW42f LLC · Key West, FLBuilt 1990 · S/N 20800175 N443JPSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2013 · S/N 208B5043 N449PEBank Of Utah Owner Trustee · Salt Lake City, UTS/N 208B5647 N450KPKalinin Partners LLC · Juneau, AKS/N 208B5882 N452TWright Air Service Inc · Fairbanks, AKBuilt 2016 · S/N 208B5304 N454SFPa1 208b-0797 LLC · Fort Lauderdale, FLBuilt 1999 · S/N 208B-0797 N459WMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 208B5428 N4625BMartinaire Aviation LLC · Addison, TXS/N 208B0159 N462JSState Of Iowa · Des Moines, IABuilt 2024 · S/N 208B5817 N463DBThunderhook Air Inc · Brentwood, TNBuilt 2009 · S/N 20800505 N4655BMartinaire Aviation LLC · Addison, TXS/N 208B0160 N4662BRedding Aero Enterprises Inc · Redding, CAS/N 208B0161 N4667BUnited States Department Of State · Melbourne, FLS/N 208B0163 N4674BRedding Aero Enterprises Inc · Redding, CAS/N 208B0165 N4687BMartinaire Aviation LLC · Addison, TXS/N 208B0167 N473TWNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2001 · S/N 208B0894 N477XPParaclete Aviation LLC · Raeford, NCBuilt 2000 · S/N 208B0833 N47CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0033 N485JRGuardian Flight LLC · Lewisville, TXBuilt 1997 · S/N 20800264 N485SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 208B5924 N485YUGen Board Of Global Ministries Of The United Metho · Atlanta, GAS/N 208B0970 N490SATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2026 · S/N 208B5925 N495SASouthern Airways Pacific LLC · Addison, TXBuilt 2026 · S/N 208B5942 N496SASouthern Airways Pacific LLC · Addison, TXBuilt 2026 · S/N 208B5943 N498GGPleasant Aircraft Leasing LLC · Newbury Park, CABuilt 2009 · S/N 208B2118 N501EXFloatsix Leasing LLC · Wilmington, DEBuilt 2013 · S/N 208B5010 N502GVGrant Aviation Inc · Anchorage, AKS/N 208B5249 N503MKJay Bruber LLC · Saint Paul, MNBuilt 2016 · S/N 208B5342 N505GCWilmot Airplane Rentals LLC · Mer Rouge, LABuilt 2013 · S/N 208B5005 N50648Lindsey Aviation Services · Haslet, TXBuilt 1990 · S/N 20800191 N507TXTextron Aviation Inc · Wichita, KSS/N 208B5974 N508BHCity Of Anaheim · Fullerton, CABuilt 2012 · S/N 208B2380 N508RBCirrus 5100 LLC Trustee · Wilmington, DEBuilt 2013 · S/N 208B5008 N508RJBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N 20800315 N509JETwo Percent Aviation LLC · Lewes, DEBuilt 2009 · S/N 20800509

Back to AD 2006-01-11 R1