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.

N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382N167JWStrittmatter Joseph M · Aubrey, TXBuilt 1968 · S/N D-8792N167TFWhitney David W · Ooltewah, TNBuilt 1967 · S/N D-8472N1684WHaller Philip L · Peoria, AZS/N D-9386N1688WDjm Investments Inc · Menno, SDBuilt 1972 · S/N D-9388N168MNelson Lars C · Anchorage, AKBuilt 1968 · S/N D-8762N168ULeading Edge LLC · Scottsdale, AZBuilt 1969 · S/N D-8986N1690WHarran Patrick · Santa Monica, CABuilt 1972 · S/N D-9391N1693WAntique Endeavors LLC · Missoula, MTBuilt 1972 · S/N D-9389N1695WVon Seggern Robert J · Chesterfield, MOBuilt 1972 · S/N D-9393N1698WLawrence John · Dayton, NVBuilt 1972 · S/N D-9392N16FSGarrett John J IV · Warner Robins, GABuilt 1961 · S/N D-6800N16GMTate Joe D · Eufaula, OKBuilt 1967 · S/N D-8616N16MJHangarfinds LLC · Westminster, COBuilt 1959 · S/N D-6023N1700BJohnson David E · Blair, NEBuilt 1960 · S/N D-6358N1700XRegistered aircraftBuilt 1954 · S/N D-3866N1701WJagz Aviation LLC · Akron, OHS/N D-9394N1703WNeimeier Henry P · Bowling Green, KYBuilt 1971 · S/N D-9303N1708WCassaday Jonathan A · Visalia, CABuilt 1964 · S/N D-7340N170MWilliams John R Jr · Marfa, TXBuilt 1966 · S/N D-8317N1713GRight Away Trucking Inc · Hazlehurst, GABuilt 1962 · S/N D-6939N1717WAdkins Zachary R · Scottsboro, ALBuilt 1972 · S/N D-9368N171HTodd Doug · De Witt, IABuilt 1965 · S/N D-7959N171JTropicaire LLC · Hamilton, MTBuilt 1965 · S/N D-7957N171RPRosales Partners Air LLC · Austin, TXBuilt 1977 · S/N D-10092N171XLifto Patrick J · Miles City, MTBuilt 1962 · S/N D-5857N171YCesarano Billy · Maryville, TNBuilt 1958 · S/N D-5467N1720GRegistration Pending · Kalispell, MTRegistration pending, pending cancellationBuilt 1962 · S/N D-6943N1721GCorlett Samuel E · Fort Worth, TXBuilt 1962 · S/N D-6944N1722TNoldin John · Griffith, INS/N D-7139N1725WEdwards John G · Stoneville, NCS/N D-9400N1728GMeyer Fred F · Hampshire, ILBuilt 1962 · S/N D-6946N172QBonanza N172q LLC · Cedarburg, WIS/N D-7292N172XCisar Matthew Alexander · Eglin Afb, FLS/N D-6766N1733GAlpine Aviation Inc · Mclean, VABuilt 1962 · S/N D-6949N1736WAmbitious Aviation LLC · Newport News, VABuilt 1972 · S/N D-9403N1737BDiaz Juan B III · Portland, ORBuilt 1972 · S/N D-9405N1737GBraly John E · Surprise, AZBuilt 1962 · S/N D-6948N1738GSchneider Joel A · Cerrillos, NMBuilt 1962 · S/N D-6950N173QLively Scott Jacob Charles · Greenbrier, ARBuilt 1964 · S/N D-7350N173TAughenbaugh Timothy A · Iroquois, SDS/N D-8259N1741GPlane Fun Inc Tr Trustee · Snellville, GABuilt 1956 · S/N D-4773N1743WThomas John J · Marana, AZBuilt 1972 · S/N D-9404N1744GWelsh Ayden · Dayton, OHBuilt 1962 · S/N D-6953N1746GFrasier Samuel · Gainesville, FLBuilt 1962 · S/N D-6952N174AFWelch William H Jr · Owosso, MIBuilt 1959 · S/N D-6187N17505Trout Christopher S · Albuquerque, NMBuilt 1977 · S/N D-9966N1750WYounger Benjamin · Narrowsburg, NYBuilt 1972 · S/N D-9406N17516Gillis Alan · Richmond, TXBuilt 1977 · S/N D-9978N17561Demott Andrew Dolphus III · Hernando, FLBuilt 1977 · S/N D-9983
Back to AD 94-20-04 R2