OpenAirDocs.org
AD 96-10-01 R1

Registered aircraft · 8,139

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.

N9584JLow Wing LLC · Upland, CABuilt 1966 · S/N 28-3723N9584WMitchell Gary N · Kansas City, KSS/N 28-23030N9585JHaj Aviation Inc · Cypress, TXNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 28-3724N9585WRandolph Richard A · Gallipolis, OHBuilt 1967 · S/N 28-23031N9586JGeorge Neal E · Crestview, FLBuilt 1966 · S/N 28-3725N9586WAlpha 3 LLC · Troy, KSBuilt 1967 · S/N 28-23032N9587JScott Jeremy A · Newark, OHBuilt 1966 · S/N 28-3726N9591JLea Brenda A · Merriam, KSBuilt 1966 · S/N 28-3730N9592WDreamcatcher Aviation LLC · Austin, TXS/N 28-23040N9593JPhillips Raymond A Jr · Vestal, NYBuilt 1966 · S/N 28-3732N9593KShoham Aviation LLC · Richmond, TXBuilt 1976 · S/N 28-7625185N9594JJensen Enterprises LLC · Iola, KSBuilt 1966 · S/N 28-3740N9594WMiddlecoast Air LLC · Grand Rapids, MIBuilt 1967 · S/N 28-23044N9595JMuller Chester E · Hayward, CABuilt 1966 · S/N 28-3741N9596JAstraeos Aviation LLC · Salisbury, NCBuilt 1966 · S/N 28-3742N9596WFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1967 · S/N 28-23046N9597JWingswat LLC · Placentia, CABuilt 1966 · S/N 28-3743N9598JMardis Andrew · Pelzer, SCBuilt 1966 · S/N 28-3744N9599JOrban Kenneth D · Tellico Plains, TNBuilt 1966 · S/N 28-3745N9599WNelson Scott G · Lakota, NDS/N 28-23050N95BRChickasha Wings Inc · Chickasha, OKBuilt 1969 · S/N 28-25841N95JPKeller Justin Allen · Youngstown, FLBuilt 1973 · S/N 28-7305429N9601JGevers Robert L · Lafayette, INBuilt 1966 · S/N 28-3747N9603WMoore Alan Ray · Glenwood, ARBuilt 1967 · S/N 28-23055N9606WMandolesi Daniel Martin · Hulmeville, PABuilt 1967 · S/N 28-23059N9607WK-9 Handler LLC · Henderson, NVBuilt 1967 · S/N 28-23060N9608JGomm Bruce J · Colfax, NDS/N 28-3754N9608WBright Skies Sales & Leasing LLC · Hendersonville, TNBuilt 1967 · S/N 28-23061N9609JAdams Donald J · Lock Haven, PABuilt 1966 · S/N 28-3755N9609WCullen Michael R · Fort Mohave, AZBuilt 1967 · S/N 28-23062N9611JStull Donald K · Catawba, NCBuilt 1966 · S/N 28-3761N9612JReich Gregory N · Schwenksville, PABuilt 1966 · S/N 28-3810N9612WJama Aviation LLC · Blaine, MNBuilt 1967 · S/N 28-23066N9613JKraun Fred M · Fall City, WABuilt 1966 · S/N 28-3766N9613WAir Wilma LLC · Tijeras, NMS/N 28-23067N9614JSkinner Roger · Delanson, NYBuilt 1966 · S/N 28-3767N9614WByrne Matthew A · West Allis, WIBuilt 1967 · S/N 28-23069N9616JGarsteck Paula · Put In Bay, OHBuilt 1966 · S/N 28-3769N9616WKohut Jeanette G · Southern Pines, NCBuilt 1967 · S/N 28-23071N9617JBeaverdam Aeronautics LLC · Chatom, ALBuilt 1966 · S/N 28-3771N9617WPoskevich Douglas P · Deland, FLS/N 28-23072N9619JFlick Kristina R · Port Ewen, NYBuilt 1966 · S/N 28-3773N9619WId Rather Knot LLC · Louisville, KYBuilt 1967 · S/N 28-23075N961WLoma Aviation LLC · San Diego, CABuilt 1966 · S/N 28-3811N9622JAlpha Bravo Aviation LLC · Queen Creek, AZBuilt 1966 · S/N 28-3778N9622WKahn Aaron D · Alexandria, VABuilt 1967 · S/N 28-23079N9623JVirginia Street Partnership · Farmville, VABuilt 1966 · S/N 28-3779N9623WLiu Kevin R · Alhambra, CABuilt 1967 · S/N 28-22988N9624JTideline Aviation LLC · Wilmington, NCBuilt 1966 · S/N 28-3780N9624WJanak Jeffrey J · Corpus Christi, TXBuilt 1967 · S/N 28-23080
Back to AD 96-10-01 R1