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.

N731DMartilla Robert W · Washougal, WABuilt 1951 · S/N D-3001N731DFFrisbee Dennis R · Denton, TXBuilt 1963 · S/N D-7267N731MLRomine George · Sahuarita, AZS/N D-10208N7320BHoover Frank J · Upland, CAS/N D-3783N7322BRamon Benjamin · Yuma, AZBuilt 1954 · S/N D-3785N7329BFilkins Joseph M · Norco, CABuilt 1954 · S/N D-3792N732DCastaldi Justin W · Fresno, CABuilt 1953 · S/N D-3408N732GMasterpiece Lc · Deland, FLBuilt 1969 · S/N D-9065N7334BKiesznowski Craig C · Romulus, MIBuilt 1954 · S/N D-3797N7335BWebb Anthony R · Earlsboro, OKS/N D-3798N7338BMonpas Carol A · Novato, CABuilt 1954 · S/N D-3801N733SEWaller Richard E · Marks, MSBuilt 1969 · S/N D-8919N7341BGauntt Drex · Pasco, WABuilt 1954 · S/N D-3804N7344BCojocaru Nick · Crowley, TXBuilt 1954 · S/N D-3807N7347BCatawba Valley Community College Board Of Trste · Hickory, NCS/N D-3810N7350BSievers Bradley M · Rayne, LABuilt 1954 · S/N D-3813N7351BCrosswind Aviation Inc · Oakley, KSS/N D-3814N7352BYu-Ga LLC · Munster, INBuilt 1954 · S/N D-3815N7353BTownsend Patrick O · Stillwater, MNBuilt 1954 · S/N D-3811N7356BMitchell Sharron J · Pewaukee, WIBuilt 1954 · S/N D-3819N735BBLinger Daniel E · Chicago, ILBuilt 1958 · S/N D-5557N735VThomas Stephen · Granbury, TXBuilt 1979 · S/N D-10262N7363BJones N Earl Jr · Coats, NCBuilt 1954 · S/N D-3826N7367RMockingbird Aviation LLC · Wilmington, NCBuilt 1974 · S/N D-9638N7368BSouthwest Aircraft Transportation And Recovery · Norco, CABuilt 1954 · S/N D-3857N7369RDuman Ralph J · Cedarville, MIBuilt 1974 · S/N D-9650N736BStone William T · Stratford, CABuilt 1958 · S/N D-5589N7378BWagner Francis J · Anamoose, NDFirst renewal noticeBuilt 1954 · S/N D-3841N737MBSeven Mike Bravo LLC · Grand Haven, MIBuilt 1961 · S/N D-6764N737VBoka Dale J · Clarkston, MIBuilt 1953 · S/N D-3457N7381BCoffin J Park Jr · Knoxville, TNBuilt 1954 · S/N D-3844N7386BAdams Gregory L · Lake Stevens, WABuilt 1954 · S/N D-3849N7387BMclenaghan Alvin N · Phoenix, AZS/N D-3850N7388BJohnson Carl · Chico, CAS/N D-3871N7389BL And P Air LLC · Lees Summit, MOS/N D-3883N7390BWitthuhn Johnie B · Callaway, NEBuilt 1954 · S/N D-3852N7391REdm Corporation · Nevada, MOBuilt 1974 · S/N D-9651N7394BShepherd Flight Collective LLC · Rockwall, TXBuilt 1954 · S/N D-3851N7395BMaag Dallas N · Nampa, IDBuilt 1954 · S/N D-3856N7396BHulsey Ryan · Cleveland, GABuilt 1954 · S/N D-3872N7397RWest Michael P · Colusa, CABuilt 1974 · S/N D-9654N7398BDixson James S II · Gonzales, TXS/N D-3855N7399BMahoning Co Career & Tech Center · Canfield, OHBuilt 1954 · S/N D-3859N739DSchaak William N · Billings, MTBuilt 1951 · S/N D-3009N739MPArnold Nelson Aviation Inc · Saint Paul, MNBuilt 1965 · S/N D-7817N73AAStorey Malcolm E · Houston, TXBuilt 1961 · S/N D-6656N73DEHill Christopher Michael · Linden, TXBuilt 1976 · S/N D-9909N73RHBradley A Eli Dental Corp · Encinitas, CABuilt 1973 · S/N D-9487N73VBVb Aviation LLC · Mount Pleasant, SCBuilt 1973 · S/N D-9534N741JBBrendel James G · Scottsdale, AZBuilt 1968 · S/N D-8701
Back to AD 94-20-04 R2