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.

N3651ZCrabtree Glenn E · Guthrie, OKBuilt 1960 · S/N 22-7548N3652MSorensen Parker J · Homer, AKBuilt 1947 · S/N 12-2602N3652QNolen David S · Wimberley, TXBuilt 1967 · S/N MA-239N3652RShales Rene J · Hampshire, ILBuilt 1969 · S/N 28-5756N36537Terrell Mark · Greentown, INBuilt 1941 · S/N LB-16131N3653BPlacebo Air LLC · Ridgecrest, CABuilt 1954 · S/N CH-128N3653NBurch Herbert K · Milan, OHBuilt 1967 · S/N 680025N3653PWright Michael · Hurricane, UTS/N 22-3404N3653QFlying Naked Muskteers LLC · Palm City, FLBuilt 1967 · S/N MA-240N3653RSingh Harsimran · Las Vegas, NVBuilt 1970 · S/N 28-5758N3653ZMandibles Edward Jr · Lompoc, CABuilt 1960 · S/N 22-7550N36541Plains Aviation · Mitchell, SDBuilt 1978 · S/N 28-7890521N3654KBeaber Michael J · Fremont, OHBuilt 1967 · S/N 28-23673N3654MLunoe Finn · Anchorage, AKBuilt 1947 · S/N 12-2526N3654RSierra Delta 1 LLC · Dover, DEBuilt 1969 · S/N 28-5759N3654ZSandland Christopher A · North Pole, AKBuilt 1959 · S/N 18-7184N3655NPeterson Jesse D · Wasilla, AKBuilt 1947 · S/N 12-1906N36563Ware Richard A · Versailles, OHBuilt 1978 · S/N 28-7890513N36567Kempton Larry G Jr · Grand Junction, COBuilt 1978 · S/N 28-7890522N3656AHughes James D · Stanhope, IABuilt 1954 · S/N 22-1916N3656PKennedy Lukas · Anchorage, AKS/N 22-3407N36574California In Nice Inc · San Jose, CABuilt 1978 · S/N 28R-7837284N3657NEstes Aviation LLC · Vicksburg, MSBuilt 1967 · S/N 680027N3657QFaith Builders Family Church Inc · Rogers, ARBuilt 1968 · S/N M-1136N3657ZBagdon Albert B · Elbert, COBuilt 1960 · S/N 22-7554N36583Trident Aircraft Inc · Easton, MDBuilt 1978 · S/N 28-7816647N3658APrice James H · Abilene, KSBuilt 1953 · S/N 22-1918N3658MHowker John A · Louisville, KYBuilt 1947 · S/N 12-2608N3658NUnivair Aircraft Corp · Aurora, COBuilt 1947 · S/N 12-1911N36593Kentucky Stick And Rudder Academy LLC · Springfield, KYBuilt 1973 · S/N 112-73N36594Hayward Casey W · Anchorage, AKBuilt 1973 · S/N 578-73N3659AZientara Jim A · Zephyrhills, FLS/N 22-1919N3659KDumont Mark · Brush Prairie, WABuilt 1967 · S/N 28-23676N3659MTrent Daniel E · Las Vegas, NVBuilt 1978 · S/N 28-7890320N3659RInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-5762N3659XAiello Bailey H · Eugene, ORBuilt 1968 · S/N 311N365AKColville Inc · Anchorage, AKS/N 3065N365BSHarders Justin M · Cairo, NEBuilt 2024 · S/N 009N365CB.R.S. Leasing Inc · Wilmington, DEBuilt 2001 · S/N 2163N365CCSki Sawmill Family Resort Inc · Ulysses, PABuilt 2004 · S/N 9963CCN365DAJeffries Ian Mcgoff Douglas · Clover, SCBuilt 2013 · S/N 82704N365DLSoehner Harold D · Winslow, AZBuilt 2009 · S/N DAL001N365DRPace Ryan · Morgan, UTBuilt 2023 · S/N 002N365JRBe-A36 Inc Trustee · Wilmington, DEBuilt 2022 · S/N 3389N365MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881688N365PCWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 17271033N365PSFainer Jeffrey M · San Diego, CABuilt 1978 · S/N AA5A0552N365RWWalter Aviation · Perry, IABuilt 1990 · S/N 903N365SPClow International Airport LLC · Bolingbrook, ILBuilt 2001 · S/N 172S8783N365TGengarelly Robert M · Benson, AZBuilt 2011 · S/N 72419
Back to AD 90-04-06 R1