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.

N2824SGolf Aero Corp · Wilmington, DENon-citizen corporation, flight hours not reportedBuilt 1967 · S/N 15066724N2825SShore Luke S · Elkin, NCBuilt 1967 · S/N 15066725N2832SMeyer Philipp J · Sioux Falls, SDBuilt 1967 · S/N 15066732N2834SMcmahon Connor J · Brookfield, CTBuilt 1967 · S/N 15066734N2835SDuyck Candace A · Cornelius, ORS/N 15066735N2837SBuric Ivan · Panama City, FLBuilt 1967 · S/N 15066737N2837VLewis Samuel Joseph · Decatur, TXBuilt 1974 · S/N 15076296N2838SLewallen Roy W · Beaverton, ORBuilt 1967 · S/N 15066738N2839SVon Trapp Ryan G · Charlotte, NCBuilt 1967 · S/N 15066739N2842SRegistration Pending · Mountain Home, ARRegistration pendingBuilt 1967 · S/N 15066742N2843SRegistration Pending · Tequesta, FLRegistration pendingS/N 15066743N2844SJacks Grady M · Mena, ARS/N 15066744N2844VN2844 LLC · Riverton, UTBuilt 1974 · S/N 15076298N2847VClinton Flying Service Inc · Clinton, NCBuilt 1974 · S/N 15076299N2856SPerera Nandana L · Logan, OHBuilt 1967 · S/N 15066756N2857SCrum Brian B · Warrensburg, MOS/N 15066757N2857VCiabattoni David E · Wallingford, PABuilt 1974 · S/N 15076302N2859SHout David D · Columbus, OHBuilt 1967 · S/N 15066759N2861SEagley Ronald A · Anchorage, AKBuilt 1967 · S/N 15066761N2862SGrotbeck Carter L · Albuquerque, NMBuilt 1967 · S/N 15066762N2864STop Aircraft Leasing LLC · Wilmington, DEBuilt 1967 · S/N 15066764N2866VLyles Ed · Newnan, GABuilt 1974 · S/N 15076304N2867SJarrell Loyd F · Whitesburg, TNBuilt 1967 · S/N 15066767N2872VRamirez Jose · Altadena, CABuilt 1974 · S/N 15076306N2875SHolland Van D · Sandy Valley, NVBuilt 1967 · S/N 15066775N2876SRay Charlie B · Prosser, WAS/N 15066776N2877SWarner David F · Altoona, IABuilt 1967 · S/N 15066777N2880SHigh Exposure Inc · Wilmington, DEBuilt 1967 · S/N 15066780N2881SSerbus Gary E · Olivia, MNBuilt 1967 · S/N 15066781N28822Edwards Gordon O · Casper, WYBuilt 1966 · S/N 15063015N2885SWinter Thomas N · Lincoln, NEBuilt 1967 · S/N 15066785N2887SRobinson Andrew K · Pahrump, NVBuilt 1967 · S/N 15066787N2889SKinter Christopher A · Kodiak, AKS/N 15066789N2890SKeyte Clinton W · Colfax, CABuilt 1967 · S/N 15066790N2890VTampa Bay Soaring Society Inc · Zephyrhills, FLS/N 15076313N2891VSchaller Lee · New Athens, ILFirst renewal noticeBuilt 1974 · S/N 15076314N2894VCuthbertson Steven M · Van Alstyne, TXBuilt 1974 · S/N 15076316N2895SMaur Karandeep · Meadville, PABuilt 1967 · S/N 15066795N2905SCole Ezra L · Gentry, ARBuilt 1967 · S/N 15066805N2908JBranton Hewett · Nashville, TNS/N 15065708N2908SSloan Paul · Escondido, CABuilt 1967 · S/N 15066808N2909SFatla Gregory F · Hixton, WIBuilt 1967 · S/N 15066809N2910JWeldy Mark L · Etna Green, INBuilt 1966 · S/N 15065710N2912SWard Ascher · Oxnard, CAS/N 15066812N2913JMulti Engine Training Co Inc · Tuttle, OKS/N 15065713N2913SMartin Richard E · Palmyra, WIBuilt 1967 · S/N 15066813N2914JMaverick Aviation Holdings LLC · Sheridan, WYS/N 15065714N2915SKoch Kenneth Scott · Coolidge, AZS/N 15066815N2917JKnoll David Alexander · Godwin, NCBuilt 1966 · S/N 15065717N2917SItz LLC · Lusby, MDBuilt 1967 · S/N 15066817
Back to AD 2009-10-09 R2