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.

N739WRRaritan Valley Flying School · Princeton, NJBuilt 1978 · S/N 17270869N739WXAce Of Spades Aviation LLC · Las Vegas, NVBuilt 1978 · S/N 17270875N739WYN739wy LLC · Cheyenne, WYBuilt 1978 · S/N 17270876N739WZWhisky Zulu Inc · Port Washington, NYFirst renewal noticeBuilt 1978 · S/N 17270877N739XA7550g LLC · Birmingham, MIS/N 17270878N739XCAllen Danny T · Jonesboro, LABuilt 1978 · S/N 17270880N739XKAirways Aviation Inc · Grand Rapids, MNBuilt 1978 · S/N 17270887N739XLFlyrjf LLC · Weirsdale, FLBuilt 1978 · S/N 17270888N739XMEnstad Ordell J · Goldendale, WABuilt 1978 · S/N 17270889N739XSGorman Patrick M · Deerfield, OHBuilt 1978 · S/N 17270894N739XTS O W Aviation LLC · Crystal River, FLS/N 17270895N739XUTraining Mission Aviation Inc · New Tripoli, PABuilt 1978 · S/N 17270896N739XVAmaro Mark S · Mi Wuk Village, CABuilt 1978 · S/N 17270897N739XWWhole Life Wellness Center · Alpine, TXS/N 17270898N739YESundance Air Services Inc · Alameda, CABuilt 1978 · S/N 17270906N739YHMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270909N739YMHeritage Aviation LLC · Ankeny, IABuilt 1978 · S/N 17270913N739YRF&O Flight LLC · Calhoun, GABuilt 1978 · S/N 17270917N739YURrrr Aviation LLC · Bryan, TXBuilt 1978 · S/N 17270920N739YWPettit Toby B · Morehead, KYBuilt 1978 · S/N 17270922N739YZSocal Aviation Inc · Chino, CABuilt 1978 · S/N 17270925N739ZCP&B Aviation LLC · Watkins, COBuilt 1978 · S/N 17270928N739ZGR & R Aero Services Llcc · Eden Prairie, MNBuilt 1978 · S/N 17270932N739ZHFreeflight Aviation LLC · Allentown, NJBuilt 1978 · S/N 17270933N739ZLLefebvre Jeffrey S · Kaneohe, HIBuilt 1978 · S/N 17270936N739ZNOur Jett LLC · Englewood, COBuilt 1978 · S/N 17270938N739ZPBlue Sky Aviation LLC · Watkins, COBuilt 1978 · S/N 17270939N739ZSPryor James A · Bottineau, NDS/N 17270942N739ZUMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270944N739ZWHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 17270946N739ZXN739zx Flying Association · Kent, WABuilt 1978 · S/N 17270947N739ZZR & R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 17270949N73AGHarrison Albon Wayne Jr · Lake Jackson, TXBuilt 1951 · S/N 20-622N73ALHefel Lori A · Wichita, KSBuilt 1974 · S/N 177RG0559N73AXJensen Steven · Port Angeles, WABuilt 1990 · S/N 11024N73BABob Air Inc · Gastonia, NCBuilt 1948 · S/N 75-8766N73BCVnk Sky Inc · Dover, DEBuilt 1973 · S/N 28-7305263N73BWBravo Whiskey Holdings LLC · Lewis Center, OHBuilt 1977 · S/N 28-7816102N73CMMau Christine A · Niceville, FLBuilt 1997 · S/N 21891N73CVLiberatore A H Bud · Eagle Point, ORBuilt 1973 · S/N C1 5-6-30N73DYoseph Barry L · Olympia, WABuilt 1973 · S/N 1BLN73DCTwin Aviation LLC · Liberty Hill, TXS/N AA1A-0418N73DXAj Airlift LLC · Arlington, MAS/N 2868N73ECBronisevsky Robert · Old Bridge, NJBuilt 1990 · S/N 1187N73FRWayman Luy LLC · Weston, FLBuilt 1979 · S/N 17273134N73FTBerecz Kevin · Parrish, FLBuilt 1978 · S/N AA5A-0662N73GBBotsford Glenn J · Cudahy, WIBuilt 2004 · S/N 70740N73GSHill Gregory A · Romeo, MIBuilt 1973 · S/N 28-7305573N73HUFx Consulting Ltd · Washington, OKBuilt 2026 · S/N 3469N73HYDenniston Tom · Sherwood, ARBuilt 2000 · S/N 2063
Back to AD 90-04-06 R1