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.

N8924RMachler Lance J · Murphys, CABuilt 1959 · S/N 152N8924VDupree Johnny · Crossett, ARBuilt 1974 · S/N 17264281N8924YPrestininzi Robert Anthony · Fort Mill, SCBuilt 1969 · S/N 30-1997N8925FAztec Aviation · Geneseo, ILBuilt 1964 · S/N 0307N8925YBlue Sky Adventures LLC · Hanover, PAS/N 39-81N8926Johnson David H · Jasper, GABuilt 1973 · S/N 367-73N8926DPlanes & Things Inc · Collinsville, OKBuilt 1958 · S/N 22-6083N8926JGreene Ronald F · Mc Alpin, FLBuilt 1965 · S/N 28-2944N8926VCareer Flight Training And Aircraft Rental LLC · Naples, FLBuilt 1974 · S/N 17264283N89273Anderson Ben H · Fort Smith, ARBuilt 1978 · S/N 15282697N8927JTipton Thomas G · Walnut Grove, MOS/N 28-2945N8927PSmith Tracy L · Middletown, CTBuilt 2000 · S/N 20-0049N8927VTropical Aviation LLC · Gulf Shores, ALBuilt 1974 · S/N 17264284N8928Anding Jay B · Bryan, TXBuilt 1973 · S/N 483-73N8928CGiber Kristofor D · Manvel, TXBuilt 1953 · S/N 22-1521N8928FDenver Aerospace Science Museum · Watkins, COBuilt 1964 · S/N 0004N8928JHaybron David M · Sewickley, PABuilt 1965 · S/N 28-2946N8928MKeyt Jeffrey D · New Providence, NJBuilt 1963 · S/N TD-555N8929Cavanagh James B · Litchfield Park, AZBuilt 1973 · S/N 255-73N8929JRice Spencer F · Portland, ORBuilt 1965 · S/N 28-2947N8929LPeters Nicholas J · Eagle River, AKBuilt 1974 · S/N 18-7409127N892ACAri Ben Aviator Inc · Fort Pierce, FLBuilt 2020 · S/N 2881398N892DLBd Aviation LLC · Sauget, ILBuilt 2021 · S/N 28020041N892PTTims Duane R · Hemet, CABuilt 2012 · S/N 70567N892SGCraik Evelyn June · Las Vegas, NVBuilt 1966 · S/N 1114N893012265 LLC · Mercer Island, WABuilt 1978 · S/N 15282706N8930DBeverly Lester E · Shepherd, TXS/N 22-6088N8930JMccracken Blake R · Lake Havasu City, AZBuilt 1965 · S/N 28-2948N8930MCuratola Bruce J · League City, TXS/N M-318N89310Kuyl Marinus D · Forest Grove, ORBuilt 1978 · S/N 15282708N89312Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282710N8931VAeroventures 8 LLC · Mt Carmel, TNS/N 17264288N8932DRegistration Pending · Caldwell, IDRegistration pendingBuilt 1958 · S/N 22-6090N8932MOlivieri Michael R · Wasilla, AKBuilt 2009 · S/N 1-18N8932VEverett William M · Tuscumbia, ALBuilt 1974 · S/N 17264289N8932YStrohmeyer Gregory C · Wasilla, AKBuilt 1974 · S/N 18-7409042N89333Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 1978 · S/N 15282717N89337Davis Andrea E · Lake Oswego, ORBuilt 1983 · S/N 17276002N8933DGrandy Leland P · Rock Springs, WYS/N 22-6091N8933JQuilling John R · Cannon Falls, MNBuilt 1965 · S/N 28-2950N8933LDuncan Aviation Inc · Lincoln, NEBuilt 1974 · S/N 18-7409128N8933RThrall Gregory D · Seward, AKBuilt 1959 · S/N 7GC-159N8934CHandel Patrick A · Wautoma, WIBuilt 1953 · S/N 22-1532N8934VUniversal Aviators Academy Inc · El Monte, CABuilt 1974 · S/N 17264291N8934YFuller John M · Minden, NVBuilt 1971 · S/N 39-95N89358Redstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1978 · S/N 15282724N89359Mccartney Robert · Mountain View, CABuilt 1978 · S/N 15282725N8936JCloud Niners Inc · Brownsburg, INBuilt 1965 · S/N 28-2953N89372Rodriguez Devin · Arlington, TXBuilt 1978 · S/N 15282729N89377Bishops' Ltd · Virginia Beach, VABuilt 1978 · S/N 15282732
Back to AD 90-04-06 R1