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.

N716SCJuliet Charlie Aviation LLC · Oregon City, ORBuilt 2020 · S/N 172S12557N716SPExec 1 Aviation II LLC · Ankeny, IABuilt 2000 · S/N 172S8645N716THFairmont State University · Fairmont, WVBuilt 2017 · S/N 172S12008N7170GSs Skyways LLC · Becker, MNBuilt 1969 · S/N 17258870N7171QMcnamara Bradley W · Seattle, WABuilt 1972 · S/N 17260471N7172QRounds Agronomy LLC · Pierre, SDS/N 17260472N7173ADuke Billy L · Ormond Beach, FLBuilt 1956 · S/N 29273N7173GSale Reported · Haiku, HISale reportedBuilt 1969 · S/N 17258873N7173QWesterly Av Group LLC · Westerly, RIS/N 17260473N7173TDidier Thomas · Port Washington, WIS/N 46773N7174GMaloney John T · Deer Park, NYBuilt 1969 · S/N 17258874N7174TPaddock Spencer · Palmer, AKBuilt 1960 · S/N 46774N71755Jet Air Inc · Iowa City, IABuilt 1999 · S/N 17280800N7175GMontgomery Monty · Cave Spring, GABuilt 1969 · S/N 17258875N7175TTischer William D · Shoreview, MNBuilt 1959 · S/N 46775N7176ASwierk Joshua J · Valdez, AKS/N 29276N7176QJax Beach Aviation LLC · Jacksonville, FLBuilt 1972 · S/N 17260476N7176TRabe Robert · Elk Grove, CAS/N 46776N7177GCoats George A · The Woodlands, TXBuilt 1969 · S/N 17258877N7177QLeonard William K · Seattle, WABuilt 1972 · S/N 17260477N7177TLefevers Adam · Pineville, KYS/N 46777N7178QSkylens LLC · Hammond, LABuilt 1972 · S/N 17260478N7178TGouin Cristina Clara · Fort Pierce, FLBuilt 1959 · S/N 46778N717CEHuffman Jacob M III · Burleson, TXBuilt 1976 · S/N 17267113N717FGRidgeline Assets LLC · Wilmington, DEBuilt 2025 · S/N 172S13456N717GMustang Sally Aviation LLC · Camden, SCBuilt 1976 · S/N 17267597N717LULiberty University Inc · Lynchburg, VABuilt 2022 · S/N 172S12777N717MEMotormod LLC · Florence, SCS/N 17273458N717RCDmac Aircraft LLC · Savannah, GAS/N 36346N717RFWings Flight Enterprises Inc · Danville, KYBuilt 1977 · S/N 17269901N717THOhio State University · Columbus, OHBuilt 2017 · S/N 172S12009N717VVSouthern Kentucky Flying Club LLC · Bowling Green, KYBuilt 1964 · S/N 17252246N7180GPearman Properties LLC · Branson, MOBuilt 1970 · S/N 17258880N7181AWarmkessel James R · Felton, CABuilt 1956 · S/N 29281N7181TSwanson G N · Meridian, IDBuilt 1959 · S/N 46781N7182AEdm Flying Inc · Nevada, MOBuilt 1956 · S/N 29282N7182GBar-Od-4 Cattle Co LLC · Laredo, TXBuilt 1969 · S/N 17258882N7182TTdp LLC · Caldwell, IDBuilt 1959 · S/N 46782N7183AElk & Ram Aviation Group LLC · San Antonio, TXBuilt 1956 · S/N 29283N7183QFlying Wild LLC · Yarmouth, MEBuilt 1972 · S/N 17260483N7184AGarrison Randy L · Queen City, TXBuilt 1956 · S/N 29284N7184THelderman Laban W · Newton, NCS/N 46784N7185GJones Mark R · Denton, MDS/N 17258885N7186AValiair Lc Trustee · Casper, WYBuilt 1956 · S/N 29286N7187AHannah David W · Richmond, TXBuilt 1956 · S/N 29287N7187QChestnut Ridge Flying Club · Latrobe, PABuilt 1972 · S/N 17260487N7188GVrechek Joseph D · Fort Lauderdale, FLS/N 17258888N7188QToles Chad · Austin, TXFirst renewal noticeBuilt 1972 · S/N 17260488N7189APierson Janice R Trustee · Scio, ORBuilt 1956 · S/N 29289N7189GSky Hawk Flying Club · Grand Rapids, MNBuilt 1969 · S/N 17258889
Back to AD 90-06-03 R1