OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,138

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:96-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
  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.

N16435Gumms Leroy J · Perris, CAS/N 28-7305254N1643JDe Bry Daniel G · Dowagiac, MIS/N 28-24034N16446Cash Management Consulting LLC · Granite Springs, NYBuilt 1973 · S/N 28-7325274N16447Cornejo Mauro R · Tucson, AZBuilt 1973 · S/N 28-7325276N16448Lynch Timothy Christopher · Robbinsville, NJBuilt 1973 · S/N 28-7305256N16449Cloud Nine Flying Club Inc · Fergus Falls, MNBuilt 1973 · S/N 28-7305257N1644JTurner Colby · Lamar, COBuilt 1967 · S/N 28-24036N16456Blackwell Jerry R · Jackson, TNBuilt 1973 · S/N 28-7305260N16458Greenwood Flyers LLC · Kinards, SCBuilt 1973 · S/N 28-7305261N1645JWhite Jesse J · Penn Valley, CABuilt 1967 · S/N 28-24037N16468Am Aviation LLC · University City, MOBuilt 1973 · S/N 28-7325279N16484Johnson Training Institute LLC · Zachary, LABuilt 1973 · S/N 28-7305264N16485Elemental Process Solutions LLC · Troy, ILBuilt 1973 · S/N 28-7305265N16488Kuemmerle Steven C · Grayslake, ILBuilt 1973 · S/N 28-7305266N1648JMilan Air Service Inc · Milan, MIS/N 28-24041N16490Schlott James W · East Falmount, MABuilt 1973 · S/N 28-7325284N16492Fields Franc C · Jessup, MDBuilt 1973 · S/N 28-7305268N16496Gesler Mark A DBA · Lima, OHBuilt 1973 · S/N 28-7305270N1649JRegistration Pending · Bozeman, MTRegistration pendingBuilt 1967 · S/N 28-24042N16509Greensburg Jeannette Airport Administration · Jeannette, PABuilt 1973 · S/N 28-7305271N1650JQureini Khalil H Vii · Kansas City, MOBuilt 1967 · S/N 28-24043N16513Ashworth Diane A Executor · Chase City, VABuilt 1973 · S/N 28-7305273N16526Wesley Joseph L · Pismo Beach, CABuilt 1973 · S/N 28-7325291N16527Skolnick Sanford M · Novato, CABuilt 1973 · S/N 28-7305274N16534Wahler Edward William III · Asheville, NCBuilt 1973 · S/N 28-7325292N16535Wdc Enterprises LLC · Beaumont, TXBuilt 1973 · S/N 28-7325293N16537Lesmeister Dillon J · Chadron, NEBuilt 1973 · S/N 28-7305277N1653JSale Reported · Bloomburg, TXSale reportedBuilt 1967 · S/N 28-24047N16547Mickle Charles R · Hinton, OKS/N 28-7325297N16548Watchman Aviation LLC · Pierceton, INBuilt 1973 · S/N 28-7305280N1654JStygar Richard M · Coal City, ILBuilt 1967 · S/N 28-24049N16551Mike Smith Construction Inc · Holyoke, COBuilt 1973 · S/N 28-7305283N1655JGallant Arthur · Kingston, NHBuilt 1967 · S/N 28-24051N16560Wasson Tom L · Lakeport, CABuilt 1973 · S/N 28-7325298N16564Bradley Jason · Fort Mohave, AZBuilt 1973 · S/N 28-7305285N16583Gawlikowski Joseph J · Spearfish, SDBuilt 1973 · S/N 28-7325301N1659JHanger C22 LLC · Hillsboro, ORBuilt 1968 · S/N 28-24056N1662JAltaverde LLC · Port Orange, FLBuilt 1967 · S/N 28-24059N1666JHutchinson George · Wolfeboro, NHBuilt 1967 · S/N 28-24064N1668JJimenez Bryan · Los Angeles, CABuilt 1968 · S/N 28-24068N1673JSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1967 · S/N 28-24074N1674JCaloon John H · Greenfield, MABuilt 1968 · S/N 28-24075N1675JTevis Aviation Inc · Emporia, KSBuilt 1967 · S/N 28-24076N1677JCross X Country LLC · Great Falls, VABuilt 1968 · S/N 28-24078N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079N1682JBeatty Gary A · Mosinee, WIBuilt 1967 · S/N 28-24083N1683JMiranda Emigdio · El Dorado Hills, CAS/N 28-24084N1684HPlane Folks LLC · Tucson, AZBuilt 1977 · S/N 28-7725154N1684JJarriel Investments Inc · Register, GABuilt 1967 · S/N 28-24086N1686JPatterson John E · Jacksonville, ILBuilt 1967 · S/N 28-24088
Back to AD 96-10-01 R1