OpenAirDocs.org
AD 90-04-06 R1

Registered aircraft · 68,359

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.

N102RHHayes Ronald O · Blue Springs, MOBuilt 1992 · S/N 1316N102SJHelms Robert J · Alton, UTBuilt 1971 · S/N 17259570N102TRegistration Pending · Anchorage, AKRegistration pendingBuilt 1954 · S/N 18-2216N102TCMason Brian L · Eagle River, AKS/N 18-7909038N102UCWest Valley Flying Club · Palo Alto, CABuilt 1980 · S/N 15284832N102VWVan Wagner Aerial Media LLC · Hollywood, FLBuilt 1957 · S/N 18-5806N102WPGarcia Randy S · Montebello, CABuilt 1991 · S/N S1572N102WRSt Onge Adam R · Sterling, AKBuilt 1952 · S/N 20-919N102WZVcxi Red LLC · Sheridan, WYBuilt 2019 · S/N 70737N102ZMann Arthur A III · Cartersville, GABuilt 2019 · S/N 2018-001N10305Blunt Samuel N · Summerville, SCBuilt 1975 · S/N 17702319N1030TZamora Milamaedelza · Panorama City, CAS/N 65N1031SRedmon James A · Frisco, TXBuilt 1977 · S/N 15279996N10329Lissow William M · New Port Richey, FLS/N 22018CN1032JKornegay Kenneth D · Roanoke, VABuilt 1973 · S/N 32N1032SThurber Matthew Calbraith · Vancouver, WABuilt 1980 · S/N 144-HN10339Yarbro Floyd A · Kenton, TNBuilt 1997 · S/N 21022CN1033PProfessional Pilots Inc · Lowell, INBuilt 1954 · S/N 23-35N1033XHorizon Enterprises LLC · Kalispel, MTBuilt 1975 · S/N 28-7515376N1034AHawk Don · Shady Cove, ORS/N 18-606N1034ENexga Aircraft Inc · Greensboro, NCBuilt 1977 · S/N 1205-77N1034XBlasa Randy · Bowling Green, FLS/N 28-7505198N1035EJobe Ronald G · Sedalia, MOBuilt 1977 · S/N 983-77N1035XSocal Blue Side Up LLC · Anaheim, CABuilt 1975 · S/N 28R-7535222N10365Air Heritage Inc · Beaver Falls, PABuilt 1954 · S/N 54-2533N1036JPremier Jets Inc · Hillsboro, ORS/N 36N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079N10375Tactical Turtle LLC · Ortanna, PAS/N 67-18376N1037JTate Andrew E · Chapel Hill, NCBuilt 1973 · S/N 37N1038EFueston Vernon A · Montague, CABuilt 1977 · S/N 971-77N1038FPetrick Dan A · Punta Gorda, FLBuilt 1969 · S/N 28-25552N1038JLandgraf Robert J · Sussex, WIBuilt 1973 · S/N 118N1038NSome Beech LLC · Bolivar, MOS/N 85-0360N1039DPetro Jerry R · Williamsburg, VABuilt 1982 · S/N 50N1039JN1039j LLC · Casa Grande, AZBuilt 1973 · S/N 101N1039MManly James H · Reno, NVBuilt 1998 · S/N 513N1039UIowa Lakes Community College · Estherville, IABuilt 1971 · S/N 34-7250024N1039XSilvered Wings LLC · Howell, MIBuilt 1975 · S/N 28-7525265N103AASmith George Barker · Lexington, KYBuilt 2007 · S/N 2411N103ACKrueger Douglas K Trustee · Aurora, NEBuilt 1992 · S/N 362-92N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084N103BBHarris John F III · Louisburg, NCBuilt 2000 · S/N 2060N103BCPalmer David M · Jacksonville, ORBuilt 2003 · S/N 448-2003N103BHBeck Randy R · Claremont, CABuilt 2021 · S/N 3C-5C/6C-1613CN103BJKempf Randall P · Crawford, COBuilt 1998 · S/N 1N103BMSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 44-8107007N103BSFixed Gear LLC · Sherwood, ARBuilt 1947 · S/N 123988N103BWWilson Billy C · Fort Worth, TXBuilt 2002 · S/N 21511N103CTSocolosky Stephen Gerard · East Hartford, CTBuilt 1973 · S/N 17253365N103DFelling Carl · Grand Junction, COBuilt 1956 · S/N 2
Back to AD 90-04-06 R1