OpenAirDocs.org
AD 2008-06-28 R1

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
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.

N362DMRegions Aloft LLC · Brooksville, FLBuilt 2004 · S/N 3257362N362DSKamelia Aviation LLC · Catharpin, VABuilt 2010 · S/N 40.1084N362HEMidamerica Jet Inc · Owensboro, KYBuilt 2002 · S/N 1263N362JBCentral Virginia Aviation Inc · Petersburg, VAS/N 4697050N362JDTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1998 · S/N 2843158N362JVBeaudoin Denis Roland · Rowlett, TXBuilt 2006 · S/N 41693N362MAPiper Aircraft Inc · Vero Beach, FLBuilt 1996 · S/N 4636062N362MDJj Hughes Logistics LLC · Canyon, TXBuilt 2014 · S/N 4126N362MKNorth Star Aviation Inc · Mankato, MNBuilt 2022 · S/N 2881589N362MMFly Second Wind LLC · Penn Yan, NYBuilt 2007 · S/N 1766N362NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2023 · S/N 2881656N362SRAviation Guys LLC · Charleston, WVBuilt 2006 · S/N 1999N36304Capital Aviation II LLC · Bethesda, MDBuilt 1978 · S/N 28-7890504N36355Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1978 · S/N 28-7816630N36358Hans Aviation Inc · Davie, FLBuilt 1978 · S/N 28-7816631N36393Meriden Aviation Center LLC · Meriden, CTS/N 28-7816633N36395Brittle Aviation LLC · Chapel Hill, NCBuilt 1978 · S/N 28-7816634N363ACAig Aeronautics LLC · Guaynabo, PRBuilt 2000 · S/N 3246161N363CTAlpha Mike Aviation LLC · Lakeville, MNBuilt 2015 · S/N 4232N363DBDavid Bishop Productions Inc · West Palm Beach, FLBuilt 2023 · S/N 9124N363DSDonkers Dave · Nerstrand, MNBuilt 2003 · S/N 40.303N363JRAsay 363jr LLC · Lindon, UTBuilt 2008 · S/N 4697355N363KKFisher David J · La Conner, WABuilt 2009 · S/N 3379N363MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881653N363MMChicola Monty · Alexandria, LAS/N 4622007N363NCN363nc Corp Trustee · Wilmington, DEBuilt 2007 · S/N 3449363N363PMFlying Luvbug LLC · Grafton, WIS/N 4368N363SCOcm Aviation LLC · Buckeye, AZBuilt 2004 · S/N 1209N363SRJolly Raymond V · Hillsborough, NJBuilt 2006 · S/N 2226N36400Vlietstra Steven J · Hatley, WIBuilt 1978 · S/N 28-7890511N36409Wire Wonder Inc · New York, NYNon-citizen corporation, flight hours not reportedBuilt 1978 · S/N 28-7816636N36424Fmy Inc · Honolulu, HIBuilt 1978 · S/N 28-7890514N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519N364AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881990N364KNo Plans LLC · Alvord, TXBuilt 2007 · S/N 42557N364MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881654N364STFlight Following LLC · Fayetteville, GABuilt 2005 · S/N 4636364N364ZAlpha Tango Aircraft LLC · Wilmington, DEBuilt 2023 · S/N 2881645N36511Worley Regenna G · Ellijay, GABuilt 1978 · S/N 28-7890520N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522N36583Trident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7816647N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320N365AFFna Aviation LLC · Wakefield, MABuilt 2022 · S/N 8910N365ATMelbourne Flight Training LLC · Melbourne, FLBuilt 2023 · S/N 9288N365JPFlycirrus LLC · Clermont, FLBuilt 2008 · S/N 3010N365KAWorker Bees LLC · Kaukauna, WIS/N 3381
Back to AD 2008-06-28 R1