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.

N8007Fedorko David · Tampa, FLS/N 28-3225N8007WMoreau Claude J · Moneta, VABuilt 1964 · S/N 28-2068N8008NHudson Maury B · Humble, TXBuilt 1968 · S/N 28-25249N8008WHockett Patricia A Trustee · Granbury, TXBuilt 1965 · S/N 28-2069N8009NSchenkat Mark H · Baraboo, WIBuilt 1968 · S/N 28-25250N8009W282 Rsa LLC · Naples, FLBuilt 1964 · S/N 28-2071N8010WAustin Steven · Navasota, TXBuilt 1964 · S/N 28-2072N8011WByrd John C · Garland, TXBuilt 1964 · S/N 28-2074N8012NRegistration Pending · Alexandria, VARegistration pendingBuilt 1969 · S/N 28-25253N8012WDe Torres Thomas · Fithian, ILFirst renewal noticeBuilt 1964 · S/N 28-2075N8013NDowns Michael M · Sarasota, FLBuilt 1968 · S/N 28-25255N8013WFergus Greg S · Frisco, TXBuilt 1964 · S/N 28-2076N8014NLambert Daniel V · Mosheim, TNBuilt 1968 · S/N 28-25256N8015NPatton Aviation LLC · Billings, MTBuilt 1968 · S/N 28-25257N8015WRayferd Air LLC · Douglas, GABuilt 1964 · S/N 28-2078N80161Redlin Thomas J · Sioux Falls, SDBuilt 1969 · S/N 28-25259N8018WBloser Austin P · Adel, GAS/N 28-2083N8019WJeffs Free-1 To Fly LLC · Pennsburg, PABuilt 1964 · S/N 28-2084N801FSRenfro Michael W · Bethel, AKBuilt 1970 · S/N 28-7125090N8021NThibodeaux Bert J · Cedar Rapids, IABuilt 1968 · S/N 28-25264N8022NNiendorf John R · Friday Harbor, WABuilt 1968 · S/N 28-25265N8022WDean Newton Aviation LLC · Whitehouse Station, NJBuilt 1964 · S/N 28-2087N8023NStafford Craig A · Tempe, AZBuilt 1968 · S/N 28-25267N8023WHydroplane Ltd · Sherman Oaks, CABuilt 1965 · S/N 28-2918N8024NAll American Aviation Services Inc · Fayetteville, NCBuilt 1968 · S/N 28-25268N8025N8025n Flyers Ltd · Monsey, NYBuilt 1968 · S/N 28-25269N8025WMann Nicholas Lee · Grand Canyon, AZBuilt 1964 · S/N 28-2090N8026NJenkins Carl S · Muncy, PABuilt 1968 · S/N 28-25270N8029NHeydenreich Jacob N · Hartford, ARBuilt 1968 · S/N 28-25274N802FSShelton Shannon · Hampton, GABuilt 1971 · S/N 28-7125398N802UMLawrence Dayle A · Scotia, CABuilt 1972 · S/N 28-7225524N8030NWilson Mark A · Havana, FLBuilt 1968 · S/N 28-25275N8030WGosse Luke J · Waterloo, IABuilt 1964 · S/N 28-2096N8031WGraziano Michael A · Freeport, NYBuilt 1965 · S/N 28-2097N8033WRegistration Pending · Burlington, WARegistration pendingBuilt 1965 · S/N 28-2099N8034NKoehler Gerry P · Harbor City, CABuilt 1968 · S/N 28-25279N8034WFieldgrove Kevin · Monroe, GABuilt 1965 · S/N 28-2101N8037WUtterback Harry Lee · Prescott, AZBuilt 1965 · S/N 28-2104N803TWGsfcpp Corp · Palm City, FLBuilt 1968 · S/N 28-5117N803WWHarmon Louie · Gainesboro, TNS/N 28-2102N8040WJeff Abrams-2 LLC · Ocala, FLBuilt 1965 · S/N 28-2108N8041WBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 28-2110N8043WMcabee Aviation LLC · Fresno, CABuilt 1965 · S/N 28-2112N8044NN7396w LLC · Coeymans Hollow, NYBuilt 1968 · S/N 28-25289N8044WKananen Agency Inc · Joliet, MTBuilt 1965 · S/N 28-2114N8045WOpen Engineering LLC · Ames, IABuilt 1965 · S/N 28-2919N8046WMuthandi John M · Woodland, WABuilt 1965 · S/N 28-2116N8047WFlying Fossil LLC · Franklin, TNBuilt 1965 · S/N 28-2119N8048CDegraff Claude Md · Fort Myers, FLBuilt 1975 · S/N 28-7625093N8049NKolbjornsen Arne · Middletown, DES/N 28-25295
Back to AD 96-10-01 R1