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.

N7844FWise Jonathan Keith · Eden, NCS/N 15063944N7846FGrossman Steven · Seven Valleys, PAS/N 15063946N7851FDevries James E · Bejou, MNBuilt 1966 · S/N 15063951N7853FEdwards Michael J · Hazlehurst, GABuilt 1966 · S/N 15063953N7855FSmith Joshua B · Kenai, AKS/N 15063955N7856FFitzgibbon Patrick D · Waterloo, WIBuilt 1966 · S/N 15063956N7858FShelley Tiffany · Chandler, AZFirst renewal noticeS/N 15063958N7860FVahary David J · Portage, INBuilt 1966 · S/N 15063960N7861FFranks Bryan S · Camarillo, CABuilt 1966 · S/N 15063961N7867UGregersen Michael · Blackfoot, IDBuilt 1976 · S/N 15077851N786FMSantosaircraft LLC · Fort Lauderdale, FLBuilt 1979 · S/N 15283894N7874FLynch Cody J · Stanwood, WAS/N 15063974N7875FDeffendall Cathy S · Florissant, MOBuilt 1966 · S/N 15063975N7876FSavedge A Randolph · Surry, VABuilt 1966 · S/N 15063976N7877FCosta Air Service LLC · Painted Post, NYBuilt 1966 · S/N 15063977N787FMMelillo Vince · Belvidere, ILBuilt 1978 · S/N 15281802N787JABole David M · Auburn, WABuilt 1973 · S/N 15074546N7881FNorman Robert A · Zanesville, OHBuilt 1966 · S/N 15063981N7881UN7881u LLC · Mcminnville, ORBuilt 1976 · S/N 15077854N7883GPhillips Douglas C · Ephrata, PABuilt 1973 · S/N 15074734N7887FSwearingin Curtis A · Carrollton, MOBuilt 1966 · S/N 15063987N7887UShaner Ervin Craig · Willow Spring, NCBuilt 1976 · S/N 15077855N7890FScholz Francis M · Atchison, KSBuilt 1966 · S/N 15063990N7891UCessna 150 152 Fly In Foundation · Springfield, VABuilt 1976 · S/N 15077857N7893FBrowett Donald · Independence, MOBuilt 1966 · S/N 15063993N7895FBrock Michael G · New Lenox, ILBuilt 1966 · S/N 15063995N7897FOneonone Flight Training LLC · Hagerstown, MDBuilt 1966 · S/N 15063997N7900FValley Wine Exports LLC · Rollingbay, WABuilt 1966 · S/N 15064000N7903FSmith Troy D · Arcadia, INBuilt 1966 · S/N 15064003N7909FK-Air Inc · Egg Harbor, WIBuilt 1966 · S/N 15064009N7913UKashmir Air Inc · Somerset, NJBuilt 1976 · S/N 15077859N7914FPrater Stewin W · Chillicothe, OHBuilt 1966 · S/N 15064014N7920FFalk William P · Milford, CTBuilt 1966 · S/N 15064020N7922UButler Brandon R · Redmond, ORBuilt 1976 · S/N 15077861N7926FRandolph Wallie R · Nebo, NCBuilt 1966 · S/N 15064026N7927GUrban Aviation Services Inc · Paxton, MABuilt 1973 · S/N 15074736N7928FCelestial Kinetics Flight Academy LLC · Waupaca, WIBuilt 1966 · S/N 15064028N7928UPerson John · Wichita, KSBuilt 1976 · S/N 15077865N7930GRaney Wayne L · Hoxie, KSBuilt 1973 · S/N 15074738N7932GDs Flight Services LLC · Battle Ground, WAS/N 15074740N7932UShenandoah Aviators LLC · Rockingham, VAS/N 15077869N7933GGenzman Dennis W · Tucson, AZBuilt 1973 · S/N 15074741N7933UHub City Aviation Academy LLC · Lubbock, TXBuilt 1976 · S/N 15077870N7934FKay Bennie L · Brigham City, UTS/N 15064034N7935FB&R Aerial Crop Care Inc · Connell, WABuilt 1966 · S/N 15064035N7937FSomes Brad H · Goddard, KSBuilt 1966 · S/N 15064037N7938FPanik Kevin R · Titusville, FLS/N 15064038N7940FMile High Flight Club Inc · Miami, FLBuilt 1966 · S/N 15064040N7941FLewis William J · Nashville, TNBuilt 1966 · S/N 15064041N79425Legends Airways LLC · Lakeland, FLBuilt 1967 · S/N 15067734
Back to AD 2009-10-09 R2