AD 90-04-06 R1

Registered aircraft · 68,377

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.

N6120ZH & H Ag Aviation Inc · New Underwood, SDBuilt 1960 · S/N 25-140N6121HRethink Creative Group LLC · Fort Worth, TXBuilt 1977 · S/N 28-7816225N6121LHinds Community College · Raymond, MSBuilt 1970 · S/N AA1-0321N6121PSmith Gloria M · New Hampton, NYBuilt 1959 · S/N 24-1221N6121UBoatman John H Jr · Smyrna, TNBuilt 1962 · S/N 205N6121VPugmire Marsh C · Saint Charles, IDBuilt 1980 · S/N 172RG0582N6121WRadius Aviation LLC · Fort Rucker, ALBuilt 1964 · S/N 28-20137N6122DBudde Bobby M Jr · San Jose, CAFirst renewal noticeBuilt 1979 · S/N 17272607N6122JVatm Sky Investments LLC · Thomson, GABuilt 1976 · S/N 28-7615305N6122WN6122w LLC · Tillamook, ORS/N 28-20138N6123AThomas K Doris · Lopatcong, NJBuilt 2006 · S/N TKD25766N6123DCampi Curtis · Boulder City, NVBuilt 1957 · S/N 22-4767N6123FJws Aviation LLC · Edina, MNBuilt 1979 · S/N 17273153N6123NPfisters Flying Wahine · Waialua, HIBuilt 1969 · S/N MB-409N6123QAirflair Inc · Maurice, IABuilt 1976 · S/N 28-7790065N6123VWings Over La Aviation LLC · Van Nuys, CABuilt 1965 · S/N TD-613N6124DWegener Flying Services LLC · Indialantic, FLBuilt 1979 · S/N 17272608N6124JCrews Aaron Gregory · Boone, IABuilt 1976 · S/N 28-7690346N6124KLacy Clay Trustee · Los Angeles, CAS/N 310N6124NPacific Coast Air Museum · Santa Rosa, CABuilt 1968 · S/N MB-410N6125BBv Road And Site LLC · Penfield, NYBuilt 1979 · S/N 15283904N6125LJohnson Gerald A · Sedro Woolley, WAS/N AA1-0325N6125ZSvendsen Jon A · Wasilla, AKBuilt 1960 · S/N 25-145N61260Syracuse Flight School Inc · Syracuse, NYBuilt 1978 · S/N 28R-7837255N61268Mosher Dustin T · Tehachapi, CABuilt 1942 · S/N 75-3259N6126DNeal Brian C · Monrovia, CABuilt 1957 · S/N 22-4770N6126SWise Joseph · Kilgore, TXBuilt 1965 · S/N 18-32N6126TGuida Associates Consulting Inc · Sandpoint, IDS/N S1496N6126WMatthews James C · Gilbert, SCBuilt 1964 · S/N 28-20142N6127AGilfert Thomas E · Selinsgrove, PABuilt 1979 · S/N 18-8009051N6127HBless Howard P · Pennsburg, PAFirst renewal noticeBuilt 1977 · S/N 28-7816226N6127VSorbi Aviation Inc · El Cajon, CAS/N 172RG0583N6127WLa Aviation Ltd · Wilmington, DES/N 28-20143N6127ZSimmons Aviation Services LLC · Pawcatuck, CTBuilt 1960 · S/N 25-148N6128UJoslyn Larry J · Las Vegas, NVBuilt 1993 · S/N S1655N6129CSumner Scott B · Catoosa, OKBuilt 1988 · S/N 11057CN6129HHouk Air LLC · Waverly, OHBuilt 1977 · S/N 28-7890209N6129JBlue Skies Aircraft LLC · Kalispell, MTBuilt 1976 · S/N 28-7625221N6129LDodson David W · Granger, INBuilt 1970 · S/N AA1-0329N612APThomas Lucas G · Beebe, ARBuilt 1978 · S/N 286-78N612BZDerby City Aviation LLC · Vero Beach, FLBuilt 1979 · S/N 17272084N612CBelton Mark S · Eugene, ORBuilt 1948 · S/N 5N612CAOmni Aero LLC · Wilkesboro, NCBuilt 1978 · S/N 15282495N612DMRegistered aircraftBuilt 1977 · S/N 177RG1212N612ERNelson James W · Lake Villa, ILBuilt 2018 · S/N 65-10237N612FTFlorida Institute Of Technology · Melbourne, FLBuilt 1977 · S/N 28-7816197N612GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881195N612GPPlugge Glen A · Tuscaloosa, ALS/N 23920N612HKDickey Stephen H · De Leon, TXBuilt 1977 · S/N 177RG1303N612HPAmerican Patrols Inc · Midland, TXBuilt 1981 · S/N 17274933
Back to AD 90-04-06 R1