OpenAirDocs.org
AD 79-10-03 R2

Registered aircraft · 40,396

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:79-10-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:79-10-03-R2')
  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.

N4485FSaunders Raymond C III · Albuquerque, NMBuilt 1976 · S/N 28-7790033N4485TKreigh Kevin M · Auburn, INBuilt 1972 · S/N 28-7225161N4486JHess Garrett J · Fullerton, CABuilt 1967 · S/N 28-22904N4486RAurora Aviation Lc · Pierce City, MOBuilt 1974 · S/N 17263228N44872Allmond Aviation LLC · Peoria, ILBuilt 1977 · S/N 28-7816033N4487KMid Atlantic Air Museum · Reading, PABuilt 1948 · S/N NAV-4-1487N4487PAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1962 · S/N 23-2009N44886Personal Aviation Inc · Poway, CABuilt 1977 · S/N 28-7816038N4488RSmith Byron L · Bourbon, INBuilt 1974 · S/N 17263230N4488XReklis Aviation LLC · Schaumburg, ILBuilt 1975 · S/N 28-7615019N4488ZAlaska Tailwheel LLC · Fairbanks, AKBuilt 1969 · S/N 18-8843N44898Andel Robert M · Milford, CTBuilt 1977 · S/N 28-7816040N4489XFidelis Aviation LLC · Cornelius, NCBuilt 1975 · S/N 28-7690021N4489ZHernandez Michael J · Sterling, AKS/N 18-8845N448CGTurville Gay Ann · Austin, TXS/N 2097N4490ASmith Jeffrey Steven · Fenton, MIBuilt 1956 · S/N 18-4856N4490JAmes Bradley · Bushland, TXBuilt 1967 · S/N 28-22908N4490PWelke Aviation Inc · St James, MIBuilt 1962 · S/N 23-2012N44929Registered aircraftS/N 28-7816044N4492AMerkes Dennis R · Soldotna, AKBuilt 1956 · S/N 18-4861N44931H&R Aircraft Co LLC · Ward, ARBuilt 1977 · S/N 28-7816046N4493FMock Joseph R · Huntsville, TXBuilt 1976 · S/N 28-7715041N4493JBrown Henry T · Cairo, GABuilt 1967 · S/N 28-22911N4493RBarnstormers Inc · Bemidji, MNBuilt 1974 · S/N 17263235N4493ZGates Mary Jill · Anchorage, AKFirst renewal noticeBuilt 1969 · S/N 18-8847N44949Shoreline Aviation Inc · Marshfield, MABuilt 1977 · S/N 28-7816050N4494FBella'S Business LLC · Kalispell, MTBuilt 1959 · S/N 23-1815N4494JAldrich Matthew H · Corinth, TXBuilt 1967 · S/N 28-22913N4494PSimon Mitchell B · Edison, NJBuilt 1961 · S/N 23-2016N4494ZKasemodel Alan D · Billings, MTBuilt 1969 · S/N 18-8848N4495FKitty Tango LLC · Saint Petersburg, FLBuilt 1976 · S/N 28-7790034N4495RKohl James D Trustee · Deerfield, ILBuilt 1974 · S/N 17263237N4495ZDolfi Rick · Sutton, AKBuilt 1969 · S/N 18-8850N44960Falcon Aviation · Clarence Center, NYBuilt 1977 · S/N 28-7890044N4496JOzdogan Brent · Lawrenceville, NJBuilt 1967 · S/N 28-22915N4496PPerez Amaro Angel L · Arecibo, PRBuilt 1960 · S/N 232011N4496XJennings Matthew · Valley Center, CAS/N 28-7690022N4496ZBarnes Rodney L · Mayville, WIBuilt 1969 · S/N 18-8851N44974Fort Guerian · Alachua, FLBuilt 1977 · S/N 28-7816051N44979Archer II Corporation · Marietta, GABuilt 1977 · S/N 28-7890045N4497AMorris Duane E · Wasilla, AKBuilt 1956 · S/N 18-4869N4497JStewarts Aircraft Service · Waynesville, OHBuilt 1967 · S/N 28-22916N4497PMatthews Aviation LLC · Hardinsburg, KYBuilt 1961 · S/N 23-2020N4497RMazurek Drew A · New Haven, CTBuilt 1974 · S/N 17263239N4497XFlight School Inc · Spring, TXBuilt 1975 · S/N 28-7690023N4498JHartshorn James · Las Vegas, NVBuilt 1967 · S/N 28-22919N44996Executive Flyers Inc · Sacramento, CABuilt 1977 · S/N 28-7816054N4499JWiblemo Craig B · Fallbrook, CABuilt 1967 · S/N 28-22920N4499PTls Aviation · Marysville, WABuilt 1961 · S/N 23-2022N4499WUrban James R · Pierre, SDBuilt 1965 · S/N 28-2911
Back to AD 79-10-03 R2