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.

N55736Fox Ralph W II · Wilmington, NCBuilt 1973 · S/N 28-7305373N55738Wenner William E · Kechi, KSBuilt 1973 · S/N 28-7325473N55739Kepfer Robert · Felton, DEBuilt 1973 · S/N 28-7305456N5573WHokanson Elijah R · Ashby, MNS/N 28-668N55742Doyal William T · Visalia, CABuilt 1973 · S/N 28-7325474N55743B&R Aircraft LLC · Wadsworth, OHBuilt 1973 · S/N 28-7325475N55744Williams Mike · Hartsville, INS/N 28-7325476N55746Mccoy Michael E · Sanford, NCBuilt 1973 · S/N 28-7305459N5574UCooper Nicholas A · Plano, TXBuilt 1969 · S/N 28-26303N5574WNordell Ryan J · Roberts, WIBuilt 1962 · S/N 28-669N5575FBrewington Jesse L · Glenallen, MOBuilt 1968 · S/N 28-25011N55761Ramirez Ramon E · Boynton Beach, FLBuilt 1973 · S/N 28-7305462N55769Urban Joseph P · Ben Wheeler, TXBuilt 1973 · S/N 28-7325482N5576UChambers Luther · New Philadelphia, OHS/N 28-26305N5576WKoch Christopher P · Batavia, NYBuilt 1962 · S/N 28-678N55771Christman Timothy J · Stillwater, MNBuilt 1973 · S/N 28-7305464N5577FFederici Susan L · Vineland, NJBuilt 1968 · S/N 28-24910N55780Sibayan Jose E · Lutz, FLS/N 28-7325483N55783Djh Leasing LLC · De Pere, WIBuilt 1973 · S/N 28-7305467N55785La Grange Aviation LLC · Bolingbrook, ILBuilt 1973 · S/N 28-7305469N5578UHolmes Robert G · Jacksonville, FLBuilt 1969 · S/N 28-26308N5578WVigano Davide · Redmond, WABuilt 1962 · S/N 28-685N55790Buzzard Aviation LLC · Pace, FLBuilt 1973 · S/N 28-7325487N55792Ramocinski Carson · Prescott, AZBuilt 1973 · S/N 28-7305471N5579FSeaplane Adventures LLC · Cheyenne, WYBuilt 1968 · S/N 28-24912N5579UInternational Air Services Inc Trustee · Carson City, NVBuilt 1970 · S/N 28-26887N557SWMarshall John F III · Sterling Heights, MIBuilt 1968 · S/N 28-25193N55801Jacobs Michael A · Modesto, CABuilt 1973 · S/N 28-7325488N55802Thomas Tommy A · Garden Grove, CABuilt 1973 · S/N 28-7305473N55803Georgoulianos Anthanasios · Sweetwater, NJBuilt 1973 · S/N 28-7305475N55808Oltrogge Michael · Bancroft, NEBuilt 1973 · S/N 287305416N5580WSmitty 172 LLC · Rockford, MIS/N 28-691N55811Scott Tyler C · Ball Ground, GABuilt 1973 · S/N 28-7325490N55816Flying Manatees LLC · Wilmington, DEBuilt 1973 · S/N 28-7325492N55818Lovejoy Aviation LLC · Cato, NYBuilt 1973 · S/N 28-7325494N5581WRay Justin P · Centre, ALBuilt 1962 · S/N 28-666N55823Steele Lawrence D · Belleair Beach, FLBuilt 1973 · S/N 28-7305436N55824Ray Foster Stephen · Stockton, CABuilt 1973 · S/N 28-7325495N55827Debonis Nicholas Michael · Woodland, CABuilt 1973 · S/N 287305477N5582UPatterson Saralyn · Oklahoma City, OKS/N 28-26311N5582WRieger Karen M · Indianapolis, INBuilt 1962 · S/N 28-697N55838Hintenlang David · Archer, FLBuilt 1973 · S/N 28-7305435N5583FAiken Pilot Training LLC · Johnston, SCBuilt 1968 · S/N 28-24916N55840Walko Michael E · Scotch Plains, NJBuilt 1973 · S/N 28-7325551N55842Ansboro James C · Goshen, NYBuilt 1973 · S/N 28-7325502N55844Cozby Charles L · Wellsboro, PAS/N 28-7325503N5584FGuiliano Anthony · Tobyhanna, PABuilt 1968 · S/N 28-24917N5584WDill Mark B · Amarillo, TXBuilt 1962 · S/N 28-658N55852Ingold Terry L · Albemarle, NCBuilt 1973 · S/N 28-7305484N5585FSouth Texas Air Force LLC · Mission, TXBuilt 1968 · S/N 28-24918
Back to AD 96-10-01 R1