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.

N75649New Horizons Aviation Inc · Goshen, INBuilt 1976 · S/N 17267872N7564DOtto Bryant C · Conway, ARBuilt 1957 · S/N 18-5846N7564GRegistration Pending · Sterling, AKRegistration pendingBuilt 1970 · S/N 17259264N7564KCameron James T · Seldovia, AKBuilt 1950 · S/N 18-279N75650Strittmatter Joseph · Aubrey, TXBuilt 1943 · S/N 75-8640N75651Hansen Robert Alan · Horseheads, NYBuilt 1976 · S/N 17267873N75655Doane Dale A · Moreland, GABuilt 1976 · S/N 17267874N7565DSiegle Daniel L · Birdsboro, PABuilt 1979 · S/N 17272923N7565GB&R Aircraft LLC · Wadsworth, OHBuilt 1970 · S/N 17259265N7565JSteffensen David J · Grimesland, NCBuilt 1968 · S/N 28R-30943N7565KReeder Don W · Rathdrum, IDBuilt 1950 · S/N 18-280N7565RKnox County Flying Club · Owls Head, MES/N 28-22129N7565VRehwald William J S · Santa Monica, CAS/N 177RG0856N7565WHurdle Scott R · Clemmons, NCBuilt 1963 · S/N 28-1506N7565YVictor Robert W Jr · Topeka, KSBuilt 1964 · S/N 30-629N75668Allen Richard P · Southampton, NJBuilt 1943 · S/N 75-8710N7566KHorseshoe Bar Land & Livestock LLC · Gillette, WYBuilt 1950 · S/N 18-283N7566PLambert Dwight E · Albany, ORBuilt 1961 · S/N 24-2777N7566RHill Bruce W · Newton, ILBuilt 1966 · S/N 28-22130N7566WStrobel Gary D · Mooresville, NCBuilt 1964 · S/N 28-1507N7566YS & D Adventure LLC · Middletown, DEBuilt 1964 · S/N 30-630N75673Durner Charles L · Simla, COBuilt 1944 · S/N 75-8749N7567FMansfield Heliflight Inc · Milton, VTS/N 234-70N7567GWhipple Eugene B · Mchenry, ILBuilt 1970 · S/N 17259267N7567HGuidici Aidan G · San Antonio, TXS/N 12-437N7567JFidelis Universal Technology Inc · Chino Hills, CABuilt 1968 · S/N 28R-30946N7567PSteigerwalt Jeffrey A · Lehighton, PABuilt 1961 · S/N 24-2778N7567RThomas Baley B · Zavalla, TXFirst renewal noticeBuilt 1966 · S/N 28-22131N7568FTranbarger Tad E · Macksville, KSBuilt 1969 · S/N 229-70N7568JRoberts Donald B · Albion, ILBuilt 1968 · S/N 28R-30947N7568VPawlish Andrew M · Fort Collins, COBuilt 1976 · S/N 177RG0859N7569DThiele Tamara L · Anchorage, AKBuilt 1957 · S/N 18-5854N7569FMainero Tanner R · Chehalis, WABuilt 1969 · S/N 731-70N7569GAirborne LLC · Wilmington, DEBuilt 1970 · S/N 17259269N7569HCompton Steven · East Northport, NYBuilt 1946 · S/N 12-439N7569PBrowne Donald K · Labelle, FLBuilt 1961 · S/N 24-2780N7569VLiberty Capital LLC · Kalispell, MTBuilt 1976 · S/N 177RG0860N756AAtp Aircraft 6 LLC · Wilmington, DEBuilt 2007 · S/N 4496244N756AWLincoln Skyways Inc · Lincoln, CABuilt 1976 · S/N 17267877N756DFFroster David C · Ravenna, MIBuilt 2021 · S/N 60330N756GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881462N756WRegistered aircraftBuilt 1999 · S/N 20756N75701Roseville Aviation LLC · Roxboro, NCBuilt 1976 · S/N 17267883N75704Lanning 1 Aviation LLC · Amarillo, TXBuilt 1976 · S/N 17267886N75706Morey Airplane Company Inc · Middleton, WIBuilt 1976 · S/N 17267888N75709Newsom Richard W · East Bend, NCS/N 17267890N7570FReichelt Christopher M · Mocksville, NCBuilt 1970 · S/N 235-70N7570HSearles Lewis A Jr · Grafton, OHBuilt 1946 · S/N 12-440N7570JHubbard David L · Earlville, ILS/N 28R-30950N7570KStrub Henry J · Dillingham, AKBuilt 1950 · S/N 18-285
Back to AD 90-04-06 R1