OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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:97-01-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:97-01-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.

N8688YMager Robert R · Quakertown, PABuilt 1969 · S/N 30-1834N8689YBlue Sky Aviators LLC · Winnebago, ILBuilt 1969 · S/N 30-1835N8690POrmsbee Bowden · Longmont, COBuilt 1965 · S/N 24-4138N8691EMiloud Chadd K · Fort Worth, TXBuilt 1976 · S/N 34-7670166N8691PBagwell Robert B · Sequim, WABuilt 1965 · S/N 24-4139N8691YVan Bladeren John A · Tigard, ORBuilt 1969 · S/N 30-1837N8692PKuyoth Christopher J · Lake Orion, MIBuilt 1965 · S/N 24-4140N8692YTedder Ag Technologies Inc · Walsh, COBuilt 1969 · S/N 30-1838N8693YPeregrine Aviation LLC · Winfield, ILBuilt 1969 · S/N 30-1839N8695PDurflinger Aviation LLC · Otterbein, INFirst renewal noticeBuilt 1965 · S/N 24-4143N8695YPurkinje Ltd LLC · Wilmington, DEBuilt 1969 · S/N 30-1841N8699PKroll Corey · Gilbert, SCBuilt 1964 · S/N 24-4097N86AYN86ay LLC · Burke, VABuilt 1977 · S/N 32R-7780478N86SUHeavenly Realms Aviation LLC · Grand Junction, COBuilt 2005 · S/N 2844122N8700PGurney Glenn M · Blanding, UTS/N 24-4146N8701PBusone Vincent Dane · Lakeland, FLBuilt 1965 · S/N 24-4147N8701YSobelman Jack G · Yorba Linda, CABuilt 1969 · S/N 30-1849N8702YMoody Robert · Bridgeport, TXBuilt 1969 · S/N 30-1850N8703PJohnston Dale · Sammamish, WABuilt 1965 · S/N 24-4149N8703YWills Terry W · Cedar Park, TXBuilt 1969 · S/N 30-1851N8704PLarson Alysia E · East Greenwich, RIBuilt 1965 · S/N 24-4150N8705PZanin Benjamin P · Bridgeport, TXS/N 24-4152N8705YQualitair LLC Trustee · MichelstadtBuilt 1969 · S/N 30-1854N8706YLund James C · Powder Springs, GABuilt 1969 · S/N 30-1855N8708PGuyer Vince T · Hancock, IABuilt 1965 · S/N 24-4155N8708YBasso Family Ventures LLC · La Mesa, CABuilt 1969 · S/N 30-1857N8710PNelson Aircraft Sales LLC · Austin, MNBuilt 1965 · S/N 24-4157N8710YSmith Charles W · Savannah, GABuilt 1969 · S/N 30-1859N8711PInternational Academy Of Dance LLC · Santa Cruz, CABuilt 1965 · S/N 24-4158N8712YBurns William Robert · Niceville, FLBuilt 1969 · S/N 30-1861N8713PWix Hershel L · Wilmington, ILBuilt 1965 · S/N 24-4161N8714PBlanchard Paul R · Florissant, MOBuilt 1965 · S/N 24-4162N8717YParker Meyers And Roth Inc · Morgan Hill, CABuilt 1969 · S/N 30-1868N8719PAndrofski Joseph B · Waunakee, WIBuilt 1965 · S/N 24-4168N871DMId Air LLC · Apopka, FLBuilt 1975 · S/N 28R-7535147N8720FWaters Lindsay R · Deland, FLBuilt 1976 · S/N 32R-7780113N8720PBarry Edward P III · Redlands, CABuilt 1965 · S/N 24-4169N8721PLavergne Rusty P · Denham Springs, LABuilt 1965 · S/N 24-4170N8722PMurphy Josiah I · Jarrettsville, MDS/N 24-4171N8723PSima Ronald Scott · Glendale, AZBuilt 1965 · S/N 24-4172N8725PAyoub Michael Kamal · Saint Charles, MOS/N 24-4174N8725YPerkins E G Jr · Greenwood, MSBuilt 1969 · S/N 30-1878N8727PWright John L III · San Antonio, TXBuilt 1965 · S/N 24-4176N8727YGriffin John C · Apopka, FLBuilt 1969 · S/N 30-1880N8729PBas Part Sales LLC · Greeley, COBuilt 1965 · S/N 24-4179N872WAMorin Vincent A · El Segundo, CABuilt 1977 · S/N 28R-7703182N872WLKryzsko Joshua Don · Livingston, MTBuilt 1971 · S/N 28R-7135123N8731YGo Tapa Aero LLC · Wilmington, DEBuilt 1969 · S/N 30-1885N8732CDiluzio Brad M · Graham, WABuilt 1976 · S/N 28R-7635179N8732PComanche Aviation Inc · North Bend, OHBuilt 1965 · S/N 24-4182
Back to AD 97-01-01 R1