Registered aircraft · 16,290

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.

N110BWAtwater David C · Pompano Beach, FLS/N 1538 N110FLMac Air Aviation LLC · Xenia, OHBuilt 2007 · S/N 2813 N110GGo Soar LLC · Highland Village, TXBuilt 1980 · S/N BB-792 N110GGSkyview Aviation LLC · Tracy, CABuilt 2024 · S/N 3449486 N110GKJaws Aviation LLC · Ridgeland, MSBuilt 2017 · S/N 4508 N110LMGo Vertical Aviation LLC · Russellville, ALBuilt 1979 · S/N 28-7990277 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N110STBright Dale A · Limestone, TNBuilt 2005 · S/N 4636373 N110TAHuntress Aviation LLC · Paradise Valley, AZS/N 2015 N110UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1216 N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189 N110WFValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 2621 N110WKCirrus Design Corp · Duluth, MNBuilt 2011 · S/N 2115 N1111MRw Air LLC · Rock Hill, SCBuilt 1982 · S/N 32R-8329010 N1112LGunrunner 15 Air LLC · Hilton Head Island, SCBuilt 2009 · S/N 421017 N11132Triple One 32 LLC · Sergeant Bluff, IABuilt 1995 · S/N 2890230 N1113ULeft Base Aviation LLC · Niagara, WIBuilt 1989 · S/N 2890126 N1118QAscend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716083 N1119CAbc Transportation Co Inc · Bismarck, NDBuilt 2003 · S/N 0487 N111AZ360 LLC · Carson City, NVBuilt 2000 · S/N 28-43311 N111DUAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 2008 · S/N 3138 N111DVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2000 · S/N 4636311 N111EMMccue Inc · Florence, MTBuilt 1985 · S/N 28-8690042 N111ETWings And Wheels II LLC · Parker, COBuilt 2008 · S/N 3270 N111HTRegistered aircraftBuilt 2002 · S/N 0232 N111JAMillennium Falcon 2020 LLC Trustee · Wilmington, DEBuilt 1974 · S/N LW-84 N111MUSag Phoenix LLC · Sagaponack, NYBuilt 2026 · S/N 11397 N111MWSaratoga 181 LLC · Mesa, AZBuilt 2023 · S/N 4636822 N111NEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N 2784 N111PVHenson Builders LLC · Dallas, TXBuilt 1981 · S/N BB-772 N111RCSpiga Aviation Inc Trustee · Wilmington, DEBuilt 2007 · S/N 4697330 N111RTJcec LLC · Washington Tr, UTBuilt 2001 · S/N 1156 N111RWNordo LLC · Kettering, OHS/N 32R-8129064 N111SXJcccs Land And Cattle LLC · Harrisburg, NEBuilt 2000 · S/N 46-36286 N111TCGrady Excavating Inc · Mukilteo, WABuilt 1978 · S/N LW-305 N111TTLand Of Lincoln Aviators LLC · Chicago, ILBuilt 2004 · S/N 0830 N1122EVasey Igor · San Francisco, CABuilt 2000 · S/N 32-57176 N1123XBeacon International Inc · Dover, DES/N 1214 N1126HHead Lewis T · Portland, TNBuilt 1976 · S/N 28-7790286 N1126QGibbs Robbie Douglas · Lacombe, LABuilt 1977 · S/N 28-7790376 N1127RSwan Aviation LLC · Columbia Heights, MNBuilt 2005 · S/N 1510 N112CDRustam Ali Wings Inc Trustee · Wilmington, DEBuilt 2026 · S/N 11457 N112CZDelta Delta Papa LLC · Fort Lauderdale, FLBuilt 1981 · S/N 441-0233 N112HDJackson Larry D · Orlando, FLBuilt 2000 · S/N 46-36260 N112LGAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881907 N112SKCirrus Sr22 4821 Inc Trustee · Wilmington, DEBuilt 2019 · S/N 4821 N112TPHarper Gary B · Fitzgerald, GABuilt 1977 · S/N 28-7716289 N112TRBagdasarian Walter DBA · El Cajon, CABuilt 2010 · S/N 3669 N112UVUtah Valley University · Orem, UTBuilt 2020 · S/N 40.1217 N1131KFirst Properties LLC · Medford, ORBuilt 2007 · S/N 41742

Back to AD 2008-06-28 R1