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.

N5633RBirds Eye View LLC · Nampa, IDBuilt 1965 · S/N 17253253N5635ADecoteau Mitchel E · Yellville, ARBuilt 1956 · S/N 28235N5635ECircle W Flying Club Inc · Creighton, PABuilt 1978 · S/N 17271908N5636AFine Aviation LLC · Jefferson, ORBuilt 1956 · S/N 28236N5636RSkyhawk Aviation LLC · Ogden, UTBuilt 1965 · S/N 17253258N5636TRegistered aircraftBuilt 1964 · S/N 17251536N5637ASherman Frederick J · Tukwila, WABuilt 1956 · S/N 28237N5637TBarbour George E Jr · Croydon, NHBuilt 1964 · S/N 17251537N5638AHartigan Robert P · Rome, NYBuilt 1956 · S/N 28238N5638RBurkhart Andrew · Toccoa, GABuilt 1965 · S/N 17253261N5639RKeith L S · Forestburg, TXBuilt 1965 · S/N 17253262N563EREmbry-Riddle Aeronautical Univerity Inc · Prescott, AZBuilt 2023 · S/N 172S13088N563FAWang Yuemin · Wauconda, ILBuilt 2003 · S/N 172S9563N563NDAerosim Academy Inc · Sanford, FLBuilt 2008 · S/N 172S10788N563RSRaven Bryan F · Lakeland, FLS/N 17255866N563SPSloan Joseph · Lancaster, CAS/N 172S8416N5640ASanders David L · Powell, WYBuilt 1956 · S/N 28240N5640EHunt Jacky R · Bowling Green, KYBuilt 1978 · S/N 17271909N5640RUnruh Jerel W · Versailles, MOBuilt 1965 · S/N 17253264N5641REaton Samuel D · Clinton, PABuilt 1965 · S/N 17253265N5641TMarcy Dara Owen · Tacoma, WABuilt 1964 · S/N 17251541N5642AMoore Alton O III · Lago Vista, TXS/N 28242N5642RMatheny Roger P · Humble, TXBuilt 1965 · S/N 17253266N5643ARosansky Jeff S · Weldon Spring, MOBuilt 1956 · S/N 28243N5644RShaffer Mark J · Porterfield, WIBuilt 1965 · S/N 17253269N5644TScootair LLC · Alburgh, VTBuilt 1964 · S/N 17251544N5645AAll Seasons Catering Inc · Shelter Isl, NYBuilt 1956 · S/N 28245N5645RGecha Brian S · Brandon, VTBuilt 1965 · S/N 17253270N5645TJ & J Aviation Inc · Martinsville, VABuilt 1964 · S/N 17251545N5646AHeffron Jacob L · Little Falls, MNS/N 28246N5646RAumack Bryant D · Melbourne, FLBuilt 1965 · S/N 17253272N5647TJohnson Jeffri K · Brighton, COBuilt 1964 · S/N 17251547N5648AMartin Rand E · Lake Stevens, WAS/N 28248N5648RKurtz Richard G · Ithaca, NYS/N 17253275N5648TYankton Area Aviators Inc · Crofton, NEBuilt 1964 · S/N 17251548N5649AMinor Charles G · Medford, ORS/N 28249N5649GMaran Properties LLC · Lowell, ARBuilt 1979 · S/N 17273564N564ATMustang Sally Aviation LLC · Camden, SCBuilt 2005 · S/N 172S10020N564EDTilse William A · Kirkland, WABuilt 1956 · S/N 28362N564MCB Air Lc · Sikeston, MOBuilt 2000 · S/N 172S8512N564MML A M Capital Management LLC · Sheridan, WYBuilt 1982 · S/N 17275714N5650TWander Harry J · Nevada City, CABuilt 1964 · S/N 17251550N5651RChickasha Wings Inc · Chickasha, OKBuilt 1965 · S/N 17253279N5651TRegistered aircraftS/N 17251551N5652APatriot Aviation · Loomis, CABuilt 1956 · S/N 28252N5652ECgumps LLC · Antioch, TNBuilt 1978 · S/N 17271912N5654RSudbrink Charles D · Willet, NYS/N 17253283N5654THayes Travis · Harrisonville, MOS/N 17251554N5656EN2893e LLC · Reno, NVBuilt 1978 · S/N 17271913N5657RFord Darryl · Caldwell, IDBuilt 1965 · S/N 17253287
Back to AD 90-06-03 R1