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.

N6414ETobin Cory J · Cheney, WAS/N 46514N64154Jw Skyhawk LLC · Austin, TXBuilt 1975 · S/N 17265049N64155Lowcountry Flight LLC · Johns Island, SCBuilt 1975 · S/N 17265050N64157Christensen Jeffrey S · Wisconsin Rapids, WIBuilt 1975 · S/N 17265052N64159Flying 14 LLC · Spokane, WABuilt 1975 · S/N 17265053N6415RAlpine Aviation Of Fayetteville Inc · Prairie Grove, ARBuilt 1979 · S/N 172RG0179N6415VPeter Prince Aviation Center LLC · Milton, FLS/N 172RG0677N64160Glide Slope LLC · East Hampton, NYBuilt 1975 · S/N 17265054N64161Aom Aircraft LLC · Orlando, FLBuilt 1975 · S/N 17265055N64162Mccormick Philip D · Mount Pleasant, IABuilt 1975 · S/N 17265056N64163Good Airplanes LLC · Oshkosh, WIBuilt 1975 · S/N 17265057N64165Weaver Lynwood J Jr · Raleigh, NCBuilt 1975 · S/N 17265059N64173Training Planes LLC · Tampa, FLBuilt 1975 · S/N 17265065N64174Sen Air Inc · Mckeesport, PABuilt 1975 · S/N 17265066N6417ESharpley David Jr · Pittsboro, INBuilt 1959 · S/N 46517N6417JChapman Michael K · North Salt Lake, UTS/N 17273871N64180Spanaflight LLC · Puyallup, WABuilt 1975 · S/N 17265069N64181Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17275529N64184Arlington Flight Services Inc · Arlington, WABuilt 1975 · S/N 17265071N64186Paraloft LLC · Mims, FLBuilt 1975 · S/N 17265072N6418DAirways Aviation Inc · Grand Rapids, MNBuilt 1979 · S/N 17272793N6418ELima-001 LLC · Muscatine, IAS/N 17272019N64191Flycarolina LLC · Concord, NCBuilt 1975 · S/N 17265076N64192Skyhawk Transport LLC · Hazel Green, ALBuilt 1975 · S/N 17265077N64198Randy Goering Inc · Bend, ORBuilt 1975 · S/N 17265080N64199Mutschler George Robert Jr · Bayfield, COBuilt 1975 · S/N 17265081N6419VUrbana Aircraft LLC · Urbana, MDBuilt 1980 · S/N 172RG0680N641NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2015 · S/N 172S11615N641SPRhode Island Air LLC · Providence, RIS/N 172S8049N641THN641th Corp · La Quinta, CABuilt 2021 · S/N 172S12641N64201Registration Pending · Lander, WYRegistration pendingBuilt 1975 · S/N 17265083N64203Vance Nicholas D · Bluffton, OHS/N 17265084N64209Kay Roland C · Wasilla, AKS/N 17265090N6420VKorson James · Yorkville, ILBuilt 1980 · S/N 172RG0681N64213Ajc Aviation LLC · Boca Raton, FLBuilt 1975 · S/N 17265093N64215Registered aircraftBuilt 1975 · S/N 17265095N64217Simplifly LLC · Mesa, AZBuilt 1975 · S/N 17265097N64219American Patrols Inc · Midland, TXBuilt 1975 · S/N 17265098N6421BNord Andrew E · West Columbia, SCBuilt 1956 · S/N 29621N6421EOsborn Jon C · Groveland, FLBuilt 1959 · S/N 46521N64220Wieman Dianne L · Marion, TXBuilt 1975 · S/N 17265099N64224Smith Aviation LLC · Springer, OKBuilt 1975 · S/N 17265103N64228Abbott Cedric M · Buckfield, MEBuilt 1975 · S/N 17265105N64231Driessen James A Jr · Oshkosh, WIBuilt 1982 · S/N 17275538N64232Laurel Highlands Aeronautical Academy · Latrobe, PABuilt 1975 · S/N 17265108N64233Walla Walla University · College Place, WABuilt 1975 · S/N 17265109N64235Skyhawk Flying Club · Marysville, OHBuilt 1975 · S/N 17265110N64236Wright Chris E · Houghton Lake, MIBuilt 1975 · S/N 17265111N64238Global Adventures N64238 LLC · Hollywood, FLBuilt 1975 · S/N 17265112N6423BMolina Rodney R · New Kent, VABuilt 1956 · S/N 29623
Back to AD 90-06-03 R1