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.

N190DCHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496103N190GESale Reported · Minden, NVSale reportedS/N 81689N190JTravel Services LLC · Metropolis, ILBuilt 2014 · S/N 1142-2014N190MALightning Aviation LLC · Gillette, WYBuilt 2004 · S/N 40.355N190MNKraemer Jeremy A · Melrose, MNBuilt 2024 · S/N JA2201190N190RROrr John C · Longmont, COBuilt 1997 · S/N 23039N190RVMccormick David E · Antioch, ILBuilt 1998 · S/N 30424N19103Mashburn Paul M · Cumming, GABuilt 1976 · S/N 17702557N1910PWesley Gary J · Moorland, IABuilt 1955 · S/N 22-2657N1910TBrown James E · Wind Lake, WIBuilt 1971 · S/N 28-7125464N1910YPeabody Riley A · Minnetonka, MNBuilt 1964 · S/N 205N19119Rose Randy J · Egg Harbor, WIBuilt 1976 · S/N 17702559N1911ADay Patrick J · Bloomer, WIBuilt 1952 · S/N 18-1745N1911PWalker Raymond Lee · Saint Charles, MIBuilt 1955 · S/N 22-2590N1911TSnp Aviation LLC · Avoca, IABuilt 1971 · S/N 28-7125412N1911VLefort Charles J · Redding, CABuilt 1974 · S/N 28-7405103N1912AWebber David A · Delta Junction, AKBuilt 1952 · S/N 18-1748N1912PSojourner Field LLC · Kouts, INBuilt 2014 · S/N 22483N1912THillman Motors Inc · Winter Haven, FLBuilt 1971 · S/N 28R-7135130N1912YFrokjer Dean C · Saint Croix Falls, WIBuilt 1964 · S/N 207N1913HOllie And Wally Airlines LLC · Auburn, WABuilt 1977 · S/N 28-7716061N1913JHaugo Bruce K · Sarasota, FLS/N 4JN1913TWilliams Ronald P · Woodway, TXBuilt 1971 · S/N 28-7125474N1913YSchmitt William Joseph · Santa Cruz, CABuilt 1964 · S/N 208N1914AElmore James C Jr · Hedgesville, WVBuilt 1952 · S/N 18-1751N1914HMiloud Chadd K · Fort Worth, TXBuilt 1977 · S/N 28-7716062N1914LDeakins Glenn F · Ringgold, GAS/N MB-803N1914VStephens Thomas E · Blacklick, OHBuilt 1974 · S/N 17263792N1915AMercatoris Robert B · Meadville, PABuilt 1952 · S/N 18-1756N1915PParker Joshua J · Hawley, TXBuilt 1955 · S/N 22-2662N1915TAeromx LLC · West Jefferson, OHBuilt 1971 · S/N 28R-7135132N1915YJordan S Connor · Elizabeth City, NCBuilt 1964 · S/N 210N1916LBoeing Co · Renton, WABuilt 1966 · S/N 1AN1916YLarsen Adam P · Gresham, ORBuilt 1964 · S/N 211N1917LEpiphany Airmotive LLC · Frisco, TXBuilt 1976 · S/N M-1817N1917QMeester Mark L · Intl Falls, MNBuilt 1972 · S/N 177RG0317N1917XKilpatrick John N · Redding, CABuilt 2005 · S/N 05-01N1917YMock Joseph R · Huntsville, TXBuilt 1964 · S/N 212N1918LBurt Christopher James · Leesport, PABuilt 1976 · S/N M-1813N1918VCampbell Kevin A · Grayville, ILBuilt 1974 · S/N 17263794N1919AHolman Terence A · Portland, ORBuilt 1952 · S/N 18-1747N1919BGoldman Lawrence W · Apex, NCBuilt 1976 · S/N MB-794N1919EPoklar Norman A · Mount Orab, OHBuilt 1957 · S/N 7AC-5486N1919FUsda Forest Service Fepp · Columbia, SCBuilt 1979 · S/N 17273011N1919GLow And Slow Aviation LLC · Williston, FLBuilt 2014 · S/N AL-1189N1919PBarnett David K · Brock, TXS/N 22-2666N1919QErickson Bernard L · Moses Lake, WABuilt 1972 · S/N 177RG0319N1919SBurgess Reilly M · Greene, MEBuilt 1974 · S/N 17263899N1919YSu Ryan · Saint Augustine, FLBuilt 1964 · S/N 214N191ABRegistration Pending · Newport, ORRegistration pendingBuilt 1963 · S/N 2471
Back to AD 90-04-06 R1