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.

N5176SNora Jet LLC · Granbury, TXS/N 28-7105030N5177WBuffham Daniel L · Meridian, IDBuilt 1961 · S/N 28-212N5178LMinick And Son LLC · Beatrice, NEBuilt 1967 · S/N 28-4464N5178WMahoney Christopher P · Quakertown, PABuilt 1961 · S/N 28-213N517JCProfessional Pilot Services · Appleton, WIBuilt 1971 · S/N 28-7125098N5180LGrogan Timothy · Bradenton, FLBuilt 1967 · S/N 28-4466N5181SHicks Douglas A · Cumming, GABuilt 1970 · S/N 28-7105035N5181WSzymanski Janet M · Alanson, MIBuilt 1961 · S/N 28-216N5182LGarden City Aviation LLC · Augusta, GABuilt 1967 · S/N 28-4469N5182SFoster Tyler R · Levelland, TXS/N 28-7105036N5183SWestland Aviation LLC · Lake Havasu City, AZBuilt 1970 · S/N 28-7105037N5184LOtt Timothy M · Ida, MIBuilt 1967 · S/N 28-4472N5184S1st Cooling Inc · Rockwall, TXBuilt 1970 · S/N 28-7105038N5186WQuick Janice L · Wrightwood, CABuilt 1961 · S/N 28-221N5187LMcclelland Kip · Douglas, GAS/N 28-4475N5187WGardner Robert E · Dixon, CABuilt 1961 · S/N 28-222N5188SMiller Kaci · Bullhead City, AZBuilt 1970 · S/N 28-7105046N5189LMicic Miodrag · Lake Elsinore, CABuilt 1968 · S/N 28-5129N5189SBender Douglas E · Kendallville, INBuilt 1970 · S/N 28-7105049N518BW8bravo Wiskey LLC · New Liberty, KYBuilt 1974 · S/N 28-7405240N5190LKing Samantha M · Mcdonough, GABuilt 1967 · S/N 28-4479N5190SRobinson Richard D · Montclair, CABuilt 1970 · S/N 28-7105050N5191LGravley Kevin · Wiggins, MSBuilt 1967 · S/N 28-4480N5192LKirkpatrick William J · Tyrone, PAS/N 28-4481N5192SCxo Time Builder LLC · Magnolia, TXBuilt 1970 · S/N 28-7105052N5193LC And H Aviation LLC · Madison, MSBuilt 1967 · S/N 28-4482N5193SEagle Christopher S · Columbus, GABuilt 1970 · S/N 28-7105053N5194LByham Shawn Grant Charles · Santa Margarita, CABuilt 1967 · S/N 28-4483N5195SToby Aviation Inc · Pigeon Forge, TNBuilt 1970 · S/N 28-7105055N5195WQuenzer Floyd N · Fresno, CABuilt 1961 · S/N 28-230N5197LSeuferer Kevin J · Osceola, IABuilt 1967 · S/N 28-4487N5197SHaertlein Lauren L · Annapolis, MDBuilt 1970 · S/N 28-7105048N5199LPrince Bros Aviation LLC · North Canton, OHBuilt 1967 · S/N 28-4489N5199STacoma Sky LLC · Winston Salem, NCS/N 28-7105058N51BPBravo Papa Flight Training LLC · Wichita Falls, TXBuilt 1965 · S/N 28-2531N51RAK And D Aviation Inc · Robbinsville, NJS/N 28-7105147N5200LDecker Michael · Baxter, TNBuilt 1967 · S/N 28-4490N5200TUding Michael E · Sainte Genevieve, MOBuilt 1972 · S/N 28-7205246N5201WStevens Wayne E II · Denver, COBuilt 1961 · S/N 28-236N5203LMelnik George L · Wheeling, WVBuilt 1968 · S/N 28-4494N5204LChappell Earl W · New Cumberland, WVBuilt 1967 · S/N 28-4495N5205LPons Miguel E · Aptos, CABuilt 1967 · S/N 28-4496N5205THangar 9 Inc · Aberdeen, SDBuilt 1972 · S/N 28-7225337N5205WAircraft 1821 LLC · North Charleston, SCBuilt 1961 · S/N 28-240N5206LNora Jet LLC · Granbury, TXBuilt 1967 · S/N 28-4497N5207LDon'T Panic! LLC · Vancouver, WABuilt 1967 · S/N 28-4498N5208TGarrett Jerry M · Shreveport, LAS/N 28-7225353N5209LKing Christian T · Rhinelander, WIBuilt 1967 · S/N 28-4501N520FLSiry Kristina · Mertztown, PABuilt 1971 · S/N 28-7125345N5210LDewilde Lee Ray · Huslia, AKBuilt 1967 · S/N 28-4502
Back to AD 96-10-01 R1