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.

N8226FPrahin Michael H · Novi, MIBuilt 1966 · S/N 15064326N8227SKashani Asher Farzan · Reseda, CABuilt 1965 · S/N 15061827N8228SMorristown Flying Service Inc · Talbott, TNS/N 15061828N8229SShanaman Baratt S · Ann Arbor, MIBuilt 1965 · S/N 15061829N8231FNeuman Paul · Campbellsburg, KYBuilt 1966 · S/N 15064331N8232FSouthern Arkansas University Tech · Camden, ARBuilt 1966 · S/N 15064332N8237SArth Richard E · Newcomerstown, OHBuilt 1965 · S/N 15061837N8239FTeeters Larry N · Shreveport, LABuilt 1966 · S/N 15064339N823FStout Philip L · Ephrata, WAS/N 15064514N823WSMcinturf Paul A Jr · Childress, TXBuilt 1967 · S/N 15066175N8240F14a Flying Club Inc · Mooresville, NCBuilt 1966 · S/N 15064340N8245FMorisette Michael W · Antelope, CABuilt 1966 · S/N 15064345N8246FTalikka Todd · Paulding, OHBuilt 1966 · S/N 15064346N8247FCarson Leonard H · Chesapeake, VAS/N 15064347N8248FLucia Steven R Sr · Agawam, MAS/N 15064348N8250FRyan Good Aviation LLC · Sioux Falls, SDS/N 15064350N8250SRegistration Pending · Statesville, NCRegistration pendingBuilt 1965 · S/N 15061850N8253FSinclair Jerry D · Watonga, OKBuilt 1966 · S/N 15064353N8255FStarks Aviation Inc · Pittsburgh, PAS/N 15064355N8255SConz Gerald Patrick Jr · Wyandotte, MIS/N 15061855N8257SCrews Bryce D · Rensselaer, INBuilt 1965 · S/N 15061857N8259FCoker Nathan F Jr · Lynchburg, VABuilt 1966 · S/N 15064359N8266FOnemanconcrete LLC · Thaxton, VABuilt 1966 · S/N 15064366N8266SRankin Gregory E · Wetumpka, ALBuilt 1965 · S/N 15061866N8267FPokorny John · Woodstock Valley, CTBuilt 1966 · S/N 15064367N8268FBudd Jim · Rushville, NEBuilt 1966 · S/N 15064368N826XHHoleman Darren C · New Town, NDS/N 150-74756N8270SN83993 LLC · Cherry Hill, NJExpired dealer, pending cancellationBuilt 1965 · S/N 15061870N8271SKontz Gary Lee · Canby, MNBuilt 1965 · S/N 15061871N8272SVierheller Glenn Eric · Seville, OHBuilt 1965 · S/N 15061872N8273FAir Charterz LLC · Columbus, OHS/N 15064373N8274FMcclain Daniel S · Enon Valley, PAS/N 15064374N8275FStanford Michael · Victoria, TXBuilt 1966 · S/N 15064375N8276UNurge Richard J · Gilroy, CAS/N 15077910N8278FIvey Joseph M · Poland, OHS/N 15064378N827DFBrown Edward M · Cabot, ARBuilt 1970 · S/N 15071994N8285FBearss Gordon M · Lawrence, KSBuilt 1966 · S/N 15064385N8288SWatters Reid W · Tilleda, WIBuilt 1965 · S/N 15061888N8289FDe Cristo Andre G · Flushing, NYBuilt 1966 · S/N 15064389N8290SNewsome Jeff · Blackwell, OKBuilt 1965 · S/N 15061890N8291SSipes Jacob L · Sunbury, OHBuilt 1965 · S/N 15061891N8294FWalters Craig S · Lake City, FLS/N 15064394N8294SLogtime Flight LLC · Lancaster, TXBuilt 1965 · S/N 15061894N8297SBergmann Joshua A · Menomonie, WIBuilt 1965 · S/N 15061897N8298FAustin Leslie M · Greenville, INBuilt 1966 · S/N 15064398N8298UCollins Roberto · Naples, FLBuilt 1976 · S/N 15077915N8299SMcauliffe John P · Livonia, MIBuilt 1965 · S/N 15061899N82EDRodriguez Rolando · Harlingen, TXBuilt 1973 · S/N 15075663N8302GLittle Air Dream LLC · Mooresville, NCBuilt 1965 · S/N 15062402N8303JFodero Jesse G · West Seneca, NYBuilt 1967 · S/N 15066203
Back to AD 2009-10-09 R2