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.

N8682YCanepa Joseph H · Baraboo, WIBuilt 1969 · S/N 30-1827N86834Cardinal Aviation Inc · Murray, KYBuilt 1974 · S/N 435-74N86838White Sean Patrick · Fairbanks, AKS/N 688-74N8683CDirt Strip LLC · Kalispell, MTBuilt 1953 · S/N 22-1341N8683VDaniel Shannon B · El Dorado Springs, MOBuilt 1975 · S/N 1098-75N86846Woolard Farms Leasing Inc · Corning, ARBuilt 1974 · S/N 669-74N86847Kilbourn James A · Happy Valley, ORS/N 432-74N8684CWest Yvonne R · Warrensburg, NYS/N 20-1008N8684DScott Lonnie L · Nikiski, AKBuilt 1958 · S/N 18-6289N8684EMotl Gregory C · Humble, TXBuilt 1976 · S/N 28R-7635195N86854Moore Planting Co Inc · Cary, MSBuilt 1974 · S/N 6-74N86863Pruitt Leland L · Jones, LABuilt 1974 · S/N 36-74N8686YAdvanced Aviation LLC · Midlothian, VABuilt 1969 · S/N 30-1831N86872Chupito Sabrocito LLC · Paso Robles, CABuilt 1974 · S/N 1028-74N86879Knik Flying Club LLC · Anchorage, AKBuilt 1975 · S/N 856-75N8687CMorgigno Daniel A · Mission Viejo, CABuilt 1953 · S/N 22-1358N8687VCollum Aviation LLC · Milton, FLBuilt 1975 · S/N 184-75N86883High Exposure Inc · Wilmington, DEBuilt 1974 · S/N 680-74N86885Mason Peter Trustee · Santa Paula, CABuilt 1974 · S/N 37-74N8688DHarmon Mike D · Mansfield, SDS/N 18-6295N8688VHawkeye Aviation LLC · Newport, ARBuilt 1975 · S/N 1096-75N8688YMager Robert R · Quakertown, PABuilt 1969 · S/N 30-1834N86890E-Commerce Education Foundation · Tulsa, OKBuilt 1974 · S/N 443-74N86892Goodman Jack · Memphis, TNBuilt 1974 · S/N 296-74N8689VZacheis Henry M · Fairbanks, AKBuilt 1975 · S/N 841-75N8689YBlue Sky Aviators LLC · Winnebago, ILBuilt 1969 · S/N 30-1835N868BBahrns Phyllis Alyene · Effingham, ILBuilt 2007 · S/N 71067N868KWeber Jennifer R · Bryan, TXBuilt 2011 · S/N BLM-2N868KFSmith Jason · Calliham, TXBuilt 2000 · S/N 3124N868LHJones Aircraft Co LLC · Cross Plains, TNBuilt 2007 · S/N S1903N868MMUhl Gregory R · Columbus, MSBuilt 2019 · S/N 81733N868PProfessional Training Aircraft LLC · Wilmington, DEBuilt 2018 · S/N 2843949N868PKYellow Therapy LLC · Kalispell, MTBuilt 1982 · S/N 18-8209021N868RTMartin John D · Billings, MTS/N 18-7809119N868SAS O W Aviation LLC · Crystal River, FLS/N 17266439N868UInter American University Of Puerto Rico · Bayamon, PRBuilt 2026 · S/N 28020268N868XGuhr Robert · Stockholm, NJBuilt 2006 · S/N 2351N86901Rudderow Preston Trustee · Anchorage, AKBuilt 1974 · S/N 23-74N86911Schneberger Bart A · Nome, AKBuilt 1974 · S/N 25-74N86919Latham Ray H · Raymond, WABuilt 1946 · S/N 1281N8691COrtet Craig A · Etna, WYBuilt 1953 · S/N 22-1331N8691VAviation Specialists LLC · Wilmington, DES/N 1097-75N8691YVan Bladeren John A · Tigard, ORBuilt 1969 · S/N 30-1837N86928Collum Aviation LLC · Milton, FLBuilt 1974 · S/N 32-74N8692CTexas Air And Space Museum Inc · Amarillo, TXBuilt 1992 · S/N 001N8692DBryan Kirk J · Big Timber, MTS/N 18-6298N8692VLohr Martin J · Petersburg, AKBuilt 1975 · S/N 831-75N8692YTedder Ag Technologies Inc · Walsh, COBuilt 1969 · S/N 30-1838N86936Lewis Aviation Inc · Wilmington, DEBuilt 1974 · S/N 444-74N8693VMichael A Levenhagen · North Fort Myers, FLBuilt 1975 · S/N 185-75
Back to AD 90-04-06 R1