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.

N1766VCode4 Ventures Inc DBA · Waynesboro, VABuilt 1974 · S/N 17263744N1768VBrown Craig D · Fort Wayne, INBuilt 1974 · S/N 17263745N176BLChristiansen Aviation LLC · Wilmington, DEBuilt 2013 · S/N 172S11287N176ERSkywarrior Flight Training LLC · Pensacola, FLS/N 17269507N176LGTita Enterprises LLC · Apex, NCS/N 172RG0074N176MEEastern Cincinnati Aviation Inc · Batavia, OHBuilt 2000 · S/N 172S8470N176TAGeorge'S Aviation Services Inc · Honolulu, HIBuilt 2018 · S/N 172S12115N1772FTia Aviation LLC · Hot Springs, ARBuilt 1966 · S/N 17255167N1773FRegistration Pending · Jasper, ALRegistration pendingBuilt 1966 · S/N 17255168N1774FBarnstormers Aero Services Inc · Lompoc, CABuilt 1966 · S/N 17255169N1774TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12111N1774VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263747N1778FBlake Brian R · Irvine, CABuilt 1966 · S/N 17255173N1781TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12112N1782FCfi Care Inc · Woodbury, CTS/N 17255177N1782TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12113N1784FTompkins Wyatt · Pearland, TXBuilt 1966 · S/N 17255179N1785FSale Reported · Farragut, TNSale reportedBuilt 1966 · S/N 17255180N1787FSchroder Robert D · Buckeye, AZBuilt 1966 · S/N 17255182N1788TFlight Operations Aircraft LLC · Wilmington, DEBuilt 2017 · S/N 172S12114N178AFSoutheast Aircraft Leasing LLC · Jacksonville, FLBuilt 2003 · S/N 17281177N178CPCivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13039N178FVD R Tripp Enterprises LLC · Omaha, NEBuilt 1976 · S/N 17267284N178GWBravo Aircraft LLC · Ooltewah, TNBuilt 2020 · S/N 172S12491N178KASwartzentruber Robert · Oakland, MDBuilt 1971 · S/N 17260069N178RSDowns Austin J DBA · Liberal, KSBuilt 1974 · S/N 17262925N1790FTaylor Henry F · Urbana, OHBuilt 1966 · S/N 17255185N1791VOmargows Ali · Columbus, OHBuilt 1974 · S/N 17263752N1793VAviation Capital Management LLC · San Jose, CABuilt 1974 · S/N 17263753N17BMNavigation Leasing LLC · Castle Rock, COBuilt 2023 · S/N 172S12978N17BSSell William T · Orofino, IDBuilt 1965 · S/N 17252856N17GMNorthwestern Michigan College · Traverse City, MIBuilt 2021 · S/N 172S12769N17HZLeading Edge Flight Academy LLC · Bend, ORBuilt 1975 · S/N 172-66345N17MVNorthwestern Michigan College · Traverse City, MIBuilt 2020 · S/N 172S12598N17NJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274527N17SJAnson Air LLC · Sugar Land, TXBuilt 1999 · S/N 172S8344N17SMN17sm LLC · Coral Springs, FLS/N 17272967N17UPRhinelander Flying Service Inc · Rhinelander, WIBuilt 1974 · S/N 17263440N1802VWard Robert L Jr · Cleburne, TXBuilt 1974 · S/N 17263756N1803YOfficial Stripes LLC · New Braunfels, TXBuilt 1962 · S/N 17249403N1804YSnader Douglas E · West Linn, ORBuilt 1962 · S/N 17249404N1806MCareer Track 2 LLC · Wilmington, DEBuilt 2024 · S/N 172S13177N1806YMadcity Aviation LLC · Madisonville, KYBuilt 1962 · S/N 17249406N1808YHardy Russell L · Rimrock, AZBuilt 1962 · S/N 17249408N180CPCivil Air Patrol · Maxwell Afb, ALBuilt 2021 · S/N 172S12727N180KSSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1985 · S/N 17276467N180NYN180ny LLC · Wainscott, NYBuilt 1978 · S/N 17271141N180SUOhio State University · Columbus, OHBuilt 2018 · S/N 172S12161N1810YLussier Lisa · Greene, RIFirst renewal noticeBuilt 1962 · S/N 17249410N1812EAtp Aircraft 6 LLC · Wilmington, DEBuilt 2018 · S/N 172S12168
Back to AD 90-06-03 R1