OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,683

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-06-03-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-06-03-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.

N52712Macmillan Elizabeth A · Franklin, MABuilt 2002 · S/N 172S9192N5271RSpriggs Gary W · Grass Valley, CABuilt 1974 · S/N 17263485N5271U71 Uniform Corp · The Villages, FLBuilt 1980 · S/N 172RG0316N52720Rick Aviation Inc · Newport News, VABuilt 1981 · S/N 17274592N5272NMaddie LLC · Hinton, WVBuilt 2009 · S/N 172S10999N5272RRichmond Pilots Corp · Linden, NJBuilt 1974 · S/N 17263486N52731Bravo Leasing LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10974N5273RClear Prop Aviation LLC · Sterling, VABuilt 1974 · S/N 17263487N5273UKatola LLC · Anaheim, CABuilt 2002 · S/N 172S9193N52747Unicorn Papa Air LLC · Longwood, FLBuilt 1981 · S/N 17274598N52749Middle Tennessee State University · Murfreesboro, TNS/N 17274599N5274HLincoln Skyways Inc · Lincoln, CABuilt 1975 · S/N 17265392N5274VH & R Aviation LLC · West Linn, ORBuilt 2009 · S/N 172S11005N52750Wieneke Robert A · Rockwall, TXBuilt 1981 · S/N 17274600N5275S75s Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 172S9203N5275WMustang Sally Aviation LLC · Camden, SCS/N 172S10938N5276PBellers Aviation Inc · Fremont, CABuilt 2009 · S/N 172S11010N5277EJefredo Corp · Zephyrhills, FLS/N 17271809N52789Alameda Aero Club · Alameda, CABuilt 1981 · S/N 17274607N5278DN5278d LLC · Dover, DEBuilt 1979 · S/N 17272488N5278RHussain Mahmoud Taimour Said · Miami, FLBuilt 1974 · S/N 17263492N52794Hawk Flyer 794 LLC · San Bruno, CABuilt 2002 · S/N 172S9211N5279DDay Aviation Inc · Wilmington, DEBuilt 1979 · S/N 17272489N5279GArnold Jason Mcree · Watkinsville, GABuilt 1979 · S/N 17273558N527ANDaisy Aviation LLC · Beavercreek, OHBuilt 1965 · S/N 17252779N527DSSkyhawk Leasing LLC · Greenfield, INBuilt 2004 · S/N 172S9588N527NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2008 · S/N 172S10818N52806Skywarrior Flight Training Inc · Pensacola, FLBuilt 1981 · S/N 17274610N5280DHdw Florida Helicopters Inc · Pompano Beach, FLBuilt 2002 · S/N 172S9212N5280EStreeter Byrand DBA · Newcastle, WYBuilt 1978 · S/N 17271810N5280MN5280m LLC · Elizabeth, COBuilt 1979 · S/N 17273671N5280RSpringbrook Leasing LLC · Daytona Beach, FLBuilt 2002 · S/N 172S9216N5280UStrantz Roger J · Denton, TXBuilt 1980 · S/N 172RG0320N52815S & S Aircraft Inc · Bennington, VTBuilt 1981 · S/N 17274612N52818Aeroluxe Aviation LLC · Nashville, TNBuilt 1981 · S/N 17274615N5281JHowell Jason · Newaygo, MIBuilt 1980 · S/N 17273753N52820Morrison Wanda L · Farmington Hills, MIS/N 17274616N5282KBaer Monte Wayne · Ronan, MTS/N 17274042N52837Registration Pending · West Warwick, RIRegistration pendingBuilt 1981 · S/N 17274617N5283EYummy Apple LLC · Mesa, AZBuilt 1978 · S/N 17271812N5283JMarianas Air Transfer Inc · Tinian, MPBuilt 1980 · S/N 17273754N5283KNorthwest Wings LLC · Hillsboro, ORBuilt 1980 · S/N 17274043N5283RFellow Ship Aviation LLC · Monticello, GABuilt 1974 · S/N 17263497N52841Skywarrior Flight Training Inc · Pensacola, FLS/N 17274618N52842Hayes Chris L · Kenai, AKBuilt 1981 · S/N 17274619N5284DCharlie Lima 1 LLC · Jacksonville, FLBuilt 1979 · S/N 17272493N5284EIntermill Alice R · Volga, SDBuilt 1978 · S/N 17271813N5284QWings Over Texas Holdings LLC · Denton, TXBuilt 1973 · S/N 17261776N5284RDahlke Philip H · Smyrna, GABuilt 1974 · S/N 17263498N5284SFly America Inc · Stanford, CABuilt 2010 · S/N 172S11026
Back to AD 90-06-03 R1