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.

N323RBAvion Flight Services LLC · Rome, GABuilt 2012 · S/N 3906 N323RFProtem Professionals LLC · Miller Place, NYBuilt 2001 · S/N 3257201 N323STCook Edward J · Marathon, FLBuilt 2006 · S/N 3232060 N323TLPrime Aviation Leasing LLC · Westlake, TXBuilt 2014 · S/N 4035 N323WWhitewings Aviation LLC · Milton, GABuilt 2005 · S/N 1509 N323WDDurand Paul C · Osceola, WIBuilt 2006 · S/N 2085 N323YManthei Kurt E · Jacksonville, FLBuilt 2006 · S/N 42539 N3241RJohnson Edward Wayne · Bloxom, VABuilt 1969 · S/N 28R-31023 N3245RA & W Cattle Co · Flippin, ARBuilt 1969 · S/N 28R-31019 N3247RArrowood Bradley W · Winston Salem, NCBuilt 1970 · S/N 28R-31111 N324BRBlue Ridge Aviation Holdings LLC · Boone, NCBuilt 2015 · S/N 4194 N324GIsle Air LLC · Danbury, CTBuilt 1995 · S/N 3246003 N324PATravaille Bernard W Trustee · Manteca, CABuilt 2001 · S/N 3257230 N324RDGood Voyage LLC · Sullivans Island, SCBuilt 2021 · S/N 5134 N324SRThree Bell Aviation LLC · Dallas, TXBuilt 2007 · S/N 2458 N3251GKrebs David A · Lubbock, TXBuilt 1980 · S/N 32R-8029044 N3252QArcher Inc · South Ozone Park, NYBuilt 1977 · S/N 28-7790446 N325A325a LLC · Lecanto, FLBuilt 2006 · S/N 2150 N325AVSilver City Flying Club Inc · New Hartford, CTBuilt 1979 · S/N 28-7990346 N325BKTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2273 N325CALucchesi Vincent · Oakham, MABuilt 1995 · S/N 3246009 N325CLRobin Motorsports And Aviation LLC · Windermere, FLBuilt 2008 · S/N 3061 N325CPRachke Aviation LLC · Gardner, ILBuilt 2008 · S/N 3246 N325EPSea Ray LLC · Tulsa, OKBuilt 2023 · S/N 9208 N325HCHiggins Construction Co Inc · Cornelia, GABuilt 2018 · S/N 2426 N325LAPeregrine Howard Fund V Owner LLC · New Orleans, LABuilt 2019 · S/N 4496487 N325MRDv Group LLC · Clovis, CABuilt 2004 · S/N 4636358 N325PAWelling Roger Trustee · Yorba Linda, CABuilt 2001 · S/N 3257237 N325PZCirrus Design Corp · Duluth, MNS/N 11693 N325SHSsh Aero LLC · Saint Louis, MOBuilt 2022 · S/N 8660 N325SKInternational Air Services Inc Trustee · Carson City, NVBuilt 2005 · S/N 41528 N325SLUnity Air LLC · Carmel, INBuilt 2019 · S/N 2486 N325TCTexas State Technical College · Waco, TXBuilt 2024 · S/N 28020189 N325TPPipmeri LLC · Jacksonville, FLBuilt 2010 · S/N 4697427 N325TSMorning Flight LLC · Woodbridge, VABuilt 2006 · S/N 41589 N325TTSuperior Flying Service LLC · Superior, WIBuilt 1983 · S/N 348333006 N325VTPucciair LLC · Las Vegas, NVBuilt 2022 · S/N 8578 N325ZLipovsky Kevin C · Commerce Township, MIBuilt 2004 · S/N 1407 N326AFSchneider Eric · Paradise, MTS/N 40.986 N326AJVanderloop Equipment Inc · Brillion, WIBuilt 1978 · S/N BB-396 N326AKN326ak LLC · Georgetown, DEBuilt 2009 · S/N 3436 N326CCMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881575 N326CDOshoot Inc · Seabrook Beach, NHBuilt 2009 · S/N 3575 N326CPCirrus-2-Own LLC · Bellaire, TXBuilt 2008 · S/N 3133 N326DCSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2009 · S/N 3517 N326DSKendal Flight Corp · Presto, PABuilt 2004 · S/N 40.377 N326NDNational Training I LLC · Wilmington, DEBuilt 2003 · S/N 4496173 N326RHHerrlin Rodney C · East Hampton, NYBuilt 1979 · S/N 28-8090145 N326RSSchlabach Herman · Belton, TXBuilt 1983 · S/N 441-0326 N326RTPerfect Agreements Leasing Inc · Trabuco Canyon, CABuilt 1979 · S/N BB553

Back to AD 2008-06-28 R1