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.

N5075VSanders Jodie D · Fort Worth, TXS/N VAC-64-76N5075WBores Scott J · Huron, OHS/N 28-84N50762Skyhawk Group · Kent, WABuilt 1974 · S/N 17264213N5076XPalmer Bryce P · Chugiak, AKBuilt 1968 · S/N 140N50771Flying Mermaid LLC · Aiea, HIBuilt 1978 · S/N 17270862N50772Donnelly Jennifer A · Hackettstown, NJBuilt 1971 · S/N 17259947N5077VAdams Ron · Lovell, WYBuilt 1977 · S/N VAC-66-77N5077WSkyport Aviation LLC · Birmingham, IAS/N 28-86N5078BWallace Wayne P · Graham, WABuilt 1989 · S/N 1159N5078PPutnam Andrew L · New Limerick, MEBuilt 1958 · S/N 24-84N5078RBlue Goose Aviation Inc · Polson, MTBuilt 1974 · S/N 17263316N507DTThomas Mark R · Clintondale, NYBuilt 1982 · S/N 6803K-386N507FLSpence Ryan · Chicopee, MABuilt 1971 · S/N 28-7125328N507GLSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1974 · S/N 507N507JMMagdaleno Joseph M II · Reno, NVBuilt 1990 · S/N 1N507LSLansing Community College · Mason, MIBuilt 1983 · S/N ALS001AN507RGMccurdy Paul R · North Falmouth, MABuilt 1995 · S/N 2507N507RHJones Douglas H · Prather, CABuilt 1993 · S/N 20200N5080WMatzke Kevin T · Gilbert, AZBuilt 1961 · S/N 28-89N5080XOber John A · Candor, NYBuilt 1968 · S/N 143N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673N5081VWalker Gregory S · Gypsum, COBuilt 1977 · S/N VAC-70-77N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531N5082PShaw Jeryl V · Arcata, CABuilt 1958 · S/N 24-88N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320N5082VMorton John W · El Segundo, CABuilt 1977 · S/N VAC-71-77N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956N5083VBarth Charles L · Pekin, ILBuilt 1977 · S/N VAC72-77N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957N5085VStumpf Douglas D · Aledo, TXBuilt 1977 · S/N VAC74-77N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324N50873Bastien Peter M · Leesburg, VABuilt 1979 · S/N JR-1N5087JSession Jason E · Higden, ARS/N 17273698N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958N5087WMcgough Craig N · Lancaster, TXBuilt 1961 · S/N 28-96N5087YHansen Dewayne E · Fairbanks, AKBuilt 1962 · S/N 18-7894N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5088RGlacier Equipment LLC · Wasilla, AKBuilt 1974 · S/N 17263326N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343N5089GFlywell Aviation LLC · Bowling Green, KYBuilt 1979 · S/N 17273538N5089JWentzel Ron · Steamboat Springs, COBuilt 1979 · S/N 17273699
Back to AD 79-10-03 R2