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.

N65735Bredvold Daniel M · Mendota Heights, MNS/N 17275842N65738Mc Collom Perry C · Saint Louis, MOBuilt 2004 · S/N 172S9746N6573DPeabody Jeffery L · Vinemont, ALBuilt 1979 · S/N 17272873N65741Flycarolina LLC · Charlotte, NCBuilt 1982 · S/N 17275846N65742Mustang Sally Aviation LLC · Camden, SCS/N 17275847N65743University Of Central Missouri · Warrensburg, MOBuilt 1982 · S/N 17275848N65745Mustang Sally Aviation LLC · Camden, SCBuilt 2004 · S/N 172S9748N65746Son Cameron D · Groveland, FLFirst renewal noticeBuilt 1982 · S/N 17275851N6574DFly Carolina LLC · Concord, NCBuilt 1979 · S/N 17272874N6574GPplforu LLC · Fort Worth, TXBuilt 1979 · S/N 17273608N65750Christiansen Aviation LLC · Wilmington, DEBuilt 1982 · S/N 17275855N65752Owens Flight Training LLC · Lafayette, LABuilt 1982 · S/N 17275857N65753Flying Bulldogs LLC · Joplin, MOBuilt 1982 · S/N 17275858N65758American Patrols Inc · Midland, TXBuilt 1982 · S/N 17275862N65767Chu'S Sky LLC · Brandon, FLBuilt 1982 · S/N 17275871N65770Thompson Clinton J · Greer, SCBuilt 1982 · S/N 17275874N65772Sky Adventure LLC · Bartlett, TNBuilt 1982 · S/N 17275875N65773Ial Corp · Lewes, DEBuilt 1982 · S/N 17275876N65775Ristrim Eric · Henderson, NVBuilt 1982 · S/N 17275878N65776Meridian Aviation Holding Company · Teterboro, NJBuilt 1982 · S/N 17275879N6577HRegistered aircraftBuilt 1975 · S/N 17265496N6577RAir Echo Alpha 51 LLC · Erie, COBuilt 1979 · S/N 172RG0203N65784Ohio State University · Columbus, OHBuilt 1982 · S/N 17275884N65789Burket George C · North Hollywood, CABuilt 1982 · S/N 17275888N65790Horan Peter · North Easton, MABuilt 2005 · S/N 172S9787N65795Bank Of Utah Trustee · Salt Lake City, UTS/N 172S9977N65798Samons David M · Phoenix, AZBuilt 1982 · S/N 17275894N657EREmbry-Riddle Aeronautical University · Prescott, AZBuilt 2020 · S/N 172S12455N657SPChristiansen Aviation LLC · Wilmington, DEBuilt 1998 · S/N 172S8062N65813Northwest Wings LLC · Hillsboro, ORBuilt 1983 · S/N 17275896N65815Montgomery David A · Mancelona, MIS/N 17275897N6581VSimmons Claude E · Ocracoke, NCBuilt 1980 · S/N 172RG0777N65821Goodley Scott Val · Denton, TXBuilt 1982 · S/N 17275899N65841Just Plane Stuff Inc · Jackson, MSBuilt 2004 · S/N 172S9763N65842Holladay Aviation LLC · Jacksonville, FLBuilt 1983 · S/N 17275906N65866Planenutz LLC · Deland, FLBuilt 1983 · S/N 17275908N6586HOracle Aviation LLC · Omaha, NEBuilt 1975 · S/N 17265498N65872Channel Islands Aviation Inc · Camarillo, CABuilt 1983 · S/N 17275909N6587EG & M Aircraft Inc · Wheat Ridge, COBuilt 1978 · S/N 17272040N6588HSwanson David L · Rolling Meadows, ILBuilt 1975 · S/N 17265500N65892Amelia Airways LLC · Boynton Beach, FLFirst renewal noticeBuilt 1983 · S/N 17275914N658EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2020 · S/N 172S12539N658LMLge Flying Club Inc · Marietta, GABuilt 1973 · S/N 17261599N658MACantele Joseph D · Hickory Hills, ILBuilt 2000 · S/N 172S8529N658NVJp Aero Holdings Inc · Carson City, NVBuilt 1981 · S/N 17275439N658XLMertz George H III · Reading, PABuilt 1997 · S/N 17280096N65909Oldwater Trailers Inc · Wilmington, DEBuilt 1983 · S/N 17275920N6591EWay Robert Louis · Morristown, AZBuilt 1978 · S/N 17272041N65923Noste Erik · Mount Vernon, WABuilt 1983 · S/N 17275923N65956Ameriflyers Of Texas Inc · Addison, TXS/N 172S9829
Back to AD 90-06-03 R1