OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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:94-20-04-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:94-20-04-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.

N449TSmallwood David · Oak Ridge, TNBuilt 1970 · S/N D-9153N44AWMorrison Charles W · Huntington, TXBuilt 1952 · S/N D-3228N44CMRussell Stephen J · Chester, VTBuilt 1969 · S/N D-8927N44DBSperr David F · Rock Hill, SCBuilt 1959 · S/N D-6074N44DLOdonnell Dennis J · Santa Fe, NMBuilt 1956 · S/N D-4749N44PBMcpeck Adam S · Agar, SDFirst renewal noticeBuilt 1964 · S/N D-7678N44PEJanssen Willis W · Ault, COBuilt 1957 · S/N D-5169N4503DGingell C Thomas · Montrose, COBuilt 1956 · S/N D-4617N4504DBeck John A · Collins, OHS/N D-4665N4506SBaghs LLC · Fort Lauderdale, FLS/N D-9795N4507DRunia Allan D Trustee · Gold Hill, ORS/N D-4667N4508DKvant Holdings LLC · Hallandale Beach, FLBuilt 1956 · S/N D-4679N4509DAviation Dept LLC · Marietta, GABuilt 1956 · S/N D-4661N4511DGage Lewis Trustee · Reno, NVBuilt 1956 · S/N D-4638N4512DLucarelli Gino P · Goose Creek, SCBuilt 1956 · S/N D-4648N4516DG&L Autosport LLC · Whitestown, INBuilt 1956 · S/N D-4687N4517DPlane Fun Inc Tr Trustee · Snellville, GAS/N D-4650N4519DHammons Gordon D · Wilson, WIBuilt 1956 · S/N D-4681N4522DGuy Timothy S · Ennis, MTS/N D-4668N4525DButler Philip E · Wichita, KSBuilt 1956 · S/N D-4692N4528DHopper Phillip L · Phoenix, AZBuilt 1956 · S/N D-4697N4528SMoore William W · Merritt Island, FLBuilt 1975 · S/N D-9799N4529MMetzler Aaron · Otis, COBuilt 1978 · S/N D-10115N452SCBond Jeffrey B · Lebanon, MOBuilt 1975 · S/N D-9771N4532DShort Carl M II · Arrington, TNBuilt 1956 · S/N D-4685N4537DBlech Connor N · Chowchilla, CABuilt 1956 · S/N D-4751N4540DBailey Jerry D · Ardmore, OKBuilt 1956 · S/N D-4716N4541DGastaris Nichlas · Shelby Township, MIBuilt 1956 · S/N D-4722N4542DMathis Mark L · Fremont, CAS/N D-4680N4543DFerguson William Keith · Ocala, FLBuilt 1956 · S/N D-4684N4547DAviation Garage LLC · Farmington, MIS/N D-4677N454RBDan Cox LLC · Troutdale, ORBuilt 1966 · S/N D-8242N4551DSannon Michael R · Fairview, MTBuilt 1956 · S/N D-4704N455KBrooks Donald W · Lumberton, NJBuilt 1967 · S/N D-8440N455RHanusin Mark J · Huntley, ILBuilt 1967 · S/N D-8526N4563DFitzgerald Robert D · Geneva, NYBuilt 1956 · S/N D-4718N4565DNiolet Rene J · Long Beach, MSBuilt 1956 · S/N D-4743N4566DPetersen Mark E · Onawa, IABuilt 1956 · S/N D-4739N4566SWalters G David · Sarasota, FLBuilt 1975 · S/N D-9804N4567DWillis Bernie W · Wasilla, AKBuilt 1956 · S/N D-4729N456CAntique Air Holdings Inc · Wilmington, DEBuilt 1956 · S/N D-4529N456TWestphal Eric R · Conroe, TXBuilt 1974 · S/N D-9625N4570DEspolt Steven R · Kingfisher, OKBuilt 1956 · S/N D-4735N4572AHyden William · Round Rock, TXBuilt 1970 · S/N D-9150N4572DSchiffmacher Richard T · Glendale, AZBuilt 1956 · S/N D-4761N4574DBates James L Jr · Slidell, LABuilt 1956 · S/N D-4757N4574MSweeney Thomas J · Niles, MIBuilt 1978 · S/N D-10118N4576DDjm LLC · Ogallala, NEBuilt 1956 · S/N D-4755N4577DTeed Brad S · Vancouver, WAS/N D-4728N457JNToerner Investments · Findlay, OHBuilt 1975 · S/N D-9807
Back to AD 94-20-04 R2