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.

N8618SBenson Dusty J · Melstone, MTBuilt 1965 · S/N 15061918N8619JErickson Max W · Cumberland, WIFirst renewal noticeBuilt 1967 · S/N 15066519N8619USpadaro James · Cross Lanes, WVBuilt 1976 · S/N 15077961N861TWTailwinds LLC · Ewing, NJS/N 15073507N8620JCampbell John L · Lincoln, NEBuilt 1967 · S/N 15066520N8620SSorrell Zachariah G · Palmer, AKBuilt 1965 · S/N 15061920N8621GKlopotek Jeffrey D · Waterman, ILFirst renewal noticeBuilt 1965 · S/N 15062721N8621UTomsheck Brothers · Oilmont, MTBuilt 1976 · S/N 15077962N8623SBucks Flight Academy LLC · Cashion, OKBuilt 1965 · S/N 15061923N8624SToth Frank L · Schenevus, NYS/N 15061924N8625GDelong Erika Dee · Forest Lake, MNBuilt 1965 · S/N 15062725N8625SMendoza Erik · Pleasanton, TXS/N 15061925N8626GMcflight Aviation LLC · Highland, UTBuilt 1966 · S/N 15062726N8626JSeitz David J · Mauston, WIBuilt 1967 · S/N 15066526N8627GMahaini Saad · Lucas, TXBuilt 1966 · S/N 15062727N8628GLongmuir Charles H · Newport, MES/N 15062728N8628JJacobi Joseph · Mexico, MOBuilt 1967 · S/N 15066528N8628SDiaz George D · Tucson, AZS/N 15061928N8630GGoehring Melissa S · Grand Rapids, MIBuilt 1965 · S/N 15062730N8630JDean M O · Corpus Christi, TXBuilt 1967 · S/N 15066530N8631JKing Boyd F · Okmulgee, OKBuilt 1967 · S/N 15066531N8631SSteiger Marley C · Glenham, SDBuilt 1965 · S/N 15061931N8632GChappell Stephen · Wilmington, NCBuilt 1966 · S/N 15062732N8633JHise Mark J · Nolensville, TNBuilt 1967 · S/N 15066533N8633SUhler John A · Rimrock, AZBuilt 1965 · S/N 15061933N8634GRegistration Pending · Princeton, MARegistration pendingBuilt 1966 · S/N 15062734N8634JDestination 55 LLC · Cave Springs, ARBuilt 1967 · S/N 15066534N8634SHersom Jeffrey T · Helena, MTBuilt 1965 · S/N 15061934N8634UTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1975 · S/N 15077246N8635GSmith Andrew W · Willow, AKBuilt 1965 · S/N 15062735N8635SWood Timothy M · Jefferson, MES/N 15061935N8635UTango Thirty One Aero Clube Inc · Mckinney, TXBuilt 1976 · S/N 15077965N8637GReichenbach Louis · Northville, MIBuilt 1966 · S/N 15062737N8638SLyon Ronald C · Berlin, VTBuilt 1965 · S/N 15061938N8639GRegistered aircraftBuilt 1966 · S/N 15062739N863TAKeating Scott G · Ormond Beach, FLBuilt 1985 · S/N 15286026N8640GRoss Peter W · Lufkin, TXBuilt 1965 · S/N 15062740N8641SSimmons Anthony C Jr · Allendale, SCBuilt 1965 · S/N 15061941N8642UNemerovsky Jason B · Plantation, FLS/N 15077966N8644GMelin Jeff C · Kenmare, NDBuilt 1965 · S/N 15062744N8644SRiggan Charles H · Oxford, NCBuilt 1965 · S/N 15061944N8645URocereta Aaron W · Eagle River, AKBuilt 1976 · S/N 15077967N8646SFoster Brian E · Bartley, NEBuilt 1965 · S/N 15061946N8648GAugust Aero LLC · Kalispell, MTS/N 15066728N8648SSnodgrass Gavin I · Belle, MOS/N 15061948N8649GMullins Steve F · Belews Creek, NCBuilt 1965 · S/N 15062749N8649SGuffey Edward B · Bessemer City, NCBuilt 1965 · S/N 15061949N864TGTouch N Go Aeroworks LLC · Greenville, SCS/N 15068527N8650SGrant Clinton A Trustee · Portage Des Sioux, MOS/N 15061950N8652SKindel Michael W · Bismarck, NDS/N 15061952
Back to AD 2009-10-09 R2