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.

N4212SColburn Reno Bryan · Turner, MTBuilt 1976 · S/N D-9954N4214BCoburn Brooks · Leesburg, VABuilt 1955 · S/N D-4167N4215DTench William C · Belton, SCBuilt 1955 · S/N D-4421N4216BRasmussen Nathan A · River Falls, WIBuilt 1955 · S/N D-4175N4217DNation Linda S · Sanford, FLBuilt 1955 · S/N D-4426N4217SAnla Aviation LLC · Bentonville, ARBuilt 1977 · S/N D-9968N4218DHarris Beth · Albuquerque, NMBuilt 1955 · S/N D-4412N4224DBurgher Ronald · Fallbrook, CABuilt 1955 · S/N D-4432N4225BJobelle Albert M · Los Angeles, CABuilt 1955 · S/N D-4193N4226DClark Douglas E · Petal, MSBuilt 1955 · S/N D-4435N4228BKcuce LLC · Kalispell, MTS/N D-4197N422DCJohnson John K · Portland, ORBuilt 1959 · S/N D-5843N422GRHolden Virgil Gary Trustee · Upland, CABuilt 1966 · S/N D-8243N4230BYonge Chase L · Summerfield, FLS/N D-4201N4230DKoski John M · Wichita Falls, TXBuilt 1955 · S/N D-4438N4232DRuppel Robert E · New Orleans, LAS/N D-4441N4233DLaine John J · Katy, TXBuilt 1955 · S/N D-4442N4234BLionudakis Mike Alan · Scotts Valley, CABuilt 1955 · S/N D-4207N4236BFisher Timothy G · Goddard, KSBuilt 1955 · S/N D-4209N4236DMatthew S Mcgaugh · Denton, NCBuilt 1956 · S/N D-4448N4237BKruger Kurt D · Delano, CABuilt 1955 · S/N D-4210N423MDSublett Charles M · Tulsa, OKBuilt 1964 · S/N D-7454N423WTCoons John K · Winston Salem, NCBuilt 1964 · S/N D-7426N423YEconome James S · Danville, CABuilt 1961 · S/N D-6845N4240BKent Ronald M · Fallon, NVFirst renewal noticeBuilt 1955 · S/N D-4214N4240DSummit Coastal Pllc · Carrboro, NCBuilt 1956 · S/N D-4460N4241DHilton Allen J A Jr · Justin, TXBuilt 1956 · S/N D-4461N4242BKingsbury Raymond S · Farmington, MNBuilt 1955 · S/N D-4216N4242DNielson Erik J · Erie, COBuilt 1956 · S/N D-4462N4244BHft Enterprises LLC · Wilburton, OKBuilt 1955 · S/N D-4218N4244DWarner Michael · Lexington, KYBuilt 1956 · S/N D-4459N4245AMac Flight LLC · Conway, ARBuilt 1970 · S/N D-9126N4246DFinnelly Daniel T · Pasco, WABuilt 1956 · S/N D-4468N4247BHarris Dan C · Rockford, TNS/N D-4221N4247DFussell L J · Broxton, GABuilt 1956 · S/N D-4465N4248BFreeman Lyman M · Golden Hills, CABuilt 1955 · S/N D-4224N4248DDrangle Bruce · Gilman, WIBuilt 1956 · S/N D-4455N424TCyphers Russell W · Phoenix, AZS/N D-6806N4250B623gj LLC · Aitkin, MNBuilt 1955 · S/N D-4226N4251BOliver Rodney W · Houston, AKBuilt 1955 · S/N D-4227N4252BSexton Kenneth Wade · Baker, FLBuilt 1955 · S/N D-4228N4252DTravis Tom · Dallas, TXBuilt 1956 · S/N D-4469N4253DCustis James G · Denver, COS/N D-4470N4254BOsgood Nathan · Toa Baja, PRBuilt 1955 · S/N D-4231N4254DKlna Bonanza LLC · Lake Worth, FLBuilt 1956 · S/N D-4471N4255DSprague Dale M · Mcpherson, KSBuilt 1956 · S/N D-4478N4256DBishop Herbert O Trustee · Reno, NVBuilt 1956 · S/N D-4482N4257BLindell Michael V · Aledo, ILBuilt 1955 · S/N D-4234N4257DPeterson Duane T · Milwaukee, WIS/N D-4485N4258DRexrode Rocky · Frankston, TXBuilt 1956 · S/N D-4473
Back to AD 94-20-04 R2