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.

N321HBYosemite Axe Throwing · North Fork, CABuilt 2015 · S/N 4257 N321HTPartnairs LLC · Lake Charles, LABuilt 2015 · S/N 4246 N321JECapital Affairs West LLC · Helena, MTBuilt 2004 · S/N 40.374 N321JJJayjet Private Aircraft Charter LLC · Swanton, OHBuilt 2004 · S/N 1113 N321KAMid Valley Air LLC · Jessup, PABuilt 2000 · S/N 3257142 N321MAKnox Props Aviation LLC · Cookeville, TNBuilt 2002 · S/N 3257311 N321MTIflyhi Aviation LLC · Sanbornton, NHBuilt 2005 · S/N 1696 N321NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881748 N321NEMaine Instrument Flight · Augusta, MEBuilt 2021 · S/N 2675 N321PFRrsf LLC · Pleasant Grove, UTBuilt 2004 · S/N 40.375 N321PMPilotpros Training LLC · Longview, TXBuilt 2011 · S/N 3827 N321RGIrgun Aviation LLC · Philadelphia, PABuilt 2022 · S/N 8820 N321SETesla Aviation LLC · Mount Pleasant, SCBuilt 2006 · S/N 2089 N321SHFish Kenneth I · West Unity, OHBuilt 1976 · S/N 28-7690333 N321SLSchlachter Drue · Fall River, WIBuilt 2016 · S/N 2325 N321WValiair Limited Company Trustee · Ogden, UTBuilt 2006 · S/N 1727 N321WGCirrus Design Corp · Duluth, MNS/N 11706 N321WRFord Paul · Princeton, NJBuilt 2002 · S/N 0269 N321YHAig Aeronautics LLC · Guaynabo, PRBuilt 2005 · S/N 3257386 N3223TRuano Edwin B · Phoenix, AZBuilt 1978 · S/N 28-7890541 N3225RHansen Duane D · Rockford, ILBuilt 1969 · S/N 28R-31134 N322AMProfessional Pilots LLC · Duluth, MNBuilt 2015 · S/N 4199 N322CARoyal Majesty Aviation LLC · Atlanta, GAS/N 28R-7130013 N322CDGnc Industries Inc · Pocahontas, ARBuilt 2005 · S/N 1272 N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545 N322CWGallagher Maria J · Lakewood Ranch, FLBuilt 2004 · S/N 1098 N322EFRkm Aviation · Lexington, NCBuilt 2021 · S/N 28020031 N322HCClover Park Technical College · Tacoma, WABuilt 1969 · S/N 28R-31096 N322MEMast Enterprises Equipment LLC · South Boston, VABuilt 1989 · S/N 4622064 N322MSMes Fire Investigations Inc · Wilmington, DEBuilt 2009 · S/N 3583 N322MWNiko Aviation Holdings LLC · Kalispell, MTBuilt 2008 · S/N 1969 N322NDUn Aerospace Foundation · Grand Forks, NDBuilt 2024 · S/N 2881749 N322NEJerrys Jet Sf50 LLC · Bowdoin, MEBuilt 2022 · S/N 8840 N322PBellagray LLC · Helotes, TXBuilt 1981 · S/N 441-0274 N322PTMaloy Aviation LLC · Telluride, COBuilt 2008 · S/N 2930 N322TWRegistration Pending · Fairview, NCRegistration pending, pending cancellationBuilt 2002 · S/N 0312 N322WAAlderman & Company Wings LLC · Danbury, CTBuilt 2004 · S/N 0811 N3230QArizona Cassidy E · North Platte, NEBuilt 1977 · S/N 28-7790448 N3231RAll2fly LLC · Atlanta, GABuilt 1969 · S/N 28R-31000 N3238QAttitude And Configuration Indicator LLC · Bedford, TXBuilt 1977 · S/N 28-7716145 N323CD2 Guys Aviation LLC · Okeechobee, FLBuilt 2004 · S/N 1020 N323DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843827 N323FTPudil Zachary Thomas · West St Paul, MNBuilt 2004 · S/N 1432 N323HADale Aviation Inc · Rapid City, SDBuilt 1979 · S/N LW-323 N323HWTriple Romeo Sierra Corp · North Miami, FLBuilt 2021 · S/N 2727 N323JTG Case Elevation LLC · Watertown, MABuilt 2006 · S/N 40.714 N323KCBig Blessing LLC · Saint Louis, MOBuilt 2015 · S/N 4273 N323KGN1234 LLC · Costa Mesa, CABuilt 2020 · S/N 4879 N323MCMsc Partners LLC · College Grove, TNFirst renewal noticeBuilt 2006 · S/N 40.713 N323NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881619

Back to AD 2008-06-28 R1