OpenAirDocs.org
AD 90-06-03 R1

Registered aircraft · 20,687

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.

N901TGWestland Aviation LLC · Lake Havasu City, AZBuilt 1968 · S/N 17257312N9027CElizabeth City State University · Elizabeth City, NCBuilt 2010 · S/N 172S11069N9027HAdriatic Holdings LLC · Cheyenne, WYS/N 17265908N9029DKemp Ted · Pleasant Shade, TNS/N 17254099N9029WKnutson Wayne R · Thompson, NDS/N 17248036N902AZSantiago Felipe · Miami, FLBuilt 1981 · S/N 17275091N902EREmbry-Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12964N902FAVero Technical Support Inc · Pensacola, FLBuilt 1980 · S/N 17273785N902HMacvey Troy R · Milan, INBuilt 1971 · S/N 17259252N902NSRegistration Pending · Pottstown, PARegistration pendingBuilt 1981 · S/N 17275415N9038HPeterson Todd B · Cameron Park, CABuilt 1975 · S/N 17265912N903AZN903az LLC · Miami, FLBuilt 1984 · S/N 17276198N903CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8327N903NSAmerican Patrols Inc · Midland, TXBuilt 1976 · S/N 17267441N90404Liberty University · Lynchburg, VABuilt 2010 · S/N 172S11064N9042HSt Pete Aviation Services LLC · St Petersburg, FLS/N 17265914N9042QTumbleweed Leasing Co Inc · Salt Lake City, UTBuilt 1976 · S/N 172-67996N9043HPinter Seth K · Abbotsford, WIBuilt 1975 · S/N 17265915N9045BEhg Flight LLC · Venice, CABuilt 2010 · S/N 172S11057N9048HGravesen Mark A · Kenmare, NDBuilt 1975 · S/N 17265917N904CPAbove And Beyond Aviation LLC · Austin, TXBuilt 1999 · S/N 172S8328N904DRSo Cal Leasing LLC · El Cajon, CABuilt 2004 · S/N 172S9698N904PWJax Beach Aviation LLC · Jacksonville, FLBuilt 1968 · S/N 17257275N904RAJw Aero Holdings Inc · Canandaigua, NYBuilt 1976 · S/N 17267060N904SWAmerican Gp Inc · Nashville, TNBuilt 1963 · S/N 17250163N90508Liberty University · Lynchburg, VABuilt 2011 · S/N 172S11073N90558Hagele Aviation LLC · Hillsboro, ORS/N 17274773N9056KOn Time Aviation Corp · Roseland, NJBuilt 2017 · S/N 172S12064N9057HAmoroso Ricardo C · Powder Springs, GABuilt 1975 · S/N 17265921N905AZN905az LLC · Miami, FLBuilt 1986 · S/N 17276651N905CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8329N905EREmbry Riddle Aeronautical University Inc · Daytona Beach, FLBuilt 2023 · S/N 172S12967N905KSZoppe Eduardo · Lakewood Ranch, FLBuilt 1985 · S/N 17276516N905WAMy Way Aviation LLC · Weston, FLBuilt 1977 · S/N 17269967N9060HJ&S Flying Enterprises LLC · Zanesville, OHBuilt 1975 · S/N 17265922N9068HGundlach Mark A · Fruitland, WABuilt 1975 · S/N 17265928N906CPCivil Air Patrol · Maxwell Afb, ALBuilt 2001 · S/N 172S8910N906JRAmeriflyers Of Texas Inc · Addison, TXBuilt 2006 · S/N 172S10231N906KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1979 · S/N 17272697N906MDFive Rivers Flight Training LLC · Livermore, CABuilt 1976 · S/N 17268038N906WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17268112N90763Apex Aircraft Leasing LLC · Anchorage, AKBuilt 1983 · S/N 17275856N907AZN907az LLC · Miami, FLBuilt 1980 · S/N 17274436N907CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1999 · S/N 172S8330N907EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2022 · S/N 172S12916N907JWPalm Beach Flight Training Corp · Lantana, FLBuilt 2006 · S/N 172S10328N907KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268575N907LPMicro Publishing Press Inc · Truckee, CABuilt 1999 · S/N 172S8221N907SEAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 172S13479N907TTHangar Ak LLC · Sterling, AKBuilt 1974 · S/N 17262358
Back to AD 90-06-03 R1