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.

N5244VKnucklehead Aviation LLC · Cedar City, UTBuilt 1980 · S/N 172RG0481N5245KPerun Av LLC · Cliffside Park, NJBuilt 1980 · S/N 17274029N5245VMarianas Air Transfer Inc · Saipan, MPBuilt 1980 · S/N 172RG0482N5246UMize Helicipter LLC · Edmond, OKS/N 172RG0298N52473American Patrols Inc · Midland, TXBuilt 1980 · S/N 17274535N5247RHarbour Aviation LLC · Weatherford, TXBuilt 1974 · S/N 17263461N52483Walsh Air Enterprises · Sugar Land, TXBuilt 1980 · S/N 17274537N5248UStephens Robert Z · Missoula, MTBuilt 1980 · S/N 172RG0300N5249DQuicksilver Skycraft LLC · Langley, WAS/N 17272470N5249EAlexandria Aviation Inc · Alexandria, MNBuilt 1978 · S/N 17271797N5249F3 Mad Wives Aviation LLC · Claremont, MNBuilt 1965 · S/N 17253346N5249JWhitgo LLC · Lucas, TXBuilt 1980 · S/N 17273744N5249RHigh Exposure Inc · Wilmington, DEFirst renewal noticeBuilt 1974 · S/N 17263463N524BDClark Mark · Captiva, FLBuilt 1979 · S/N 17272180N524MESmith Lester C Jr · Colleyville, TXS/N 17258149N524NDPhoenix East Aviation LLC · Daytona Beach, FLBuilt 2009 · S/N 172S10979N52501Freedom Works Consulting LLC · Louisville, KYS/N 17274541N52516Christiansen Aviation LLC · Wilmington, DEBuilt 1981 · S/N 17274546N52519Northwestern Michigan College · Traverse City, MIBuilt 2009 · S/N 172S10903N5251ERhinelander Flying Service Inc · Rhinelander, WIBuilt 1977 · S/N 17271799N5251HLuyster Roy A · Rochelle Park, NJBuilt 1975 · S/N 17265384N5251RLong Island Aviators LLC · Seaford, NYS/N 17263465N5251ZMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10902N52521Rebel Aviation Inc · Liberty, MOFirst renewal noticeBuilt 1980 · S/N 17274547N52522Mustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10905N5252JNorthwestern Michigan College · Traverse City, MIBuilt 2009 · S/N 172S10904N52531Csa Aircraft Leasing LLC · Salt Lake City, UTBuilt 2002 · S/N 172S9172N52535Voroshuck Clayton T · Sunnyvale, CABuilt 2002 · S/N 172S9173N5253CMustang Sally Aviation LLC · Camden, SCBuilt 2009 · S/N 172S10906N5253RAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263467N5253UKronauge Frank A · Dayton, OHS/N 172RG0302N5253XMaranatha Insurance Service Inc · Rancho Cucamonga, CABuilt 2002 · S/N 172S9169N52546Eaton Rosemary D · Vernon, NYS/N 17274552N5254DR&R Aero Services LLC · Eden Prairie, MNBuilt 1979 · S/N 17272473N5254JWorcester Naa Flying Club · Worcester, MABuilt 1980 · S/N 17273745N5254KStone To Glass LLC · Lake Worth, FLBuilt 1980 · S/N 17274033N5254QRocky Mountain Flight Consultants LLC · Boulder, COBuilt 2002 · S/N 172S9206N5254WGlacier Peak Aviation LLC · Carnation, WABuilt 2002 · S/N 172S9207N5255RZin Services LLC · Dover, DEBuilt 2009 · S/N 172S10987N5255UFlight Gear Aviation LLC · Pickerington, OHBuilt 1980 · S/N 172RG0304N52569Kf Air Holdings LLC · Indianapolis, INS/N 17274557N5256DTall Timber Flying Service LLC · Kalispell, MTBuilt 1979 · S/N 17272475N5256HHenley Robert J · Jeffersonville, INS/N 17265385N5256SFargo Jet Center LLC · Fargo, NDBuilt 2009 · S/N 172S10901N5257HWellman David H · Eugene, ORBuilt 1975 · S/N 17265386N5257RTheodossiou Chris · Mandeville, LABuilt 1974 · S/N 17263471N5258RZwiesler Thomas F · Ellington, CTBuilt 1974 · S/N 17263472N5258YChristiansen Aviation LLC · Wilmington, DEBuilt 2002 · S/N 172S9141N5258ZSt Pete Aviation Services LLC · Saint Petersburg, FLBuilt 1981 · S/N 17275032N52593Mccarthy Justin P · Western Springs, ILBuilt 1980 · S/N 17274559
Back to AD 90-06-03 R1