Registered aircraft · 16,289

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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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:2008-06-28-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.

N1000V1kv LLC · Moultrie, GAS/N 0660 N1003XKap Electric Inc · Sulphur, LAS/N 41748 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100FRQualitair LLC Trustee · MichelstadtBuilt 2003 · S/N 0770 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100JBAirbyars LLC · Spartanburg, SCBuilt 2024 · S/N 10290 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100MJMh Aviation LLC · Glendale, AZBuilt 2007 · S/N 2844 N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186 N100NAInternational Air Services Inc Trustee · Carson City, NVS/N 32R-8013093 N100PXS & R Air LLC · Amarillo, TXBuilt 2004 · S/N 0953 N100PYTbm Flying Lc · Pampa, TXBuilt 1981 · S/N BB-890 N100UVJohn B Bateman · Draper, UTBuilt 2004 · S/N 40.405 N100WMValiair Lc Trustee · Casper, WYBuilt 2005 · S/N 1268 N100XZJjk Aviation LLC · Hartland, WIBuilt 2024 · S/N 10040 N100YYInternational Air Services Inc Trustee · Carson City, NVBuilt 2002 · S/N 1183 N100YZCay Air LLC · North Palm Beach, FLBuilt 2004 · S/N 0814 N100ZWFetch Aviation LLC · Bonita Springs, FLBuilt 2014 · S/N 4086 N10111Psh Leasing LLC · Park City, UTS/N 41739 N1011GInternational Air Services Inc Trustee · Carson City, NVBuilt 2025 · S/N 10795 N1018QLambert Brent · Roanoke, VABuilt 2009 · S/N 421018 N1019KPreferred Flight Management LLC · Goshen, INBuilt 2008 · S/N 421004 N1019PBoondocks Solutions LLC · Tomball, TXS/N 1037 N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232 N101BEOne Bravo Echo LLC · Fernandina Beach, FLBuilt 2011 · S/N 3759 N101CDCharlie Delta Aviation LLC · Marietta, GABuilt 2001 · S/N 0101 N101CEDurocher Alain P · Long Beach, CABuilt 1982 · S/N 32R-8229066 N101FKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2008 · S/N 3027 N101FMN101fm Inc Trustee · Wilmington, DES/N 3433153 N101GWPlan B Air LLC · Lago Vista, TXBuilt 2007 · S/N 2528 N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920 N101JPKrouse Donald E · Weaverville, CABuilt 2002 · S/N 40.218 N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310 N101LLTribeca Aviation LLC · New York, NYBuilt 2000 · S/N 2843367 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 N101MRStick The Landing Aviation LLC · Radford, VABuilt 2006 · S/N 1732 N101MWMaroon Creek LLC · Aspen, COBuilt 2007 · S/N 2823 N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588 N101PMKasper John D · Oxford, ALBuilt 2004 · S/N 42055 N101TKLensing Wayne K · Popular Grove, ILBuilt 1980 · S/N 32R-8029062 N101VMKrowel Nicholas E · Woodstock, GABuilt 2001 · S/N 0109 N101VPN101vp LLC · Ambler, PABuilt 1976 · S/N 28-7790131 N101WCole-Tac LLC · Rapid City, SDBuilt 1980 · S/N 32R-8013087 N101XMMaier Gerard · Hartford, WIBuilt 2004 · S/N 1226 N101ZACirrus Sr22 10117 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10117 N10222Willard Gregory M · Bonita Springs, FLBuilt 2009 · S/N 411141 N1024QDuroc LLC · Watertown, WIBuilt 1977 · S/N 28-7790370 N1024ZAqua Men Service LLC · Temple, GABuilt 2005 · S/N 41097 N1029HRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7790278 N102ADEpic Crew LLC · Fort Worth, TXBuilt 1983 · S/N 4410311

Back to AD 2008-06-28 R1