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.

N5715HReuhl Kenneth R · Piscataway, NJBuilt 1949 · S/N 16-327N5715WRyan Peter C · Riverhead, NYS/N 28-1216N5715ZProper Theron · Arlington, AZBuilt 1963 · S/N 22-9554N5716DNeumayer Barry A · Redlands, CABuilt 1956 · S/N 22-4412N5716HLeaders Flying Service LLC · Clear Lake, MNBuilt 1949 · S/N 16-328N5716QEdick Thomas M · Wasco, CABuilt 1965 · S/N 3060N5716UMil2atp Inc · Pikeville, NCBuilt 1969 · S/N 28-26516N5716ZBlue Ridge Soaring Society · New Castle, VAFirst renewal noticeBuilt 1963 · S/N 18-8018N5717DClaxon David W · Gifford, ILS/N 22-4415N5717FDanberry John Lee · Janesville, MNBuilt 1968 · S/N 28-24930N5717LChristian George D · Kingwood, TXBuilt 1969 · S/N AA1-0117N5717WBrock David J · Torrance, CABuilt 1965 · S/N 28-2896N5717ZJohnston Charles W C Jr · Newfield, NJBuilt 1963 · S/N 22-9556N5718DBurk Albert A Jr · Parkville, MDBuilt 1956 · S/N 22-4416N5718LMullins John D · Harriman, TNS/N AA1-0118N5718TMccormack Timothy J · Marcy, NYS/N 17251618N5719HPetersen Danny · Caddo, OKBuilt 1949 · S/N 16-331N5719LGodoy Air LLC · Venice, FLS/N AA1-0119N5719PPulkrabek David · Hutchinson, MNBuilt 1959 · S/N 24-793N5719QHiner Jeffrey N · Salt Lake City, UTBuilt 1965 · S/N 718N5719UTfa Holding Corp · Daytona Beach, FLBuilt 1969 · S/N 28-26519N5719WRiggin Flight Service Inc · Madison, SDS/N 28-1344N571ATAtp Aircraft 3 LLC · Wilmington, DEBuilt 2005 · S/N 4496193N571DFSalire LLC · Alpha, OHBuilt 2009 · S/N 91169N571DMWilliams Stephen C · Georgetown, MEBuilt 2002 · S/N 464-2002N571FLSimpson Michael J · Bethlehem, CTBuilt 1971 · S/N 28-7125416N571GWSwenson David · Fairbanks, AKBuilt 2017 · S/N 001N571LFRegistered aircraftBuilt 2003 · S/N 478-2003N571MDLemoine Julius D · Dahlonega, GABuilt 1975 · S/N 28-7625031N571MMMoment Stv L · Urbana, ILBuilt 2008 · S/N 06118N571MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2004 · S/N 40.396N571PUPurdue University Trustees · West Lafayette, INBuilt 2002 · S/N 4496142N571RVKranz Monte L · Eagle Butte, SDBuilt 2005 · S/N 571N571SARegistration Pending · Azle, TXRegistration pendingBuilt 2005 · S/N 1009-2005N571SPChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 172S8496N571TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881871N571YWestern Antique Aeroplane & Automobile Museum · Hood River, ORBuilt 1933 · S/N 7001N5720EInstall Pro Construction LLC · Henderson, NVBuilt 1978 · S/N 17271926N5720FHander Robert · Liberty Lake, WABuilt 1968 · S/N 28-24933N5720LKh Aircraft LLC · Denton, MTBuilt 1969 · S/N AA1-0120N5720UHone Jason B · Carnation, WAS/N 28-26520N5720WThird Step 2 LLC · Gilbert, AZBuilt 1963 · S/N 28-1231N5720ZIrvine Hollis E Jr · Greenwich, NJBuilt 1963 · S/N 22-9559N5721LBerggren Ryan J · Newton, NJBuilt 1969 · S/N AA1-0121N5721QRawski Aviation LLC · Kingwood, TXBuilt 1965 · S/N 764N5721WPrecise William C Jr · Philadelphia, PABuilt 1963 · S/N 28-1247N5722FChrabasz Frank L · Arlington, TXBuilt 1968 · S/N 28-25023N5722QMyers Shawn · Louisville, KYBuilt 1965 · S/N 3063N5722UPfeifer Eric P · Hill City, KSS/N 28-26524N5723FOdyssia LLC · Corpus Christi, TXS/N 28-25024
Back to AD 90-04-06 R1