OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,369

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.

N15343Bridger'S Hvac And Welding LLC · Milan, TNBuilt 1972 · S/N 28-7305061N1534ADelta Charlie Aviation LLC · Glendale, AZS/N 20-730N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709N1534JChapman Melvin Newton II · Mishawaka, INBuilt 1967 · S/N 28-23934N1535White Philip E · Hudson Oaks, TXBuilt 2010 · S/N 3335N15354Stephen Swift · Justin, TXBuilt 1972 · S/N 28-7305062N15359Kobberdahl Matthew T · Maple Grove, MNBuilt 1972 · S/N 28-7325046N1535AHerve Keith E · North Pole, AKBuilt 1951 · S/N 20-731N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710N15360Registered aircraftBuilt 1972 · S/N 28-7325047N15361Williams Darren M · Carthage, ILBuilt 1972 · S/N 28-7305063N15367Labrousse Ronald E · Tidewater, ORBuilt 1972 · S/N 28-7325048N1536ACoughlin Edmund Timothy · Manlius, NYBuilt 1951 · S/N 20-732N1536RCape Cod Aero Club LLC · Falmouth, MABuilt 1975 · S/N AA5B-0036N15372Hollingshead Terry L · Flint, MIBuilt 1972 · S/N 28-7325050N15373Johnson Brant T · Collinsville, OKS/N 28-7325051N15374Smith William L · Supply, NCS/N 28-7325052N15376Brown William D Jr · Mount Pleasant, TXBuilt 1972 · S/N 28-7305065N15377Johnson Matthew · Biglerville, PABuilt 1972 · S/N 28-7305066N15378Ketcham Jesse E · Aguanga, CABuilt 1973 · S/N 28-7305067N15379Huyler John C · Shreveport, LABuilt 1972 · S/N 28R-7335053N1537JYearta Philip T · Bono, ARS/N 28-23938N1537XSale Reported · Milton, FLSale reportedBuilt 1975 · S/N 28-7515418N15380Miller Aviation Group LLC · Coon Rapids, MNBuilt 1972 · S/N 28R-7335054N15388Smith John-Michael L · Austin, TXBuilt 1972 · S/N 28-7325054N1538PWassmus Justin A · Riley, MIS/N 22-2415N1538RAction Aerospace LLC · Bluffton, SCBuilt 1975 · S/N AA5B-0038N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651N1538XStaton Justin · Kemah, TXBuilt 1975 · S/N 28R-7535315N15391Lyon Anthony R · Bethesda, MDBuilt 1972 · S/N 28-7305068N15392Dgm Aviation LLC · Hurricane, WVBuilt 1972 · S/N 28-7305069N15395Magnum Aviation LLC · Goff, KSS/N 2408N1539AHall Mark R · New Smyrna Beach, FLBuilt 1951 · S/N 20-735N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040N1539HAve Maria LLC · Batesville, INBuilt 1975 · S/N 177RG0713N153AFarwest Aviation LLC · Billings, MTBuilt 1966 · S/N 3550N153ACN153ac LLC · Eldon, MOBuilt 1993 · S/N 702-93N153AMMedford Daniel E · Lakeville, MNS/N 17702222N153BAGeorge Tim D · Cleburne, TXBuilt 2010 · S/N 880211N153BCMeierotto Jeff T · Two Rivers, AKBuilt 2011 · S/N BC-1N153BDM & M Farms · Fowler, KSS/N 80939N153CHarless Richard K · Battle Mountain, NVBuilt 1998 · S/N 1415N153GBBackovich George C · Pine Grove, CABuilt 2018 · S/N 1739N153GHHealey David A · Hammondsport, NYBuilt 1966 · S/N 660602N153JRRs Helicopters Inc · Lake Wales, FLBuilt 1953 · S/N 3753N153LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842196N153MBaker Thomas J · Oxford, MDBuilt 2011 · S/N 82655N153MCHollingshead Keith · Clarksboro, NJBuilt 2004 · S/N 60128N153MTMiller Nathan · Irwin, OHBuilt 1978 · S/N 15282694
Back to AD 90-04-06 R1