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.

N77956Hayllar Russell W · Newnan, GABuilt 1946 · S/N 3683N77971Ricol Aviation LLC · Naples, FLS/N 3698N77974Tupelo Aeronautics Inc · Tupelo, MSBuilt 1946 · S/N 3701N77986Urash Richard M · Americus, GABuilt 1946 · S/N 3713N77988Gurr James E · Alden, MIBuilt 1946 · S/N 3715N77989Lennon David K · Hampton, NHBuilt 1946 · S/N 3716N77995Vintage Adventures Inc · Ocala, FLBuilt 1946 · S/N 3722N77997Michel Ralph E · Saint James, MOBuilt 1946 · S/N 3724N801BLiem Daniel L · Brea, CABuilt 1950 · S/N 6731N801DRLuy Jonathan C · Sutter Creek, CABuilt 1948 · S/N 5972N803BBores Scott J · Huron, OHS/N 6733N804PBFrazier Brian D · Jackson, MSBuilt 1950 · S/N 6734N805BMast Henry V · Dayton, TXBuilt 1950 · S/N 6735N8062CLazypp Et Al LLC · Kalispell, MTBuilt 1947 · S/N 5423N806BBuoni Darin P · Bakersfield, CAS/N 6736N809BSecker Timothy A · Olympia, WABuilt 1950 · S/N 6739N811BPietsch Warren A · Minot, NDBuilt 1950 · S/N 6741N812BHawley Elizabeth Bourland · Wichita Falls, TXBuilt 1950 · S/N 6742N813BSutter Timothy C · Glennallen, AKS/N 6743N815BStrong James R · Williamsville, NYBuilt 1950 · S/N 6745N8218BAce Aeromotive Inc · Miami, FLBuilt 1946 · S/N 4028N8219NWilder Kirk E · Boonville, CAS/N 1331N822BRichter Paul J · Chelmsford, MABuilt 1950 · S/N 6753N829BBaxter Thomas L · Stockbridge, GABuilt 1950 · S/N 6760N831BMorrison Ronald J · Murfreesboro, TNBuilt 1950 · S/N 6762N832PWatson Bobby · Hoxie, ARBuilt 1950 · S/N 6764N836BLandrum Cristi C · Dallas, TXBuilt 1950 · S/N 6768N837BHendry Rickey · Apple Springs, TXBuilt 1950 · S/N 6769N8382Willis William P Trustee · New Palestine, INS/N 6331N840BWilkey Ryan J · Saint Louis, MOBuilt 1950 · S/N 6772N84135Blackburn Richard L · Pendleton, ORS/N 5845N842BShank Ronald D · Greensburg, KSBuilt 1950 · S/N 6774N882JBBock Gregory D · Walkertown, NCBuilt 1948 · S/N 6011N88581Glista James T · Enfield, CTS/N 1410N90435Bowen Michael A · Pendleton, SCBuilt 1946 · S/N 4413N90533Blake Aaron T · Selma, INBuilt 1946 · S/N 3817N9192FOwens Lewis F · Fillmore, INS/N 2805N9255MMalnichuck Thomas C · Apple Valley, CAS/N 5238N937RMCoffey Daniel J · Hartford, WIBuilt 1948 · S/N 6056N93CKBeck Larry A · Arkdale, WIBuilt 1946 · S/N 4036N947MRObritsch Monte R · Malcolm, NES/N 4991N97401Durossette Darryl Z · Eugene, ORBuilt 1946 · S/N 4067N9901CGritt Bradley · Marseilles, ILBuilt 1957 · S/N S-4N9908CBarker Geoffrey B · Plattsburgh, NYBuilt 1959 · S/N S-11N9911CSilva Brenda M · Snowflake, AZBuilt 1959 · S/N S-15N9912CMcmillin Christopher W · Tucson, AZBuilt 1959 · S/N S-16N9915CRobertson Terry N · Boynton Beach, FLBuilt 1959 · S/N S-19N9916CLill Stephen P · Lafayette, LABuilt 1959 · S/N S-20N9922CCarswell Chris · Kent, WABuilt 1959 · S/N S26N9927CMartin Harry L · Clayton, GABuilt 1959 · S/N S-31
Back to AD 96-24-17 R1