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.

N1271ZV-Four Ltd · Hudson, OHBuilt 1961 · S/N D-6723N1273SSullivan Stephen G · Mize, MSBuilt 1969 · S/N D-8937N127TBTorongo William Martin · Grayling, MIBuilt 1956 · S/N D-4590N1282ZBrickhouse Aviation LLC · Franklin, TNBuilt 1961 · S/N D-6711N128XHaynes Bruce A · Welches, ORBuilt 1951 · S/N D-2818N1296AN1296a LLC · Asheville, NCBuilt 1969 · S/N D-9030N1298ZShaw Aviation LLC · Greenleaf, IDBuilt 1961 · S/N D-6738N129BTinney William G · Macon, GAS/N D-4433N129XSwarts Robert · Cincinnati, OHBuilt 1967 · S/N D-8586N12BRManning Richard F · Midway, GABuilt 1957 · S/N D-5391N12GBOliver Jonathan F Sr · Waxahachie, TXBuilt 1975 · S/N D-9789N12HMRigsby Robert A · Burien, WABuilt 1956 · S/N D-4740N12KCHeath David A Trustee · Cottonwood, AZBuilt 1965 · S/N D-7867N12PMFlying Bald Eagles Inc · New Lenox, ILBuilt 1964 · S/N D-7514N12RCSkipper Thomas · Coburg, ORS/N D-9308N12TPTravels With Trip LLC · Lewes, DEBuilt 1961 · S/N D-6710N1300ZRosewood Aviation LLC · San Diego, CAS/N D-6808N1303ZCentral Virginia Aviation Inc · North Dinwiddie, VAS/N D-6740N1307ZFerris Dale E · Willsboro, NYS/N D-6742N1308ZDelaney Troy · Lake Ozark, MOBuilt 1961 · S/N D-6743N1314ZGensler Jordan T · Three Lakes, WIBuilt 1961 · S/N D-6746N1316ZN1316zulu LLC · Defiance, OHBuilt 1961 · S/N D-6749N1319ZGood Steven D · Douglas, WYBuilt 1961 · S/N D-6757N131BMillspaugh John · Weatherford, OKBuilt 1955 · S/N D-4436N131DDLife Investors Aviation LLC · Milwaukee, WIBuilt 1982 · S/N D-10393N131MDWoodley Aerial Leasing LLC · Walnut, ILBuilt 1959 · S/N D-5978N1324ZMonson Ryan D · The Woodlands, TXBuilt 1961 · S/N D-6759N1326ZJoseph Casey · Lufkin, TXBuilt 1961 · S/N D-6760N1328ZStewart Ian D · Beaverton, ORBuilt 1961 · S/N D-6761N132YCarr Scott A · Allen, NEBuilt 1954 · S/N D-3861N133LBlair Byron · Ajo, AZBuilt 1952 · S/N D-3300N133QFreeland Christopher G · Brownwood, TXBuilt 1957 · S/N D-5319N1343ZBriscoe Travis L · Archie, MOS/N D-6770N1354ZGallo 12 LLC · Kalispell, MTBuilt 1961 · S/N D-6774N1355ZEnns Nathan G · Shafter, CABuilt 1961 · S/N D-6775N135ABShreds Aircraft LLC · Pittsburgh, PABuilt 1957 · S/N D-5399N135BEJeff Proctor Holding Lc · Park City, UTBuilt 1973 · S/N D-9524N135DWWagner Dennis L · Zionsville, INBuilt 1982 · S/N D-10399N135JAD & K Aviation Inc · Milford, IABuilt 1967 · S/N D-8478N135JLBurhoe Aaron D · Sonora, CABuilt 1955 · S/N D-4419N135PGKom Aviation LLC · Southern Pines, NCS/N D10394N135RRMorse-Ellington Bruce P · Phoenix, MDBuilt 1959 · S/N D-5935N135TBToth Richard Day · Thurmont, MDBuilt 1969 · S/N D-8921N135VBPriori Holdings Inc · Jacksonville, FLS/N D-10263N135WWKarwowski Richard · Battle Ground, WAS/N D-8129N135YSpruill William F · Wyoming, DEBuilt 1953 · S/N D-3535N1362APochwatka Patryk · Treasure Island, FLBuilt 1969 · S/N D-9011N1363ZMccune William D · Tehachapi, CABuilt 1961 · S/N D-6787N1364ZBoerner Dewayne W · Litchfield Park, AZBuilt 1961 · S/N D-6788N136GBHarris Vincent A · Columbus, MSBuilt 1967 · S/N D-8557
Back to AD 94-20-04 R2