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.

N4581DPutnam George · Anchorage, AKBuilt 1956 · S/N D-4762N4581SDaum Jeffrey A · Ocala, FLBuilt 1975 · S/N D-9808N4583DWalkowicz Eddie F Jr · Garland, TXBuilt 1956 · S/N D-4738N4584DZeller Steven · Alpharetta, GABuilt 1956 · S/N D-4746N4585DAmen Nelson P · San Antonio, TXBuilt 1956 · S/N D-4752N4586SEjh Teton Properties LLC · Petaluma, CABuilt 1975 · S/N D-9809N4589PSecurenet Financial LLC · The Villages, FLBuilt 1961 · S/N D-6798N4592DBrown Theodore A · Trivoli, ILS/N D-4760N4593DSale Reported · Cody, WYSale reportedBuilt 1956 · S/N D-4763N4595SHurst Sheldon G IV · Smyrna, GABuilt 1975 · S/N D-9812N4597DEvans Robert K · Anchorage, AKBuilt 1956 · S/N D-4772N4598DMid-State Air Inc · Eaton, NYBuilt 1956 · S/N D-4766N4598MRegistered aircraftS/N D-10121N459TCN459tc LLC · Wray, COBuilt 1972 · S/N D-9328N45DWLaquerre David E · Old Orchard Beach, MEBuilt 1975 · S/N D-9840N45JFFischer Jason Edward · Rochester, MNBuilt 1954 · S/N D-3901N45PSDaly Mark T · Cheyenne, WYBuilt 1953 · S/N D-3696N45TAMichalek Construction Inc · Keosauqua, IABuilt 1966 · S/N D-8252N45XEnglish Gary M · Clermont, FLBuilt 1952 · S/N D-3060N4607DLiposcak Curtis J · Madison, WIBuilt 1956 · S/N D-4800N4608DBraun David · Georgetown, TXBuilt 1956 · S/N D-4835N461Lindeman Rusty · D Hanis, TXBuilt 1952 · S/N D-3378N4612SWooddale Kirby LLC · Edina, MNBuilt 1958 · S/N D5517N4614DRedstar Air Shows Inc · Discovery Bay, CABuilt 1956 · S/N D-4793N4616DBrockman Steven C · Seattle, WABuilt 1956 · S/N D-4784N4619DBovee Timothy L · Wenatchee, WAFirst renewal noticeBuilt 1956 · S/N D-4780N461AJohnson James Michael · Mount Pleasant, SCBuilt 1967 · S/N D-8392N461DAGrave Eugene G · Spencer, INS/N D-8572N461SSRodie James S · Vero Beach, FLBuilt 1956 · S/N D-4795N4620DJwe Aviation LLC · Sugar Hill, GABuilt 1956 · S/N D-4796N4622DWilson Kevin W · Jacksonville, FLS/N D-4787N4626DGoering Ryan I · Prineville, ORBuilt 1956 · S/N D-4779N4627DSheldon Paul T · Saint James, MNBuilt 1956 · S/N D-4785N4628DYester Keith N · Locust Grove, GABuilt 1956 · S/N D-4794N462DMAll In 1 LLC · Watford City, NDBuilt 1961 · S/N D-6848N4634MLearned Doug · Corral De Tierra, CAS/N D-10122N4637ALucky Dog Air LLC · Edmond, OKS/N D-9158N4638DCollett William D · Rydal, GABuilt 1956 · S/N D-4805N463BBV-Tail Solutions LLC · Raleigh, NCS/N D-4857N463KNg Aviation LLC · Dover, DEBuilt 1963 · S/N D-7290N463TCheck 6 LLC · Spearfish, SDBuilt 1963 · S/N D-7083N4644DGarrison Garry L Jr · Lamar, ARBuilt 1956 · S/N D-4839N4645DGoin Jeff W Trustee · Polk City, FLBuilt 1956 · S/N D-4840N4647DWhite Donald W · Mt Vernon, WABuilt 1956 · S/N D-4803N4648DPeet Edward V · Cornwall, VTS/N D-4848N464PGoodgame Richard C · Fort Myers, FLBuilt 1966 · S/N D-8372N4651BGlenbear LLC · Kalispell, MTBuilt 1970 · S/N D-9157N4652DGentle Giant Innovations LLC · Sheridan, WYBuilt 1956 · S/N D-4837N4653DMccauley Leon J Sr · Woodrow, COBuilt 1956 · S/N D-4852N4656DPueringer David F · Brainerd, MNBuilt 1956 · S/N D-4838
Back to AD 94-20-04 R2