OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,375

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:90-04-06-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:90-04-06-R1')
  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.

N35120Hillard Mark L · Gettysburg, PABuilt 1974 · S/N 17702219N35122Riggs Charles A · Pembroke Pines, FLBuilt 1974 · S/N 17702221N35128Lambo Air LLC · Springtown, TXBuilt 1974 · S/N 17702224N3512KEarlys Cycle Center Inc · Harrisonburg, VABuilt 1946 · S/N 22203N3512MSutton Aircraft Salvage LLC · Palmer, AKS/N 12-2664N3512XTaylor Logan · Live Oak, CABuilt 1966 · S/N 670050N3513AKnudsen John M · Anchorage, AKS/N 22-1785N3513LDuden Brett R · Golden, COBuilt 1978 · S/N 0795N35143Premier Jets Inc · Hillsboro, ORS/N 17702229N3514AEastern Stearman Inc Trustee · Leesburg, VAS/N 22-1786N3514KHollan Charles J · Columbia Station, OHBuilt 1967 · S/N 28-23601N3514LFlying Horseman Ranch LLC · Stuart, VABuilt 1978 · S/N 0796N3514QReed Daniel E · Wentzville, MOBuilt 1973 · S/N 17261659N3514UChristiansen Aviation LLC · Wilmington, DEBuilt 2001 · S/N 172S8841N35151Aac Leasing LLC · North Ferrisburgh, VTBuilt 1975 · S/N 17702235N35158Pearce Henry J · New Baltimore, MIBuilt 1975 · S/N 17702238N3515ADouglass Darrell C · Jamestown, CABuilt 1968 · S/N 1N3515LBorchers Bruce A · Scotts Valley, CAS/N 0797N3515NClauson Jesse W · Agawam, MABuilt 1967 · S/N 680079N3515XSayre Mikko · Madison, WIBuilt 1966 · S/N 670053N35163Eagle Sky Patrol Inc · Deadwood, SDBuilt 1975 · S/N 17702239N35165N35165 LLC · Starkville, MSBuilt 1975 · S/N 17702241N3516KSteitz John III · Antioch, ILS/N 28-23602N3516XThompson Richard F · Boone, NCBuilt 1966 · S/N 670054N3517MWilder Kirk E · Boonville, CABuilt 1947 · S/N 12-2384N3517NTronaas Chris E · Hamilton, MTBuilt 1967 · S/N 680080N3517PSmith Mark A · Bowling Green, KYBuilt 1946 · S/N 12-374N3517ZMeyers Carl A · Salem, CTBuilt 1960 · S/N 22-7414N35182Beachy Michael H · Dundee, OHBuilt 1976 · S/N 177RG1045N35185Stephens Brian A · Bruceville, INBuilt 1975 · S/N 17702252N35186Mucci Eileen F · Wolcott, CTBuilt 1975 · S/N 17702253N35191West Monte D · Coldspring, TXBuilt 1975 · S/N 17702255N35192Huffman Robert V · Washington, DCBuilt 1975 · S/N 17702256N35193Mccormack Duncan M · Sunfield, MIS/N 17702257N35196Courtney Marshall Duchesne · Mission Hills, CABuilt 1975 · S/N 17702260N35199Global Aerials Inc · Pembroke Pines, FLBuilt 1975 · S/N 17702261N3519ABandy Clyde T · Orlando, FLBuilt 1953 · S/N 22-1791N3519HGulino Thomas V · College Park, MDBuilt 1976 · S/N 20-1220N3519ZSprott Robert L · Perkins, OKBuilt 1960 · S/N 22-7418N351BBFinnerty Maurice E · Tabernacle, NJBuilt 1952 · S/N 20-867N351GPSelby Chris A · Monticello, ARBuilt 1968 · S/N 17256918N351GSKukowski Matthew P · Wheatland, WYBuilt 2000 · S/N 80713N351JDHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1997 · S/N 2707N351JMSeal Benjamin A · Grapevine, TXBuilt 2011 · S/N 81655N351KCErickson Jason O · Mckinney, TXS/N 25114N351MKNorth Star Aviation · Mankato, MNBuilt 2021 · S/N 2881440N351WHDean John · Marana, AZBuilt 2002 · S/N 2309N35203Sky Views Aviation LLC · Red Lodge, MTBuilt 1975 · S/N 17702263N35205Riley John Roland · Ouray, COBuilt 1976 · S/N 177RG1046N3520PWidner Jack A · Stanley, NCBuilt 1955 · S/N 22-3274
Back to AD 90-04-06 R1