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.

N67601Aero Maintenance Inc · Vancouver, WABuilt 1978 · S/N 15281939N6760FClancy Mackenzie W · Grand Rapids, MIS/N 15063360N6760GPurkinje Ltd LLC · Wilmington, DEBuilt 1970 · S/N 15072260N6760SPantera Services LLC · New York, NYBuilt 1967 · S/N 15067560N67611Kumor Ronald G · Casper, WYBuilt 1978 · S/N 15281945N67614Wampus Cats Inc · Davenport, IABuilt 1978 · S/N 15281948N67618Hale Douglas W · Perryton, TXBuilt 1978 · S/N 15281950N6762SRegistration Pending · Snowflake, AZRegistration pendingBuilt 1967 · S/N 15067562N67638Blue Feathers Corp · Newark, DEBuilt 1978 · S/N 15281954N6763FLogsdon Dale L Trustee · Alva, OKS/N 15063363N6763GVarner David L · Eastpoint, FLS/N 15072263N67648Flying Vikings Inc · Hayward, CABuilt 1978 · S/N 15281960N6764FBruno Alfred T · Santa Rosa, CABuilt 1966 · S/N 15063364N67651Salomonsson Mats · Fremont, CABuilt 1978 · S/N 15281963N67652Final Design Group LLC · Hurricane, UTBuilt 1978 · S/N 15281964N67657Jade Air LLC · San Pedro, CABuilt 1978 · S/N 15281965N6765SMaxson Gerald · Hawthorne, FLBuilt 1967 · S/N 15067565N6766FAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 1966 · S/N 15063366N6767GAspen Kelsen LLC · Rutledge, MOBuilt 1970 · S/N 15072267N6769FGarvey Aviation Services · Erie, PABuilt 1966 · S/N 15063369N67701R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281969N67705Registration Pending · Tacoma, WARegistration pendingBuilt 1978 · S/N 15281971N67708Pischel Tom K · Meadow Vista, CABuilt 1978 · S/N 15281974N6770FFaith Tabernacle Ministries Inc · Junction City, KSBuilt 1966 · S/N 15063370N67710Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281975N67711Cox Linda M · Christiana, TNFirst renewal noticeBuilt 1978 · S/N 15281976N67728Edj Aviation Ltd · Fort Myers Beach, FLBuilt 1978 · S/N 15281983N6772FIrlbeck Cyler M · Eden Prairie, MNBuilt 1966 · S/N 15063372N67733Righter Douglas D · Bellingham, WABuilt 1978 · S/N 15281986N67746Air-Planes LLC · Soddy Daisy, TNBuilt 1978 · S/N 15281992N6774SBennington Aaron G · Delaware, OHBuilt 1967 · S/N 15067574N67753Southwinds Export Inc · Kissimmee, FLS/N 15281998N6775GBannock Anthony O · Anchorage, AKS/N 15072275N67760Farquar Leasing Inc · North Bend, ORBuilt 1978 · S/N 15282002N67765Guilbeau Austin K · Miami, FLS/N 15282005N6776GWalters John S · Durham, CABuilt 1970 · S/N 15072276N67778Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282013N6777SEhrhardt Paul R · Junction City, ORBuilt 1967 · S/N 15067577N67787Williams Aviation LLC · Maumelle, ARBuilt 1978 · S/N 15282018N67792City Of Newport News · Newport News, VABuilt 1981 · S/N 15285309N67796Dsr Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15282025N67797Indiana State University · Terre Haute, INBuilt 1978 · S/N 15282026N6779FBeulah Ranch LLC · Cheyenne, WYBuilt 1966 · S/N 15063379N677JFShorey Peter K · Newry, MEBuilt 1969 · S/N 15069677N67807Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15282031N67810Hernandez Jason Joseph · Allen, TXBuilt 1978 · S/N 15282033N67818Tlb Inc · Howell, NJBuilt 1978 · S/N 15282036N67825Kentucky Airmotive Inc · Mt Sterling, KYBuilt 1978 · S/N 15282040N6782GWilson Zachary R · Richland Center, WIFirst renewal noticeBuilt 1970 · S/N 15072282N67840Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282049
Back to AD 2009-10-09 R2