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.

N5629WLawrence Michael · Eden Prairie, MNBuilt 1962 · S/N 28-774N562AGSkywest Leasing Inc · St George, UTBuilt 2024 · S/N 2881814N562BAAviation Financial Corp · Torrance, CABuilt 2005 · S/N 1012-2005N562MAMorrison Richard L Trustee · Canyon Lake, TXBuilt 2000 · S/N 2062N562MMStarworld International Ltd · Long Beach, CABuilt 1975 · S/N AA5B-0049N562PUSkyborne Airline Academy Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 2000 · S/N 2842104N562PWWaters Peter M · Baltimore, MDBuilt 1988 · S/N 967N562WTHawley William L · Moab, UTBuilt 2023 · S/N SD75-11373N56307Cjs Envol LLC · Rowayton, CTBuilt 1973 · S/N 34-7350315N56313Markel John E · Sussex, NJBuilt 1973 · S/N 28R-73-35407N56317Flying Doctor LLC · Clearwater, FLBuilt 1973 · S/N 28R-7335410N5631EN141ns LLC · Lantana, FLS/N 17271906N5631HBoyd Cecil E · Chocowinity, NCBuilt 1949 · S/N 16-242N5631LKing Michael Wayne · Centreville, MDS/N AA1-0031N5631QBayette Andrew · Calhan, COBuilt 1965 · S/N 3014N5631UTejada Emilia P · Oakland Park, FLS/N 28-26427N5631ZMooney Timothy · Hedgesville, WVBuilt 1962 · S/N 22-9443N56324De Melo Marcelo Ramos · Vinton, VABuilt 1973 · S/N 287325609N56325Glaser John · Merritt Island, FLBuilt 1973 · S/N 28-7305570N56326Abernathy Spraying Service Inc · Tipton, OKBuilt 1973 · S/N 28R7335409N5632LLas Vegas Aerial Services LLC · Las Vegas, NVS/N AA1-0032N5632USale Reported · Montgomery, ALSale reportedBuilt 1969 · S/N 28-26428N5632ZEakin Andrew C · Franklin, PABuilt 1962 · S/N 22-9444N56339N56339 LLC · Lebanon, OHBuilt 1973 · S/N 28R7335414N5633PPride Lawrence E · Poway, CABuilt 1959 · S/N 24-703N5633QKeene John D · Spotsylvania, VABuilt 1965 · S/N 3015N5633UStaples Clint B · Glen Rose, TXBuilt 1979 · S/N 8003CN5633WWenzel Mark B · Algona, IABuilt 1962 · S/N 28-779N56343R&T Wings LLC · Lewes, DES/N 28-7325612N56344Rogers Steve M · Brenham, TXBuilt 1973 · S/N 28-7305574N5634LOlson Mitch A · Silver Springs, NVBuilt 1968 · S/N AA1-0034N5634PWaters George A · Oklahoma City, OKBuilt 1959 · S/N 24-704N5634SSmb Air Inc · Crescent Springs, KYBuilt 1979 · S/N 8004CN5634WEagle Vision LLC · Hamer, IDBuilt 1962 · S/N 28-781N56350Aerospace Technology Group Inc · Temecula, CABuilt 1973 · S/N 28-7325613N56353Groux Zachary Brian · Spring, TXBuilt 1973 · S/N 28R7335418N56355Vectair USA LLC · Olive Branch, MSBuilt 1973 · S/N 28R7335419N5635DZuber Gary D · Culver, ORBuilt 1979 · S/N 8006CN5635ECircle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 17271908N5635LCentury Air Inc · Fairfield, NJBuilt 1968 · S/N AA1-0035N56363Romzick Peter G · Oxford, MIBuilt 1973 · S/N 28-73-25618N56368Performance Aircraft Sales Inc · Lincoln, NES/N 34-7350322N5636LCrosby Thomas G · Saint Charles, MOS/N AA1-0036N5636PBarley Austin D · Red Lion, PABuilt 1959 · S/N 24-706N5636QKelly Thomas J · Henderson, TXBuilt 1965 · S/N 674N5636UMontie Michael · Fairview Park, OHBuilt 1969 · S/N 28-26432N5636WWatkins Micah · Queen Creek, AZBuilt 1962 · S/N 28-783N5636ZYoung Harold E · Jamestown, NYS/N 22-9448N56376Brown Christopher · Healdsburg, CAS/N 76-378N5637DWestbrook Michael Scott · Mansfield, TXBuilt 1980 · S/N 9004C
Back to AD 90-04-06 R1