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.

N9655YHenry Brian J · Napa, CABuilt 1962 · S/N D-7071N9657YLimor Yoram · Brentwood, CABuilt 1962 · S/N D-7072N9658YNolf Ruben C · Vancouver, WABuilt 1962 · S/N D-7075N9659YR & N Associates Worldwide Inc · Port Orange, FLBuilt 1962 · S/N D-7076N965QHamilton Richard D Jr · Catawba, NCBuilt 1961 · S/N D-6843N9660YCrawford Russell W · Hickory Creek, TXS/N D-7087N9662YBerry Brian R · Tahlequah, OKBuilt 1962 · S/N D-7078N9670YWild Blue Aviation LLC · Eagle Rock, MOBuilt 1962 · S/N D-7091N9673YSale Reported · Lakeside, MTSale reportedBuilt 1962 · S/N D-7094N9675YKarpenke Christopher · Rochester, NYBuilt 1962 · S/N D-7093N9680YSmutny Joseph Robert · Downers Grove, ILBuilt 1963 · S/N D-7106N9681YHampson Robert J Jr · Oro Valley, AZBuilt 1962 · S/N D-7098N9685YSmd Air LLC · Cleveland, OHBuilt 1963 · S/N D-7107N9688ZZimmerman Gerald M · Savannah, GAS/N D-7108N9693YHodges Christopher · Loganville, GABuilt 1962 · S/N D-7103N9696YSonoran Sunset Realty LLC · Scottsdale, AZBuilt 1962 · S/N D-7104N969CCAllerton Paul F · Cottage Grove, MNBuilt 1958 · S/N D-5531N969VInternational Air Services Inc Trustee · Carson City, NVBuilt 1969 · S/N D-9051N96CDHisghman Jonathan G II · Bozeman, MTBuilt 1958 · S/N D-5739N96DBDipasquale Vance L · Grand Prairie, TXBuilt 1951 · S/N D-2753N96MCW Patrick Enterprises Inc · Wilmington, DEBuilt 1960 · S/N D-6555N96WRegistered aircraftBuilt 1971 · S/N D-9269N9704RPrewitt Scott S · King City, CABuilt 1959 · S/N D-6262N9706RParrish Michael W · Granbury, TXBuilt 1959 · S/N D-6249N9708RGaberdiel Jeffrey M · Lake Butler, FLBuilt 1960 · S/N D-6269N9709RVance Marc G · Canal Winchester, OHBuilt 1959 · S/N D-6263N9709YSolo LLC · Hurst, TXBuilt 1963 · S/N D-7119N9712RFenoglid John A II · Florence, TXBuilt 1959 · S/N D-6259N9714RMichael Dunlevie Pc · Eagle, COBuilt 1959 · S/N D-6266N9714YSanders Jason · Midland, TXBuilt 1963 · S/N D-7120N9715YHill Ronald D · Fort Myers, FLBuilt 1963 · S/N D-7122N9716RTracy Scott J · Santa Barbara, CABuilt 1960 · S/N D-6288N9717RSale Reported · Lenoir City, TNSale reportedBuilt 1960 · S/N D-6395N9719RHughes Alan J · Edison, OHBuilt 1960 · S/N D-6296N9719YRech Ronald P · Woodinville, WABuilt 1963 · S/N D-7121N9720YNation Robert S · Chesterfield, MOS/N D-7124N9721RDeland Air And Sea Brokerage Inc · Deland, FLS/N D-6192N9724RFinley Trevor S · Caddo Mills, TXBuilt 1959 · S/N D-6196N9728RHornbeck Jordan D · Oklahoma City, OKBuilt 1959 · S/N D-6145N9728YLarson Kenneth J · Lake Havasu City, AZBuilt 1963 · S/N D-7127N972QN972q LLC · Sheridan, WYBuilt 1961 · S/N D-6851N9732RPfau Michael G · Princeton, MNBuilt 1959 · S/N D-6211N9734RAces Hangar LLC · Bentonville, ARBuilt 1959 · S/N D-6213N9735YWhalen Mark P · Millington, MDBuilt 1963 · S/N D-7131N9736RGet Happy Adventures LLC · Leawood, KSBuilt 1959 · S/N D-6203N9736YAshura-Smith Mary F · Steamboat Springs, COBuilt 1963 · S/N D-7132N9738RNathan Price · Crawfordsville, INBuilt 1959 · S/N D-6217N9739RKinkade John T · Gallatin, TNBuilt 1959 · S/N D-6218N9740RTonge Gregory Charles · Wenatchee, WABuilt 1959 · S/N D-6219N9741RDoble Michael P · Waukesha, WIBuilt 1959 · S/N D-6220
Back to AD 94-20-04 R2