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.

N725ZNLaramie Flying Club Inc · Laramie, WYBuilt 1979 · S/N 17272734N7260AChristiansen Aviation LLC · Wilmington, DEBuilt 2000 · S/N 17280861N7261ACassity Michael D · Springfield, MOBuilt 1956 · S/N 29361N7261GKindblade Aeronautics LLC · Casper, WYBuilt 1970 · S/N 17258961N7261QSchilling Aviation Services LLC · Salina, KSS/N 17260561N7261ZChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9080N7262QFlikins Barbara L · Fillmore, CABuilt 1972 · S/N 17260562N7262XFlight School Of Gwinnett Inc · Lawrenceville, GAS/N 17280993N72639Dischler Stephen · New Lisbon, WIBuilt 1999 · S/N 17280806N7263AHillside Farms · Elaine, ARBuilt 1956 · S/N 29363N7263GHardy Chad A · Rush City, MNBuilt 1970 · S/N 17258963N7263QWyatt Barbara Louise · Cheyenne, WYBuilt 1972 · S/N 17260563N7263TScheler Thomas · Independence, ORS/N 46863N7264ABridge Creek Logging Inc · Mount Vernon, ORBuilt 1956 · S/N 29364N7264QAdams Rick B · Ashford, WABuilt 1972 · S/N 17260564N72653Atp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280807N7265BHolladay Aviation LLC · Jacksonville, FLBuilt 1999 · S/N 17280749N7265TKor Aviation LLC · Piedmont, SDBuilt 1959 · S/N 46865N7265YAv8r LLC · Manchester Center, VTBuilt 1999 · S/N 17280768N7265ZAtp Aircraft 2 LLC · Wilmington, DEBuilt 1999 · S/N 17280769N72662Jwa Flight School LLC · Bolingbrook, ILBuilt 1999 · S/N 17280817N72664Advanced Aviation Group LLC · Frederick, MDBuilt 1999 · S/N 17280818N7266ABrooks David A · East Dorset, VTBuilt 1956 · S/N 29366N7266DMelbourne Flight Training LLC · Melbourne, FLBuilt 1979 · S/N 17272912N7266QLima-001 LLC · Muscatine, IABuilt 1972 · S/N 17260566N7266TNobles Gary Allen · Winnsboro, LAS/N 46866N72675Chapel Hill Flying Club Inc DBA · Sanford, NCBuilt 2001 · S/N 172S8977N7267GWells Jack D · Newtown, MOBuilt 1970 · S/N 17258967N7268TParker Harold E · Cabot, ARFirst renewal noticeBuilt 1959 · S/N 46868N7269GBranson Barry R · Shasta Lake, CABuilt 1970 · S/N 17258969N7269QBaker Mark · White Bear Lake, MNBuilt 1972 · S/N 17260569N726CPCivil Air Patrol · Maxwell Afb, ALBuilt 2015 · S/N 172S11566N726EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13029N726JHClearview Flying Club Inc · Westminster, MDBuilt 1977 · S/N 17269494N726LUTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N 172S13587N726MBBurgos Orlando · Venice, FLBuilt 1982 · S/N 17275766N726MMRiverside Flight Academy LLC · Riverside, CABuilt 1979 · S/N 17272970N7270GBruneau Paul G Jr · Madison, MEBuilt 1970 · S/N 17258970N7270TBudenbender Philip W · Weatherford, TXBuilt 1959 · S/N 46870N7271AEinck Matthew J · Fort Worth, TXS/N 29371N7272AOpen Air Ltd Co DBA · Pella, IABuilt 1956 · S/N 29372N7273AMartin Randal O · Oak Point, TXBuilt 1956 · S/N 29373N7273MPalm Beach Flight Training Corp · Lantana, FLBuilt 1999 · S/N 17280761N7274TN8653u LLC · Fairbanks, AKBuilt 1959 · S/N 46874N7275AZelinski Jeffrey C · Watersmeet, MIS/N 29375N7275CAvolant Aviation LLC · Mooresville, NCBuilt 1999 · S/N 17280503N7275DMoody Bible Institute Of Chicago · Spokane, WABuilt 1999 · S/N 17280790N7275REdb Air Inc · Wilsonville, ORBuilt 1999 · S/N 172S8026N7275TBeets Larry Joe · Columbia, MSBuilt 1959 · S/N 46875N7276AAved Consulting LLC · Edgewater, FLBuilt 1956 · S/N 29376
Back to AD 90-06-03 R1