OpenAirDocs.org
AD 80-04-03 R2

Registered aircraft · 40,473

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:80-04-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:80-04-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.

N507FLSpence 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 17273699N5089RHigh Wing Air Services LLC · Merritt Island, FLBuilt 1974 · S/N 17263327N508BDIron Wings Aviation LLC · Ralph, MIBuilt 1961 · S/N 28-214N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869N50906Aitken & Wilson Aviation LLC · Leesburg, VABuilt 1980 · S/N 17274232N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99N5091717 Leasing LLC · Englewood, COBuilt 1980 · S/N 17274233N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706
Back to AD 80-04-03 R2