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.

N4032FDmnm LLC · Albuquerque, NMBuilt 1958 · S/N 36932N4035FGinn Ray Jr · Beeville, TXBuilt 1958 · S/N 36935N4037FSicaras Paul G · Longmont, COBuilt 1958 · S/N 36937N4038FKcantarano LLC · Mukilteo, WABuilt 1958 · S/N 36938N4039FBlue Ice Aviation Inc · Wasilla, AKS/N 36939N403CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13237N403EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2021 · S/N 172S12639N403FRBas Part Sales LLC · Greeley, COS/N 17280245N403GFSky Mates Inc · Wilmington, DEBuilt 2005 · S/N 172S9918N403SPHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1999 · S/N 172S8295N4042FTweedle Dee LLC · John Day, ORBuilt 1958 · S/N 36942N4043FFinley Trevor S · Caddo Mills, TXS/N 36943N4045FRobinson Jeffrey A · Gaines, MIBuilt 1956 · S/N 36945N4046FVyatkin Denis · Sacramento, CAS/N 36946N4047FRegistration Pending · Sherwood, WIRegistration pendingBuilt 1958 · S/N 36947N4049FSouthwell Arthur M · Arcadia, FLBuilt 1958 · S/N 36949N404DCN404dc LLC · Kennesaw, GABuilt 2023 · S/N 172S13065N404EPSkywest Leasing Inc · St George, UTBuilt 2014 · S/N 172S11436N404FREdb Air Inc · Wilsonville, ORBuilt 1997 · S/N 17280282N404SWWood Roger W · Sale Creek, TNBuilt 1968 · S/N 17256702N4050FTitensor Shanelle Bn · Tetonia, IDS/N 36950N4051FTamargo Victor · Fort Worth, TXBuilt 1958 · S/N 36951N4054FSterbonic Peter D · Wickenburg, AZS/N 36954N4055FFerguson Richard Trustee · Canyon Lake, TXBuilt 1958 · S/N 36955N4056FMullen Mark M · Livermore, CABuilt 1958 · S/N 36956N4059FDoss Lonny Richard · Lake Charles, LABuilt 1958 · S/N 36959N405EFEagle Flying Club Of Embry Riddle Aeronautical · Daytona Beach, FLBuilt 2012 · S/N 172S11154N405ESIasco Flight Training Inc · Redding, CABuilt 1997 · S/N 17280219N405FAWestosha Flying Club Inc · Kenosha, WIBuilt 2003 · S/N 172S9405N405JMGibson William · Aberdeen, MSS/N 17251766N405MWWarin Michael R · Pella, IABuilt 1963 · S/N 17250433N405SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1999 · S/N 172S8298N4060GCm3 LLC · North Las Vegas, NVS/N 17264771N4061FHuston Aviation LLC · Fort Worth, TXBuilt 1958 · S/N 36961N4062FCharlotte Air Services · Charlotte, MIBuilt 1958 · S/N 36962N4063FHand Tod E · Copper Center, AKBuilt 1958 · S/N 36963N4066FGray Chet K · Midland, TXBuilt 1958 · S/N 36966N4069FDmac Aircraft LLC · Savannah, GABuilt 1958 · S/N 36969N406EPChristiansen Aviation LLC · Wilmington, DEBuilt 2014 · S/N 172S11437N406FRLunken Flight Training Center LLC · Cincinnati, OHS/N 17280297N406JASpartan Education LLC · Tulsa, OKBuilt 2007 · S/N 172S10628N406PTMurray John J · Kalispell, MTBuilt 1981 · S/N 172RG0801N406TAAircraft Unlimited Inc · Pierre, SDBuilt 2003 · S/N 172S9406N4071FQuebedeaux Steven R · Sunset, LABuilt 1958 · S/N 36971N4073FStebbins Craig S · Glendive, MTBuilt 1958 · S/N 36973N4075FPrice Timothy C · Rancho Cucamonga, CABuilt 1958 · S/N 36975N4076FStebbins Robert A · Cookson, OKS/N 36976N4077FSolomon Joseph E Jr · Modesto, CABuilt 1958 · S/N 36977N4078FJanes Christopher D · Columbia, KYBuilt 1958 · S/N 36978N4079FCovington Gary N · Midland, TXFirst renewal noticeBuilt 1958 · S/N 36979
Back to AD 90-06-03 R1