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.

N5080ZBrazil Joshua B · Omaha, NEBuilt 1961 · S/N 22-8711N5081SDream Factory Aviation Inc · Henderson, NVBuilt 1971 · S/N 28R-7135081N5081UKiloecho Aeronautics LLC · Tucson, AZBuilt 1971 · S/N 17259673N5081VWalker Gregory S · Gypsum, COBuilt 1977 · S/N VAC-70-77N5081ZTech Mobile LLC · New Windsor, MDBuilt 1961 · S/N 22-8712N50822Nyhus Sharon L · Harvey, NDBuilt 1980 · S/N 17274221N50826Bristol Bay Capital LLC · Watkins, COS/N 17274222N5082GJala Tech Services LLC · Social Circle, GABuilt 1979 · S/N 17273531N5082PShaw Jeryl V · Arcata, CABuilt 1958 · S/N 24-88N5082RWings Over Texas Holdings LLC · Denton, TXBuilt 1974 · S/N 17263320N5082VMorton John W · El Segundo, CABuilt 1977 · S/N VAC-71-77N5082WAmeeti Robert Keith Trustee · Newport Beach, CABuilt 2001 · S/N 172S8970N5082ZHuddleston Anthony A · Knoxville, TNBuilt 1961 · S/N 22-8713N50838Ansee LLC · Seattle, WABuilt 1980 · S/N 17274224N5083KLoewen Wielhelm N · Presidio, TXBuilt 1980 · S/N 17273956N5083SRiser Air LLC · Stillwater, MNBuilt 1971 · S/N 28R-7135082N5083VBarth Charles L · Pekin, ILBuilt 1977 · S/N VAC72-77N5083XFlytails LLC · Pace, MSFirst renewal noticeBuilt 1968 · S/N 155N5083ZMorell Patrick J · Byron Center, MIBuilt 1961 · S/N 22-8714N5084MFabrizio Timothy · Oswego, ILBuilt 1978 · S/N MC-571N5084RBenham Eric T · Las Vegas, NVBuilt 1974 · S/N 17263322N5084WShouse Robert G · Owasso, OKBuilt 1961 · S/N 28-93N50854Fulton Lanny G · Spartanburg, SCBuilt 1968 · S/N 15069600N5085BAccelerated Aviation Instruction LLC · Owatonna, MNBuilt 1979 · S/N 15283739N5085KMartin Bach Aviation LLC · Cornelius, NCBuilt 1980 · S/N 17273957N5085SHall Thomas K · Beaufort, NCBuilt 1971 · S/N 28R-7135085N5085VStumpf Douglas D · Aledo, TXBuilt 1977 · S/N VAC74-77N5085WMartin Marlin Ray Jr · Mabank, TXBuilt 1961 · S/N 28-94N5085XAzzalin Giorgio · Jacksonville, FLS/N 158N5086EPark David W · Placentia, CABuilt 1978 · S/N 17271703N5086RSafety In Motion Flight Center Inc · Puyallup, WABuilt 1974 · S/N 17263324N5086SAero Air Inc · Salt Lake City, UTBuilt 1971 · S/N 28R-7135086N5086XJacono Bruce L · Ramona, CABuilt 1969 · S/N 159N5086ZRichards Curtis A · Troy, MOBuilt 1961 · S/N 22-8718N50873Bastien Peter M · Leesburg, VABuilt 1979 · S/N JR-1N5087JSession Jason E · Higden, ARS/N 17273698N5087KAir Capital Aviators Club · Wichita, KSBuilt 1980 · S/N 17273958N5087LGreen Airport Development Corp · Kemah, TXBuilt 1980 · S/N 15284253N5087WMcgough Craig N · Lancaster, TXBuilt 1961 · S/N 28-96N5087XRichardson Ethan Mack · Mount Pleasant, SCBuilt 1969 · S/N 160N5087YHansen Dewayne E · Fairbanks, AKBuilt 1962 · S/N 18-7894N5088CMike Golf Holdings LLC · Pinellas Park, FLBuilt 1964 · S/N 30-497N5088KG & M Aircraft Inc · Wheat Ridge, COBuilt 1980 · S/N 17273959N5088LRichmor Aviation Inc · Hudson, NYBuilt 1980 · S/N 15284254N5088PKesser Gilbert M · Culpeper, VABuilt 1958 · S/N 24-94N5088RGlacier Equipment LLC · Wasilla, AKBuilt 1974 · S/N 17263326N5088SSwaz Aviation LLC · Mesa, AZBuilt 1971 · S/N 28R-7135089N5088TCox Stephen T · Fairborn, OHBuilt 1968 · S/N MB-343N5088XAmerican Aviation II LLC · Peyton, COS/N 659N5088ZDavis Scott A · Bingham, NEBuilt 1961 · S/N 22-8722
Back to AD 90-04-06 R1