Registered aircraft · 16,284

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.

N990AMAmerican Asset Leasing LLC · Aurora, ORBuilt 2022 · S/N 2881580 N990BSYanish Ronald L · Goodland, FLBuilt 2004 · S/N 1061 N990CDWertsberger Shalom · Rochester, NYBuilt 2004 · S/N 1087 N990DPCarter Brian · Concord, NCBuilt 2001 · S/N 4697121 N990FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881649 N990GGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 3449481 N990PValli Air LLC · Leonardtown, MDBuilt 2004 · S/N 0945 N990PTMiller High Life Aviation LLC · Charleston, SCBuilt 2023 · S/N 9624 N990SCAb Prop Plane I LLC · Metairie, LABuilt 2025 · S/N 2881877 N990SHAviation Co Inc · Cheyenne, WYBuilt 1976 · S/N BC-12 N9919TFour M Aviation LLC · Saint Petersburg, FLBuilt 1994 · S/N 3213075 N991AArcher Aero LLC · Wilmington, DEBuilt 2015 · S/N 2843807 N991ACXin Han Aviation LLC · Randolph, MABuilt 1979 · S/N 44-8095011 N991AJPc Aviation LLC · Kanarraville, UTBuilt 2006 · S/N 41645 N991ASAero Training Services Inc · Lake City, FLBuilt 1982 · S/N 32R8229019 N991BJSilver Express Co · Miami, FLBuilt 1986 · S/N 28-16008 N991DFMbd Consulting LLC · Pell City, ALBuilt 2006 · S/N 41626 N991FGFlightgest Academy LLC · Morrisville, NCBuilt 2025 · S/N 2881869 N991FPR&R Aces LLC · Bentonville, ARBuilt 2006 · S/N 2155 N991KPSingsee LLC · Ellenton, FLBuilt 2013 · S/N 4697536 N991MMAirstream Co · Saint Louis, MOBuilt 2008 · S/N 4692091 N991PAProp Culture Aviation LLC · Olympia, WABuilt 2008 · S/N 40.921 N991PFBarnstorming Endeavors LLC · Westport, CTBuilt 2025 · S/N 10840 N991PMSandy Herd LLC · Amarillo, TXBuilt 2005 · S/N 1601 N991RACirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11526 N991SESoutheastern Oklahoma State University · Durant, OKBuilt 2022 · S/N 4496543 N991SUAviation Enterprises LLC · Longwood, FLBuilt 1977 · S/N BB-253 N991TALee A Archer Jr Red Tail Youth Flying Program Inc · New Windsor, NYBuilt 2021 · S/N 28020029 N992BZCirrus Skies LLC · St Charles, ILBuilt 2026 · S/N 11387 N992FGFlightgest Academy LLC · Morrisville, NCBuilt 2023 · S/N 2881693 N992KN992k LLC · Napa, CABuilt 2005 · S/N 1600 N992LKIcc Aviation LLC · Belleville, MIBuilt 2003 · S/N 0610 N992MBob Blandford Air LLC · Saint Johns, FLBuilt 2021 · S/N 5049 N992SESoutheastern Oklahoma State University · Durant, OKBuilt 2022 · S/N 4496544 N992XCirrus Design Corp · Duluth, MNS/N 11728 N993ASBig Muddy LLC · Southern Pines, NCBuilt 1981 · S/N 348133036 N993FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881830 N993GAtp Aircraft 9 LLC · Wilmington, DES/N 2881494 N993LLSherpa Aerospace LLC · Tucson, AZBuilt 2006 · S/N 2220 N993MMMccormick Aviation LLC · Madisonville, LABuilt 2007 · S/N 2585 N993SMCharden Aviation LLC · Mount Sterling, KYBuilt 2014 · S/N 4089 N994BDImpatient & Paranoid LLC · Birmingham, ALBuilt 2004 · S/N 3449310 N994CS994 Charlie Sierra Inc · Jacksonville, FLBuilt 1978 · S/N 28-7990089 N994CTUS Framing International LLC · Louisville, KYBuilt 2008 · S/N 3020 N994FGFlightgest Academy LLC · Morrisville, NCBuilt 2024 · S/N 2881831 N994MAFly Stella LLC · Park City, UTBuilt 2009 · S/N 4697394 N994MBAquila Air Charter LLC · Wilmington, DEBuilt 1985 · S/N 28-8590037 N994PMAlpha Dogs Aviation LLC · Powell, OHS/N 1386 N994SBB Squared LLC · Russellville, ARBuilt 2005 · S/N 1364 N995AMPiper Aircraft Inc · Vero Beach, FLS/N 28010117

Back to AD 2008-06-28 R1