Registered aircraft · 16,280

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.

N512FACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11564 N512HJN512hj LLC · Miami, FLBuilt 2016 · S/N 4316 N512MACurrie George H III · Fleming Island, FLBuilt 1977 · S/N 28-7716224 N512MMBuckeye Creek Ventures LLC · Belle Plaine, IABuilt 2006 · S/N 4697271 N512MSTiralongo Sebastiano · Weston, FLBuilt 1992 · S/N 2841349 N512PSRegistered aircraftBuilt 2006 · S/N 41581 N512RPVan Bortel Aircraft Inc · Arlington, TXBuilt 2008 · S/N 411084 N512TNexus Air LLC · Williston, NDBuilt 2012 · S/N 4636532 N512TFN408dm LLC · Rye, NYBuilt 2022 · S/N 2881593 N512TRFox And James Inc · Latrobe, PABuilt 2004 · S/N 0993 N512TSOldnettle Jeffrey · Wetumpka, ALBuilt 2007 · S/N 41796 N512USouthern Aircraft Consultancy Inc Trustee · Casper, WYS/N 3213007 N512VDavid Golden Md Inc · Los Angeles, CABuilt 2007 · S/N 41736 N512XPilot Henry LLC · Big Prairie, OHBuilt 2004 · S/N 41041 N513APhillips Kevin · Pompano, FLBuilt 2007 · S/N 40.844 N513AFVee Two Inc · Merritt Island, FLBuilt 2021 · S/N 28020044 N513AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 9523 N513BLWingsleasing LLC · Wichita, KSBuilt 2025 · S/N 2881855 N513CBRl55 LLC · Roslyn Heights, NYS/N 2843030 N513DSTactical Integrated Training Solutions LLC · Colorado Springs, COBuilt 2006 · S/N 40.623 N513DXPiper Aircraft Inc · Vero Beach, FLS/N 28010113 N513MSPark Brian Byung · Anaheim, CABuilt 1992 · S/N 2841347 N513PN513p Aviation LLC · Holden, MABuilt 2025 · S/N 10507 N513PAGwil And Gale Evans LLC · Bend, ORBuilt 2008 · S/N 1974 N513PUBrosemer Kathleen M · Sault Sainte Marie, MIBuilt 1983 · S/N 28-8316098 N513SROdan Aero LLC · Alpharetta, GABuilt 2006 · S/N 2059 N513STAllensworth Timothy Lee · Bladenboro, NCBuilt 2009 · S/N 421019 N513TWGabriel Aviation LLC · Jacksonville, FLBuilt 2015 · S/N 4267 N513WCayuga Aviation LLC · Ithaca, NYBuilt 2007 · S/N 2707 N513XFarina Paul A · Liberty Twp, OHBuilt 2012 · S/N 3886 N513ZPlain Nuts LLC · Dover, DEBuilt 2005 · S/N 1734 N5144XSkywest Leasing Inc · St George, UTBuilt 2001 · S/N 2843430 N51467Ascent Aviation Inc · Van Nuys, CABuilt 1977 · S/N 28-7816290 N5147YN5147y LLC · Andover, MNBuilt 2004 · S/N 0848 N514APa28 Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843752 N514BCCarlton Bradford Robert · Cape Coral, FLS/N 3449308 N514BRJmb Aviation LLC · Iowa City, IABuilt 2004 · S/N 1245 N514CMoore Aviation Inc · Beaver Falls, PABuilt 2010 · S/N 2843684 N514CBAnge LLC · Honolulu, HIBuilt 2004 · S/N 3246224 N514CGFlight Training Aircraft LLC · Wilmington, DEBuilt 2004 · S/N 4496187 N514DTNorth Shore Aviation Inc · Merrick, NYBuilt 2006 · S/N 1972 N514EDFarris Stephen L · Hickory, NCBuilt 2005 · S/N 1420 N514EEMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881577 N514ESBolufe Capital LLC · Miami, FLBuilt 2007 · S/N 3449349 N514PGHeinzelman Brian · Hartland, WIBuilt 2008 · S/N 1981 N514PRClear Prop LLC · Round Rock, TXBuilt 2024 · S/N 10331 N514RMSobre Las Nubes LLC · Cocoa, FLBuilt 2007 · S/N 2843661 N514SMEleven Eleven Aviation LLC · Rockwall, TXBuilt 2005 · S/N 1303 N514SRHarbor Aviation Ltd · Camarillo, CABuilt 2006 · S/N 1873 N514TTWilson Kirk Allan · Phoenix, AZBuilt 2006 · S/N 41612

Back to AD 2008-06-28 R1