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.

N22499Johnson Dale B · Steele, NDBuilt 1968 · S/N 15068319N22501Smith Dylan Lane · Oklahoma City, OKBuilt 1968 · S/N 15068321N2250JLuce Frederick M · Brookshire, TXBuilt 1966 · S/N 15065450N22515Wheeler Bret · La Grande, ORBuilt 1968 · S/N 15068329N22523Beene Donald L · Westfield, INBuilt 1968 · S/N 15068334N22526Staloff Jason A · Greenfield, MABuilt 1968 · S/N 15068337N22528Hhd Aviation LLC · Hamilton, OHBuilt 1968 · S/N 15068339N22529Rhodes Stephen D · Hendersonville, NCS/N 15068340N22533Regner Mark W · Danbury, CTBuilt 1968 · S/N 15068343N22536Reep Jennifer B · Stone Mountain, GABuilt 1968 · S/N 15068345N22537Ernst Albert S III · Buda, TXS/N 15068346N22540Mcgovern Thomas F · Blue Springs, MOBuilt 1968 · S/N 15068347N22542Apgyn And Associates Inc · Coral Springs, FLBuilt 1968 · S/N 15068349N22544N1705r Inc · Cobb, CAS/N 15068351N2254FHudson Daryl J · Redwood Valley, CABuilt 1974 · S/N 15076160N22556Rawareo LLC · Warsaw, MOS/N 15068359N22558Lilik Dennis A · Lewes, DEBuilt 1968 · S/N 15068360N22561Buckley Holli R · Columbia, MSBuilt 1968 · S/N 15068362N22563Davis Michael A Jr · Fairbanks, AKBuilt 1968 · S/N 15068364N22564Darnell Stephen L · Bargersville, INBuilt 1968 · S/N 15068365N22568Pina Gabriel B · Pasadena, CABuilt 1968 · S/N 15068368N22570Nebbia Valter Della · Archer City, TXBuilt 1968 · S/N 15068369N22582Lee Scott M · Noble, OKBuilt 1968 · S/N 15068376N22583Christensen Marc G · Bountiful, UTBuilt 1968 · S/N 15068377N22584Manning Christopher S · Dawson, GABuilt 1968 · S/N 15068378N22585Obregon Aviation LLC · San Francisco, CABuilt 1968 · S/N 15068379N22586Weyker William J · Rhinelander, WIBuilt 1968 · S/N 15068380N22589Robles Lazaro R · Golden Valley, MNBuilt 1968 · S/N 15068383N22590Sorensen Dale · Wellsville, UTS/N 15068384N22594Morton Eric C · Anchorage, AKBuilt 1968 · S/N 15068388N22595Johnson Leif M · Midlothian, TXFirst renewal noticeBuilt 1968 · S/N 15068389N22596Anderson Bradley P · Rapid City, SDBuilt 1968 · S/N 15068390N22597Mcmanus Charles D · Cottageville, SCBuilt 1968 · S/N 15068391N2259MHillabrand James E · Rogers, ARBuilt 1975 · S/N 15077090N225KCJr Imaging Logistics Inc · Pasco, WABuilt 1969 · S/N 15070197N22602Williamson Mark T · Crescent City, CAS/N 15068396N22609Kysar Ian R · Battle Ground, WAS/N 15068401N2260JSeda Oswaldo · Stockbridge, GABuilt 1966 · S/N 15065460N22612Wild Hair Aviation LLC · Centerville, WABuilt 1968 · S/N 15068402N22615Word Charles A · Pensacola, FLBuilt 1968 · S/N 15068405N22628Lemko Dennis A · Fresno, CABuilt 1968 · S/N 15068412N22638Lindorfer John H · Long Beach, MSBuilt 1976 · S/N 15078567N2263JJr Imaging Logistics Inc · Pasco, WABuilt 1966 · S/N 15065463N22645Martinez Emilio · Fairburn, GABuilt 1968 · S/N 15068424N22648Eagles Wings Flight Training · Clintonville, WVBuilt 1968 · S/N 15068425N2264JRegistered aircraftAssigned, pending cancellationS/N 15065464N22656Berry Frank C · Watkinsville, GAS/N 15068431N22662Rogers Gary A · Novi, MIBuilt 1968 · S/N 15068433N22663Auger Allan Dean · Conifer, COBuilt 1968 · S/N 15068434N22667Firkus Lloyd Jason · Plover, WIBuilt 1968 · S/N 15068437
Back to AD 2009-10-09 R2