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.

N2706ESj Construction Group LLC · New Berlin, ILS/N 1497 N270ARDuffy Kevin · Manchester Center, VTBuilt 2024 · S/N 10138 N270CCEuro 2000 Inc · Merritt Island, FLBuilt 2000 · S/N 28-42070 N270DSCaplinger Daniel J · Williamstown, MAS/N 40.270 N270MLWard John L · Mexia, TXBuilt 2002 · S/N 3257297 N270MWM9 Aviation Ventures LLC · Philadelphia, PABuilt 2003 · S/N 0735 N270PSStevens Air LLC · Prosper, TXS/N 4697395 N270RXTjm Enterprise Group Ltd · Naples, FLBuilt 2023 · S/N 9132 N270SMAims Community College · Greeley, COBuilt 2025 · S/N 2881864 N270SUPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496645 N270WL270wl Aviation LLC · Owensboro, KYBuilt 2023 · S/N 9567 N2711YAnn Arbor Air LLC · Plymouth, MIBuilt 2002 · S/N 1211 N2714CLipcon James P · Stow, MABuilt 2005 · S/N 1393 N271AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881989 N271GArcher Aero LLC · Wilmington, DEBuilt 2019 · S/N 2881114 N271HWPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28020271 N271JBValiair Limited Co Trustee · Casper, WYBuilt 2013 · S/N 4697512 N271MGGeorgia Aviation Authority · Eastman, GABuilt 2021 · S/N 2881453 N271NPJust Plane Stuff Inc · Jackson, MSBuilt 2024 · S/N 10043 N271SGCoco Aircraft Inc · Merritt Island, FLBuilt 2000 · S/N 28-42071 N271SRGriffin James R · Pinedale, WYBuilt 2007 · S/N 2714 N2725NWisconsin Aviation Four Lakes Inc · Madison, WIBuilt 1980 · S/N 441-0190 N2727MFly-N-Style LLC · South Lyon, MIBuilt 1977 · S/N 28-7816303 N2728QDanmick Holdings LLC · Dickson, TNFirst renewal noticeBuilt 1977 · S/N 28-7790416 N272AAirtrade Aviation Corp · Fort Lauderdale, FLNon-citizen corporation, flight hours not reportedS/N 3433161 N272CBCalifornia Baptist University · Riverside, CABuilt 2018 · S/N 2881006 N272CDSegers Ernst E · Pensacola, FLBuilt 2010 · S/N 3541 N272DDelta Delta Aviation LLC · Pickerington, OHBuilt 2021 · S/N 5095 N272DJTousifly LLC · Lancaster, SCBuilt 2023 · S/N 9109 N272DSLbo N272ds LLC · Littleton, COBuilt 2013 · S/N 40.1188 N272GTNfh Aviation LLC · Pikeville, KYS/N 44-7995054 N272HWHot Wings Aviation LLC · Fishers, INBuilt 2026 · S/N 28020272 N272RHLewis Coleman · Dallas, TXBuilt 2008 · S/N 3054 N272SRAircraft Guaranty Corp Trustee · Oklahoma City, OKS/N 1945 N2730PRegistration Pending · Palm Harbor, FLRegistration pendingBuilt 2005 · S/N 41071 N2731MBosn Richard O · Scottsbluff, NEBuilt 1977 · S/N 28-7890265 N273CDEquipment Air Holdings LLC · Chattanooga, TNBuilt 2026 · S/N 11334 N273DSHubin Wilbert N · Kent, OHBuilt 2008 · S/N 40.954 N273DVD&K LLC · Sioux Falls, SDBuilt 2013 · S/N 4024 N273ESTailwinds Aviation LLC · Windham, NHBuilt 2005 · S/N 1609 N273JTFlight Time LLC · Norcross, GABuilt 2026 · S/N 11244 N273NDPurdue Aviation LLC · West Lafayette, INBuilt 2000 · S/N 28-42073 N273NFTrk Management LLC · Punta Gorda, FLBuilt 2016 · S/N 4407 N273RVMev Aviation LLC · Fort Lauderdale, FLBuilt 2021 · S/N 5001 N274CFair18 LLC · Montgomery, ALBuilt 2013 · S/N 4636578 N274DSZimmerman Jacob · Long Island City, NYBuilt 2014 · S/N 40.1196 N274DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010074 N274EFFour Forces Aviation LLC · Princeton, NJBuilt 2024 · S/N 10198 N274ERFlying Vikings Inc · Hayward, CAFirst renewal noticeBuilt 1978 · S/N 44-7995083 N274GCPro Aviation II LLC · Ogden, UTBuilt 1985 · S/N 441-0349

Back to AD 2008-06-28 R1