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.

N5516FMoore Marcus · Auburn, ALS/N 28-24858N5516UHicks David A · Beaver Dam, WIBuilt 1969 · S/N 28-26228N55173Dareing Chon · San Antonio, TXBuilt 1973 · S/N 28-7305327N5517FMccarthy Mark C · Russellville, ARS/N 28-24859N5517VWest Bryan M · Heath, TXS/N 28-26230N55185Bailey Richard W · Auburn, ALBuilt 1973 · S/N 28-7305329N5518UC1 Aviation LLC · New Orleans, LAS/N 28-26231N551JHN551jh Sky Holdings LLC · Grand Ledge, MIBuilt 1975 · S/N 28-7525185N551PASkowbo Rock G · Jacksonville, FLS/N 28-7225472N55203Mil2atp Inc · Pikeville, NCBuilt 1973 · S/N 28-7325342N55206Shipman Mark J · Nellysford, VABuilt 1973 · S/N 28-7305333N5520FChicago Air LLC · Chicago, ILS/N 28-24862N55214N55214 LLC · Celina, TXBuilt 1973 · S/N 28-7305334N55215Zarama Jose · Easley, SCBuilt 1973 · S/N 28-7305335N55216Huizar Victor · Albuquerque, NMBuilt 1973 · S/N 28-7305336N55219Wilkinson Thomas W · Weyers Cave, VABuilt 1973 · S/N 28-7305337N5521FMarc Inc · Brandon, MSFirst renewal noticeBuilt 1968 · S/N 28-24863N5521UMiller Groom Marie T · Rockford, ILBuilt 1969 · S/N 28-26234N5522UAlbrecht Jeffrey N Trustee · Mount Horeb, WIBuilt 1969 · S/N 28-26237N5523FSirko Frederick S · Portage, INBuilt 1968 · S/N 28-24864N5523UKlein Michael · Gilsum, NHBuilt 1969 · S/N 28-26238N55240General Associated Products Inc · San Lorenzo, CABuilt 1973 · S/N 28-7325349N55244Wiechman Herbert · Boulder, COBuilt 1973 · S/N 28-7305340N5524UClaeys John T · Blue Grass, IAS/N 2826239N5524WHoe David S · Stafford, VABuilt 1962 · S/N 28-614N55251Albatross Air Inc · Beaver, WVS/N 28-7305342N55259Heth Steven L · Westhope, NDBuilt 1973 · S/N 28-7325354N5525FCashion Thomas A · Mastic, NYBuilt 1968 · S/N 28-24866N55260Weich Ronald L · El Paso, TXBuilt 1973 · S/N 28-7305343N55261Barton John S III · Gallatin, MOBuilt 1973 · S/N 28-7305344N55263Fennell Donald H Jr · Hampstead, NCBuilt 1973 · S/N 28-7305345N5526FLandry Raymond L · Stark, NHBuilt 1968 · S/N 28-24867N5526MEz Breezy Fc LLC · San Diego, CAS/N 28-22539N5526UPearl Wings LLC · Doylestown, OHBuilt 1969 · S/N 28-26242N55270Mcconnell Jason A · Rose Hill, VABuilt 1973 · S/N 28-7325356N55272Nienhuis Alvin Dale II · Brooksville, FLBuilt 1973 · S/N 28-7305348N55273Jcb Aircraft Sales & Leasing Inc · Belle Mead, NJBuilt 1973 · S/N 28-7305349N5527FFarnie Christopher J · Jacksonville, FLBuilt 1968 · S/N 28-24868N55284Winters Daniel K · Pennsburg, PABuilt 1973 · S/N 28-7325359N5529FKeiner Larry E · Drums, PABuilt 1968 · S/N 28-24871N5529UStoll Travis · El Dorado Springs, MOBuilt 1969 · S/N 28-26245N5529WHarvey Gregory D Sr · Greenbush, MEBuilt 1962 · S/N 28-623N55301Registered aircraftBuilt 1973 · S/N 28-7325361N55302Coastl Air Inc · Groton, CTBuilt 1973 · S/N 28-7325362N55303Cullum Phillip R Jr · San Tan Valley, AZBuilt 1973 · S/N 28-7325363N55304Brittle Aviation LLC · Chapel Hill, NCBuilt 1973 · S/N 28-7305353N55305Berry Mitchel R · Chatfield, MNBuilt 1973 · S/N 28-7305354N5530WHobgood Sidney · Klamath Falls, ORBuilt 1962 · S/N 28-621N55310Monarch M Miller · Cloverport, KYBuilt 1973 · S/N 28-7325364N55311Aeras Transport LLC · Lewes, DEBuilt 1973 · S/N 28-7305355
Back to AD 96-10-01 R1