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.

N17568Chance Research Corp · Mineral Wells, TXBuilt 1977 · S/N D-9984N1756WIverson Bradley · Grinnell, IABuilt 1972 · S/N D-9409N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259N17629Haven Av LLC · New Braunfels, TXBuilt 1977 · S/N D-9991N1762WWillis Frederick A · Scottsdale, AZS/N D-9410N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995N1765GGivens Thomas A · Southern Pines, NCBuilt 1962 · S/N D-6964N176BRegier Tom · Dinuba, CAS/N D-4509N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004N17797Nieman James Lewis Jr · Alhambra, CABuilt 1977 · S/N D-10010N177WTBucey Barry E · Visalia, CAS/N D-6300N17814Sellers Scott · Solsberry, INBuilt 1978 · S/N D-10144N17816Legal Flying Service Inc · Pembroke Pines, FLBuilt 1977 · S/N D-10011N1781GPinegar Aviation Services LLC · Ridgeland, SCBuilt 1962 · S/N D-6932N17827Cumins Douglas · Mechanicsville, VABuilt 1977 · S/N D-10015N17840Es Investments LLC · Chandler, AZS/N D-10017N17865Wcs Inc · Troy, ALBuilt 1977 · S/N D-10021N1787ZWashington Arron M · Mobile, ALS/N D6464N1788GTolbert Morgan Leslie · Bernardsville, NJBuilt 1962 · S/N D-6978N178QRega Consulting Inc · Port Orange, FLBuilt 1964 · S/N D-7560N1792GHelminiak Jon · Milwaukee, WIBuilt 1962 · S/N D-6976N1795GProps2jets LLC · Bolingbrook, ILBuilt 1962 · S/N D-6977N1797GTabor Tobey R · Ventura, CABuilt 1962 · S/N D-6975N17988Gonneville Donald E Jr · Durango, COBuilt 1977 · S/N D-10026N179KDTblc LLC · Princeton, NJBuilt 1967 · S/N D-8519N179RMyers Aviation Inc · Oshkosh, WIBuilt 1978 · S/N D-10179N17CBCygnet Aerospace Corp · Los Osos, CABuilt 1966 · S/N D-8232N17CCReinhart Alan · Ventura, CABuilt 1969 · S/N D-9087N17FECox Matthew B · Russiaville, INBuilt 1979 · S/N D-10280N17MABearden James D · West Point, MSS/N D-7529N17PKSmith Kevin B · Camden, NCBuilt 1964 · S/N D-7515N17VMPayne Jerry L · Baton Rouge, LABuilt 1973 · S/N D-9515N17WFDraper Russell E · Camarillo, CABuilt 1978 · S/N D-10191N1803LNielsen James I · Waddell, AZBuilt 1976 · S/N D-9871N1803WCooper Properties Inc · Denver, COBuilt 1972 · S/N D-9421N1804DBrinkeroff John · Drain, ORBuilt 1952 · S/N D-3073N1805LJacoby Peter A · Tucson, AZBuilt 1976 · S/N D-9873N1808DHire Daniel · Plainfield, INBuilt 1952 · S/N D-3077N1810DBrown William Steven · Olive Branch, MSBuilt 1952 · S/N D-3079N1812LVintage Aviation LLC · Huntington, INBuilt 1976 · S/N D-9875N1815DOdell Ryan S · Yukon, OKS/N D-10376N1815GGalaxy Aviation LLC · Nantucket, MABuilt 1981 · S/N D-10379N1816DLe Roy Robert · Yuma, AZBuilt 1952 · S/N D-3266N181CBBuchanan Clayton W · Fernandina Beach, FLBuilt 1970 · S/N D-9124N181LFSmall & Co LLC · Omaha, NEBuilt 1961 · S/N D-6573
Back to AD 94-20-04 R2