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.

N6676GChen Hong · Independence, ORBuilt 1970 · S/N 15072176N66774Kilo Lima LLC · Hicksville, NYBuilt 1974 · S/N 15076268N66776Broherd James · Natalia, TXBuilt 1974 · S/N 15076269N66777Lennon Bobby M · Whiteville, NCS/N 15076270N66779Blinn Philipp Randy · Priest River, IDS/N 15076272N66780Keenan Jim F · Neenah, WIBuilt 1974 · S/N 15076273N66781Strong Mack A · Coral Springs, FLS/N 15076274N66785Destefano Patrick S · Bryan, TXBuilt 1974 · S/N 15076278N66786Gibb Bryce M · Portland, TXBuilt 1974 · S/N 15076279N66790Logan Dan P · Gilliam, LABuilt 1974 · S/N 15076283N6679SCampos Katherine · Tallahassee, FLBuilt 1967 · S/N 15067479N6681GMoore Joseph L · Hesperus, COS/N 15072181N6683GPardee Gary D · Buckley, WABuilt 1970 · S/N 15072183N6683SWingsofdawn LLC · East Greenwich, RIBuilt 1967 · S/N 15067483N6684GReeder Brenton Lamar · Beacon, NYBuilt 1970 · S/N 15072184N6687FBlakesley Eric R · Canandaigua, NYS/N 15063287N6687SSale Reported · Houston, AKSale reportedBuilt 1967 · S/N 15067487N6689FMills Nicolas A · Greenwood, NYBuilt 1966 · S/N 15063289N6689SSimpson Dwight D · Phillips, WIBuilt 1967 · S/N 15067489N6690SSeniram Air Inc · Wilmington, DEBuilt 1967 · S/N 15067490N6692GHopkins Marissa A · Cameron, MTBuilt 1970 · S/N 15072192N6692SNoltensmeyer Kurt Jon · Greenbank, WABuilt 1967 · S/N 15067492N66931Laguna Verde Leasing Inc · Wilmington, DES/N 15281668N66941Blue Mountain Airways LLC · Woodstock, GABuilt 1978 · S/N 15281676N66946Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281681N66948Kuriger Michael R · Santa Clarita, CABuilt 1978 · S/N 15281683N6694FWanagel Walter · Lisbon, CTBuilt 1966 · S/N 15063294N6694GChatas John W · Ann Arbor, MIS/N 15072194N66954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281689N6695SOlsen Raymond E · Washington, UTBuilt 1967 · S/N 15067495N6696FYoung Deborah C · Lopez Island, WABuilt 1966 · S/N 15063296N6696SJohnson Jay E · Murray, IABuilt 1967 · S/N 15067496N66970California Airways LLC · Hayward, CABuilt 1978 · S/N 15281696N66971Meridian Airport Authority · Meridian, MSBuilt 1978 · S/N 15281697N66977Unique Educational Experiences · Signal Hill, CABuilt 1978 · S/N 15281699N6697FLogan Thomas H · Canfield, OHS/N 15063297N6697GPaul William A · Windfall, INS/N 15072197N6699GBailey Matthew T · Cornelius, ORBuilt 1970 · S/N 15072199N669JKGeddes Michael · Seattle, WAS/N 15068277N669NEAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1981 · S/N 15285368N66JMRussman Nicholas S · Farmersville, TXBuilt 1981 · S/N 15285251N66LLLetourneau Duane R · Oconto, WIBuilt 1974 · S/N 15076289N6700SAgape Enterprises · Montana City, MTBuilt 1967 · S/N 15067500N6701FHale James W · Darrington, WAS/N 15063301N6701SKnipping Richard W Jr · Winterport, MEFirst renewal noticeBuilt 1967 · S/N 15067501N6702FVirnig Joshua B · Deerwood, MNBuilt 1966 · S/N 15063302N6703FBargabos Julie A · Canastota, NYBuilt 1966 · S/N 15063303N6704FAvistar Media Corporation · Wilmington, DES/N 15063304N6704GRyan Conner J · Fruita, COS/N 15072204N6705SMiszczak Ethan · Newnan, GABuilt 1967 · S/N 15067505
Back to AD 2009-10-09 R2