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.

N11GGGallagher Aviation LLC · Cincinnati, OHBuilt 1959 · S/N D-6184N11GMPlatt Tony E · Riverside, CABuilt 1979 · S/N D-10298N11HTJet X Leasing Inc · Johnson, KSBuilt 1967 · S/N D-8534N11JBFlight Risk Ventures LLC · Missoula, MTBuilt 1971 · S/N D-9234N11JQLosey Charles N Jr · Oneida, TNBuilt 1965 · S/N D-7786N11KSFaulkner Dale R · Burnet, TXBuilt 1969 · S/N D-9017N11RTBraly And Braly Pc · Ada, OKBuilt 1967 · S/N D-8420N11VBRobertson Matthew · Nashville, TNBuilt 1969 · S/N D-9031N11VGSage Aviation LLC · Saint Louis, MOBuilt 1976 · S/N D-9891N1204ZAquila Aero LLC · Denison, TXBuilt 1961 · S/N D-6667N1206ZGlg Properties LLC Series 13 · Bridgeport, TXS/N D-6678N120MPHall William M · Encinitas, CABuilt 1979 · S/N D-10248N120WMLift Enterprises LLC · Lynn Haven, FLBuilt 1955 · S/N D-4260N1218ZHutsell James M · Miamisburg, OHBuilt 1961 · S/N D-6682N121BEKrdm LLC · Fallon, NVS/N D-7920N1222MHagarty Matthew · Coralville, IABuilt 1966 · S/N D-8276N1225ZFree Gregory · Monroe, IABuilt 1961 · S/N D-6692N1228ZPate Ronald E · Hilltop Lakes, TXBuilt 1961 · S/N D-6688N122LDennis Harley E Sr · Cole Camp, MOBuilt 1956 · S/N D-4579N122RRDebold David A · Spring, TXBuilt 1961 · S/N D-6706N122SJDeloof Dion S · Austin, TXBuilt 1963 · S/N D-7118N122SNKinsey Timothy James · La Grange, TXBuilt 1979 · S/N D-10283N122TWJmi Associates LLC · Wilmington, DEBuilt 1975 · S/N D-9794N122VWJk Aviation LLC · Fresno, CAS/N D-6435N1231ZD&J Vtail LLC · Punta Gorda, FLBuilt 1961 · S/N D-6693N1234BSmith Bradley T · Elizabethtown, KYBuilt 1952 · S/N D-3179N1234VFrailey Randy J · Chouteau, OKBuilt 1979 · S/N D-10221N1234ZPage Donald Lee Co Trustee · Mission, TXBuilt 1961 · S/N D-6695N1236ZStackhouse Don E · Saratoga, WYBuilt 1961 · S/N D-6697N123BNickravesh Niknam · Saratoga, CABuilt 1955 · S/N D-4098N123CTPastor Jordan D · Riverside, CABuilt 1967 · S/N D-8590N123DGoodfrey Ronnie · Longview, TXBuilt 1961 · S/N D-6637N123ECJohnson Howard A · Lake Forest Park, WABuilt 1972 · S/N D-9412N123JVDowning Danny L · Kilgore, TXBuilt 1955 · S/N D-4024N123RGChurch Brett L · Whitefish, MTBuilt 1968 · S/N D-8816N1240AAlfa Monkey LLC · Wolfforth, TXBuilt 1969 · S/N D-9028N1241ZFeatherston Jacob Eric · Ferris, TXBuilt 1961 · S/N D-6701N124DRendezvous Island Air LLC · Fort Collins, COS/N 10002N124MNMartin Bobby R · Cleburne, TXS/N D-5287N1255ZKeepem Flying LLC · Oak Point, TXBuilt 1961 · S/N D-6717N125BCrow Jerry W · Louisville, TNBuilt 1955 · S/N D-4405N125PCRegistered aircraftBuilt 1978 · S/N D-10148N125TR Darrell Weaver Enterprises LLC · Moore, OKBuilt 1973 · S/N D-9560N1260ZFaris Isaac · Swartz Creek, MIBuilt 1961 · S/N D-6704N1264ZStellaire Alliance LLC · Fort Worth, TXBuilt 1961 · S/N D-6728N1267ZN1267z LLC · Indianapolis, INBuilt 1961 · S/N D-6707N126HBockman Ltd · Milford, IABuilt 1967 · S/N D-8544N126SAS2 Aviation LLC · Biloxi, MSBuilt 1959 · S/N D5817N126WGN126wg LLC · Oak Brook, ILBuilt 1972 · S/N D-9315N12711Oxman Judith R · Riva, MDBuilt 1965 · S/N D-5834
Back to AD 94-20-04 R2