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.

N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123N9088JRiggins Ryan W · Durango, COBuilt 1966 · S/N 28-3126N908AFRobinson Craig M · Colfax, CABuilt 1967 · S/N 28-23976N9092JRegistered aircraftBuilt 1966 · S/N 28-3130N9093JRichardson Harley T Jr · Mullins, SCS/N 28-3131N9094JDagny Aviation LLC · Gardendale, TXBuilt 1966 · S/N 28-3132N9096JWingsleasing LLC · Wichita, KSBuilt 1966 · S/N 28-3136N9098JNelson Aircraft Sales Inc · Minot, NDBuilt 1966 · S/N 28-3140N9099JEdwards Darron C · Lancaster, CABuilt 1966 · S/N 28-3141N90ENWiggins Gene S · Americus, GAS/N 28-1219N90VWAero Cruise Ltd · Brighton, MIBuilt 1967 · S/N 28-4030N9101JCarter David · Jackson, TNBuilt 1966 · S/N 28-3143N9102JRaper Don A · Woodstock, GAFirst renewal noticeBuilt 1966 · S/N 28-3144N9106JMc Nutt Richard Kevin · De Pere, WIBuilt 1966 · S/N 28-3148N9108JCampbell Aircraft Restorations · London, KYBuilt 1966 · S/N 28-3150N9110JRkd Aviation Services Inc · Dallas, TXBuilt 1966 · S/N 28-3152N9112JCmm Aviation LLC · Dover, FLBuilt 1966 · S/N 28-3154N9114JRouss Charles F · Martinsburg, WVBuilt 1966 · S/N 28-3157N9116JPolcyn Matthew D · Millersburg, OHBuilt 1966 · S/N 28-3160N9119JAlex Aircraft LLC · New Albion, NYBuilt 1966 · S/N 28-3166N911HPBowling Timothy N · Willis, TXBuilt 1974 · S/N 28-7505077N911UAMiloud Chadd K · Fort Worth, TXS/N 28-20262N9120JShastaero Inc · Redding, CABuilt 1966 · S/N 28-3167N9121JMamolou Bill A · Newport Richey, FLBuilt 1966 · S/N 28-3168N9123JQualitair LLC Trustee · MichelstadtBuilt 1966 · S/N 28-3172N9125JOlson Scott S · Mission Hill, SDBuilt 1966 · S/N 28-3174N9127JMettler Bryan Fred · Dansville, NYBuilt 1966 · S/N 28-3176N9128JWyoplane LLC · Rock Springs, WYS/N 28-3178N9129JLindsey Patrick E · Gulf Breeze, FLS/N 28-3179N9132JPortneuf Holdings LLC · Chubbuck, IDBuilt 1966 · S/N 28-3182N9133JCarter Whitney · Jackson, TNBuilt 1966 · S/N 28-3183N9134JRolsing Steve Patrick · Saint Peters, MOBuilt 1966 · S/N 28-3185N9135JSwaz Aviation LLC · Mesa, AZS/N 28-3186N9137JYuma Piper Fliers · Yuma, AZBuilt 1966 · S/N 28-3190N9140JKeller Michael A · South Lake Tahoe, CABuilt 1966 · S/N 28-3194N9141JArvizu Alberto P · Lake Havasu, AZS/N 28-3195N9142JKormash John A · Edgewater, FLBuilt 1966 · S/N 28-3196N9143JN9143j LLC · Fort Wayne, INBuilt 1966 · S/N 28-3197N9145JBonertz Brian J · Muscatine, IAS/N 28-3200N9146JSwarey Steven · Whiteville, TNBuilt 1966 · S/N 28-3201N9148JNovember Nine One Four Eight Juliet LLC · Fulton, MOBuilt 1966 · S/N 28-3203N9149JJones Lynn · Birmingham, ALS/N 28-3204N914HPBonsey James E · Newberg, ORBuilt 1968 · S/N 28-24646N9156JChristian Family Fellowship · Mesa, AZS/N 28-3213N9160JMohan Aditya · Rancho Cordova, CAS/N 28-3218N9161JNortheast Nebraska Aviators Inc · Wayne, NEBuilt 1966 · S/N 28-3220N9162JHillelson Lawrence E · Grosse Ile, MIBuilt 1966 · S/N 28-3221N9163JCavu Flight Training LLC · Freeport, MEBuilt 1966 · S/N 28-3222N9164JArizona Airbourne LLC · Gilbert, AZBuilt 1966 · S/N 28-3224N9166JRed Rock Flying School LLC · Mesa, AZBuilt 1966 · S/N 28-3226
Back to AD 96-10-01 R1