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.

N1493CH G Klug Sons Inc · Omaha, NEBuilt 1953 · S/N 18-2687N1493ESherman Aviation LLC · Fairfield, NJBuilt 1978 · S/N 17271022N1493VMy Flight LLC · Cypress, TXBuilt 1974 · S/N 17263623N1494AHelton Tom H · Santa Ana, CABuilt 1952 · S/N 22-398N1494VWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263624N1495ARamos Benjamin · Yuma, AZS/N 22-402N1495CGulf Coast Helicopters Inc · Pearland, TXBuilt 1977 · S/N 17702737N1495UFairflight LLC · San Diego, CABuilt 1976 · S/N 17267162N1496PRobbins Warren N · Chandler, AZBuilt 1956 · S/N 23-566N1497ASlagle Steven D · Auburn, WABuilt 1952 · S/N 22-417N1497RAnthonson Douglas Etal · Cortland, NYS/N AA1B-0597N1498ASpivey Larry B · Milledgeville, GABuilt 1952 · S/N 22-403N1498CBrutger Wayne A · Saddlebrooke, AZBuilt 1978 · S/N 17702739N1498RPedersen Paul C · Barbourville, KYBuilt 1975 · S/N AA1B-0598N1498TMurwin Keith T · Douglasville, GABuilt 1972 · S/N 28R-7235307N1498VMoore James E · East Falmouth, MABuilt 1974 · S/N 17263628N1499CGalbrecht Daniel S · Arbor Vitae, WIBuilt 1978 · S/N 17702740N149ABernis Old Airplane Co Inc · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1960 · S/N 173N149BCKurtz Garold · Mound City, MOBuilt 2004 · S/N 4532004N149BHPylant Michael K · Huntsville, ALBuilt 2014 · S/N 1949N149BRStolzer Dale V · Shady Shores, TXBuilt 1962 · S/N 111N149BSBlack Sword Armoury Inc · Hawthorne, FLBuilt 1957 · S/N FW 262N149CGMoran John R · Port Saint Lucie, FLBuilt 1982 · S/N 18-8209011N149CWMullins Jerry W · Wilmington, NCBuilt 1985 · S/N 210N149DCDale Gared W · Hugo, OKS/N 28-2643N149DDPalmisano Joseph · New London, CTBuilt 1959 · S/N 106N149DEToma Integrity Inc · Austin, TXBuilt 2002 · S/N 90034N149DFNelson Jim · Lewisburg, TNS/N 348N149DJPomeroy Thomas · Lovettsville, VABuilt 1959 · S/N 080N149DMCraig Darrell L · Middleburg, FLFirst renewal noticeS/N 0918N149EENewhouse Gregory A · Enterprise, ALBuilt 1960 · S/N 157N149EROhlau Mark A · Wellington, NVBuilt 1975 · S/N 1-2N149FFountain Flying Service-Genesee LLC · Genesee, IDBuilt 2021 · S/N 5790N149GGJagodnik Warren L · Powell, OHBuilt 1957 · S/N NC266N149JCCorrea Javier Rafael · Caguas, PRS/N 17276119N149JLKenyon Terry J · Henderson, ARBuilt 1975 · S/N 28R-7535109N149JTPanhandle Associates Inc · Guymon, OKBuilt 1986 · S/N THOMPSON 0001N149JZGooney Bird Group Inc · Paso Robles, CAS/N 255N149KCLoveless Gaylan · Elaine, ARS/N 696N149LFFord Larry M · Sebastopol, CAS/N 395N149LHFarmingdale State University · Farmingdale, NYBuilt 2003 · S/N 2842192N149LLRegistered aircraftBuilt 1961 · S/N 346N149LTNeil Squared LLC · Spring Grove, ILS/N 321N149PAelick Joel D · Charlotte, NCBuilt 1979 · S/N M-2237N149PGCrouch Paul Alan · Oak Harbor, WABuilt 1960 · S/N 177N149PRCloudbase Flyers LLC · Hillsboro, ORFirst renewal noticeBuilt 2020 · S/N 70149N149RHHinton Scott A · Elizabeth City, NCBuilt 2007 · S/N 149N149RLShepard Logan · Sultan, WABuilt 1960 · S/N 128N149RMCollins Robert M · Cape Elizabeth, MEBuilt 2014 · S/N 90763N149TSHawkins David B · Dallas, TXBuilt 2005 · S/N 81006
Back to AD 90-04-06 R1