OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,681

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.

N1395YEisele William Robert · Alt Loma, CABuilt 1961 · S/N 17249095N1396YGarrison Shannon · Pangburn, ARS/N 17249096N13974Total Prf LLC · New Smyrna Beach, FLBuilt 2006 · S/N 172S10409N1397URock Solid Aviation LLC · Lake Charles, LABuilt 1976 · S/N 17267068N1397YMeyer Richard L · Fort Wayne, INBuilt 1961 · S/N 17249097N13986Euro 2000 Inc · Merritt Island, FLBuilt 2008 · S/N 17281503N1398EMichael Elan · Encino, CABuilt 1978 · S/N 17270985N1399UOc 172 Group LLC · Costa Mesa, CAFirst renewal noticeBuilt 1976 · S/N 17267070N139BTTaylor Edward S · Billings, MTBuilt 1957 · S/N 29707N139ERRick Aviation Inc · Newport News, VABuilt 1985 · S/N 17276532N139METotal Flight Aircraft Leasing LLC · Apex, NCBuilt 2000 · S/N 172S8423N139TWMcghee James Allen · Houston, TXBuilt 2002 · S/N 172S9139N139UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11488N13CBT&W Aviation LLC · Pinehurst, TXBuilt 1981 · S/N 17274805N13HNAb Prop Plane II LLC · Metairie, LABuilt 2024 · S/N 172S13255N13JTHoltzclaw Timothy M · O Brien, FLBuilt 1972 · S/N 17261008N13KKSanders Flight Training Center Inc · Jasper, ALBuilt 1977 · S/N 17268760N13SKFlydreams Aircraft Group Inc · Fort Lauderdale, FLBuilt 1978 · S/N 17271183N13SPNew York State Police · Latham, NYBuilt 1967 · S/N 17256431N13TATextron Aviation Inc · Wichita, KSS/N 17276111N13TPLehman Aviation LLC · Remington, INBuilt 1976 · S/N 17267454N13YPBlock Scott M · Chandler, AZBuilt 1968 · S/N 17257055N14008Suburban Air Corp · Castro Valley, CABuilt 2005 · S/N 172S9886N1400FBingham Edward K · Buchanan, GABuilt 1966 · S/N 17254895N1400HAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10410N1401EUnited States Air Force Aero Club · Usaf Academy, COBuilt 1978 · S/N 17270986N1402FRegistration Pending · Pomona, CARegistration pendingBuilt 1966 · S/N 17254897N1402YRg Enterprises LLC · Tullahoma, TNBuilt 1961 · S/N 17249102N1403FGoedeker Jr Werner F · Waterville, NYBuilt 1966 · S/N 17254898N1403RMy Way Aviation LLC · Weston, FLS/N 172S9877N1403VSmith Dennis A Trustee · Salem, ORBuilt 1974 · S/N 17263550N1405UGuardian Aerial Patrol LLC · Edmond, OKBuilt 1976 · S/N 17267075N1405YImrich Thomas S · Mercer Island, WABuilt 1961 · S/N 17249105N1407DFlight Training Aircraft LLC · Wilmington, DEBuilt 2008 · S/N 172S10666N1407UN R I Flying Club · Walnut Creek, CABuilt 1976 · S/N 17267077N1408BIasco Flight Training Inc · Redding, CABuilt 2006 · S/N 172S10429N1408YShawver Aviation LLC · Knoxville, IABuilt 1961 · S/N 17249108N140CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13254N140FPNorthwoods Air LLC · Orono, MEBuilt 1986 · S/N 17276539N140PCNavigation Leasing LLC · Castle Rock, COBuilt 1976 · S/N 17268241N140RADenome Vincent G · Tampa, FLBuilt 1999 · S/N 172S8312N140SUOhio State University · Columbus, OHBuilt 2015 · S/N 172S11563N140UDAb Prop Plane II LLC · Metairie, LABuilt 2014 · S/N 172S11489N140WTFly Whiskey Tango LLC · Scottsdale, AZBuilt 1984 · S/N 17276201N1410EGulf Atlantic Airways Inc · Gainesville, FLBuilt 2008 · S/N 172S10667N1410YMolohan Ronald M · Elk Grove, CABuilt 1961 · S/N 17249110N1411FKrause Alex D II · Clintonville, WIBuilt 1966 · S/N 17254906N1411UOxley Kevin L · Huntington, INBuilt 1976 · S/N 17267080N1413FWitmer Brendle D · Woodbury, PABuilt 1966 · S/N 17254908N1413YSooter Craig A · Sedgwick, KSBuilt 1961 · S/N 17249113
Back to AD 90-06-03 R1