OpenAirDocs.org
AD 96-24-17 R1

Registered aircraft · 1,458

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-24-17-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-24-17-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.

N1354BStieber Joe · Brownwood, TXBuilt 1948 · S/N 5981N1354KDenicola Michael B · Ruidoso, NMBuilt 1946 · S/N 4081N1356KAnderson Andrew A · Bates City, MOS/N 4083N1357BHall Frederick R · Marana, AZS/N 5984N1358BBoyko Seth · Ruso, NDS/N 5985N1358KUllman Holdings LLC · Fort Myers, FLS/N 4085N1359KRooster Aviation LLC · Payson, UTS/N 4086N1360BMcmillian Custom Service Inc · Waynesboro, GABuilt 1948 · S/N 5987N1360KFinney Kevin A · Hawthorne, FLBuilt 1946 · S/N 4087N1364KYager Stuart O · Wellington, KSBuilt 1946 · S/N 4091N1365KWesterberg Roger K · Cottage Grove, MNBuilt 1946 · S/N 4092N1366BCarter George E · Brownwood, TXS/N 5993N1372BBorden Lance S · Friendswood, TXBuilt 1948 · S/N 5999N1374BWidman Robert M · Fairbanks, AKS/N 6001N1378KHebron Jeffrey N · Trenton, SCBuilt 1946 · S/N 4105N1380KKoebel Allan Trustee · High Ridge, MOBuilt 1946 · S/N 4107N1381BJames Dennis · Pleasant Grove, CAS/N 6008N1382KPierce Larry J · Moxee, WABuilt 1946 · S/N 4109N1387KFlurry Richard · Piedmont, OKS/N 4114N1388BSchmid Nathan J · Wilmington, OHBuilt 1948 · S/N 6015N1390BSowers Harry D · S Bloomingvil, OHBuilt 1948 · S/N 6017N1392BGrinder Michael C · Fairfield, PABuilt 1948 · S/N 6019N1394KRohleder Joseph · La Salle, COS/N 4121N1396KNelson Daniel N · Newark, ILBuilt 1946 · S/N 4123N1398KSale Reported · Inola, OKSale reportedBuilt 1946 · S/N 4125N1399KSattelmayer Ralph · Sacramento, CABuilt 1946 · S/N 4126N13CQCajun Queen 8a LLC · Ormond Beach, FLBuilt 1946 · S/N 3867N1400BIler Elden · Van Nuys, CAS/N 6027N1400KKush John J Jr · Oil City, PABuilt 1946 · S/N 4127N1401BSummers Greg D · Sheridan, ORBuilt 1948 · S/N 6028N1402BSlys Aircraft Service · Platte, SDBuilt 1948 · S/N 6029N1406BBadenhorse Frans · Hawthorne, FLBuilt 1948 · S/N 6033N1407BAufdencamp Timothy E · Bloomdale, OHBuilt 1948 · S/N 6034N1411BBowen Haldor S · Sandpoint, IDBuilt 1948 · S/N 6038N1412KHarvey Donald L · Wheeling, WVBuilt 1946 · S/N 4139N1413KBennett Robert M · Felton, DEBuilt 1946 · S/N 4140N1414BWatson Bobby M · Hoxie, ARBuilt 1948 · S/N 6041N1416BGould Aaron J · Aptos, CABuilt 1948 · S/N 6042N1418BGrewell Ronald V · West Carrollton, OHBuilt 1948 · S/N 6045N1419BHattan John A · Goddard, KSBuilt 1948 · S/N 6046N1420BWeber Joel A · Goddard, KSBuilt 1948 · S/N 6047N1420KMolohan Ronald M · Elk Grove, CABuilt 1946 · S/N 4147N1423KEnglund Ronald E · Springfield, ORBuilt 1946 · S/N 4150N1424KStarke Daniel L · Odessa, TXRegistration revokedBuilt 1946 · S/N 4151N1425BHicks Jason F · Denver, COBuilt 1948 · S/N 6052N1426KDavis John E · Fairland, INBuilt 1946 · S/N 4153N1428KNordby Bonin S · Nampa, IDS/N 4155N1430BLutz Terry L · Williamston, MIBuilt 1948 · S/N 6057N1432BSpurgeon Michael R · Wrightwood, CABuilt 1948 · S/N 6059N1434BGraznak Timothy C · Greeley, COS/N 6061
Back to AD 96-24-17 R1