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.

N63256Bridge To Freedom Investments LLC · Atlanta, GAS/N 15077207N63258Cleven Randall L · Moncure, NCBuilt 1975 · S/N 15077209N63259Lloyd Kevin S · Tacoma, WABuilt 1975 · S/N 15077210N6325SConfer Mark A · Fort Wayne, INBuilt 1967 · S/N 15067125N63260Van Hise Austin S · Fort Denaud, FLBuilt 1975 · S/N 15077211N63263Debonair Solutions LLC · Leesville, LAS/N 15077214N63265Cessna Flyers LLC · Zephyrhills, FLS/N 15077216N6326GStephani Timothy M · White Lake, WIBuilt 1970 · S/N 15071826N63270Louise Flyers LLC · Cheyenne, WYBuilt 1975 · S/N 15077219N63272Glantz Charles P · Albuquerque, NMS/N 15077221N6327SHayton James B · Sedro Woolley, WAFirst renewal noticeBuilt 1967 · S/N 15067127N63283Johnston Daniel · Virginia Beach, VABuilt 1975 · S/N 15077227N63285Honan John A · Lincroft, NJBuilt 1975 · S/N 15077228N63287Waters Brandon J · Bushnell, ILBuilt 1975 · S/N 15077230N6328GGoodger Jerome H · Milton, WIBuilt 1970 · S/N 15071828N63290N63290 LLC · Boulder City, NVBuilt 1975 · S/N 15077232N63293Roesner Alvin R · Indianapolis, INBuilt 1975 · S/N 15077233N6329GRegistration Pending · Brodheadsville, PARegistration pendingS/N 15071829N632EHHuddleston Edward L · Oaktown, INBuilt 1973 · S/N A1500467N6330SErnst Albert S III · Buda, TXBuilt 1967 · S/N 15067130N6331GSound Flight LLC · Auburn, WAS/N 15071831N6332GJr Imaging Logistics Inc · Pasco, WABuilt 1970 · S/N 15071832N63332Andavia LLC · Fort Worth, TXBuilt 1975 · S/N 15077241N63338Scarbrough Mark B · San Miguel, CAS/N 15077247N6333GEule James M · Eagle River, AKS/N 15071833N6333SVano Andrew · Carlos, MNBuilt 1967 · S/N 15067133N63341Puget Sound Flyers Inc · Everett, WAS/N 15077250N63342Vmax Aviation LLC · Uhrichsville, OHBuilt 1975 · S/N 15077251N63346White Thomas L · Willow Springs, MOBuilt 1975 · S/N 15077253N6334MSundance Flying Club Inc · Palo Alto, CABuilt 1980 · S/N 15284678N63359Flick Adam C · Findlay, OHBuilt 1975 · S/N 15077261N6335GHaslam Russell L · Meeker, OKS/N 15071835N63362Bels Holdings LLC · Albert Lea, MNBuilt 1975 · S/N 15077262N63363Shaner John D · Tallahassee, FLBuilt 1975 · S/N 15077263N6336KFlanders Steve L · Brea, CAS/N 15077650N63375Pocono Mountains Flying Club Inc · Tobyhanna, PAS/N 15077268N63376Devaney Aviation Inc · Palm City, FLBuilt 1975 · S/N 15077269N63384Sa Kim J · Hayward, CABuilt 1975 · S/N 15077274N6338GEron Patrick · Hatley, WIBuilt 1970 · S/N 15071838N6338KBurchinal Sam F · Brookston, TXBuilt 1975 · S/N 15077652N63395Reiman Jeffrey Scott · Chandler, AZBuilt 1975 · S/N 15077282N63399Vogt Gerald J · Erie, PABuilt 1975 · S/N 15077284N6339MFlight World Inc · San Juan, PRBuilt 1980 · S/N 15284680N6339SDamico Thomas J · West Bend, WIBuilt 1967 · S/N 15067139N63401Evans Harold M · Dunnellon, FLBuilt 1975 · S/N 15077286N63406Searfoss Robert L · Atlanta, GABuilt 1975 · S/N 15077290N63407Mcguire Ryan · Redwood City, CABuilt 1975 · S/N 15077291N63412Knh Aviation LLC · Yuma, AZBuilt 1975 · S/N 15077294N63414Simonis Kenneth W · Girdwood, AKBuilt 1975 · S/N 15077296N63418Knutson Wayne R · Tioga, NDBuilt 1975 · S/N 15077299
Back to AD 2009-10-09 R2