OpenAirDocs.org
AD 2009-10-09 R2

Registered aircraft · 8,565

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:2009-10-09-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2009-10-09-R2')
  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.

N714TJTop 5 Media LLC · Santa Maria, CABuilt 1977 · S/N 15279417N714TRStocks Kristian · Billings, MTBuilt 1977 · S/N 15279424N714TUDamschroder Rex A · Fremont, OHBuilt 1977 · S/N 15279427N714UCStroud James DBA · Union, SCBuilt 1977 · S/N 15279435N714UDThunderfighter LLC · Englewood, COBuilt 1977 · S/N 15279436N714UFBoraam Aviation Inc · Prospect Heights, ILBuilt 1977 · S/N 15279438N714VBCrosswinds Flight Center Inc · Drums, PAS/N 15279457N714VGJust Tailwheels LLC · Sarasota, FLBuilt 1977 · S/N 15279462N714VHJet & Rotor Aviation LLC · Sacramento, CAS/N 15279463N714VLOdonata LLC · Lewiston, IDBuilt 1977 · S/N 15279466N714VNFolstad Bennett O · Sidney, MTBuilt 1977 · S/N 15279468N714VYTappan East LLC · New Philadelphia, OHBuilt 1977 · S/N 15279478N714VZSojka Brian Z · Herndon, VABuilt 1977 · S/N 15279479N714WDDaviation Inc · Willoughby, OHBuilt 1977 · S/N 15279482N714WECirrus Inc · Wilmington, DEFirst renewal noticeBuilt 1977 · S/N 15279483N714WGWhitt Sana F · East Quogue, NYS/N 15279485N714WPWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279492N714WSR & D Aircraft Inc · Jamestown, NCBuilt 1977 · S/N 15279495N714WTJones Freda C · San Antonio, TXBuilt 1977 · S/N 15279496N714WWVess Gerald · Livingston, TXS/N 15279499N714XBWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279504N714XJSummit Aviation Holdings Of Nwa Inc · Rogers, ARBuilt 1977 · S/N 15279511N714XXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279524N714YKThurman Glen · Mineola, TXBuilt 1977 · S/N 15279536N714YWHiflite LLC · Athens, ALBuilt 1977 · S/N 15279547N714YXLone Star Aero Inc · Fort Worth, TXBuilt 1977 · S/N 15279548N714ZBRegistered aircraftBuilt 1977 · S/N 15279552N714ZCMauser William T · Rio Linda, CABuilt 1977 · S/N 15279553N714ZGNotam Aviation LLC · Portage Des Sioux, MOBuilt 1977 · S/N 15279557N714ZPDippold Lois M · Perry, MIBuilt 1977 · S/N 15279564N714ZUJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279569N714ZXWagner Michael · Winter, WIBuilt 1977 · S/N 15279572N714ZYCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 15282152N7150FTulsa Technology Center School District No 18 · Tulsa, OKBuilt 1966 · S/N 15063750N7153GEricson Eric · St Charles, ILBuilt 1973 · S/N 15074618N7154FFenton Richard Trustee · Mckinleyville, CABuilt 1966 · S/N 15063754N7154SAlexander Aviation LLC · Ellisville, MSBuilt 1967 · S/N 15067854N7155FJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15063755N7159FBrooks James · West Liberty, OHBuilt 1966 · S/N 15063759N7159SSaathoff Michael A · Stockton, MOS/N 15067859N715SHPotoczek Jeffrey · Century, FLS/N 15070696N715TLucy Roy · Ada, OKFirst renewal noticeBuilt 1977 · S/N 15279611N7160FFoxy Bankins LLC · Hobe Sound, FLBuilt 1966 · S/N 15063760N7161FRegistration Pending · Orange, CARegistration pendingBuilt 1966 · S/N 15063761N7162SHensley Aviation LLC · Telford, TNBuilt 1967 · S/N 15067862N7163FTomac Steven B · Yerington, NVBuilt 1966 · S/N 15063763N7164FShear View Mulching LLC · Poplarville, MSBuilt 1966 · S/N 15063764N7164SGardner Terrence L · Pittsboro, NCFirst renewal noticeBuilt 1967 · S/N 15067864N7165FOlson Eric C · Portland, ORBuilt 1966 · S/N 15063765N7165SCaskey Martin K · Paso Robles, CABuilt 1967 · S/N 15067865
Back to AD 2009-10-09 R2