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.

N8814YTwin C 14y LLC · Cape Coral, FLBuilt 1969 · S/N 30-1972N8815YBauer Andrew J · Concord, NCBuilt 1969 · S/N 30-1973N8817PTei Corp · Kalispell, MTBuilt 1965 · S/N 24-4273N8817YWiehl Thomas K III · Earlysville, VABuilt 1969 · S/N 30-1975N8818YSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 30-1976N8819ETransition Aviation LLC · Hummelstown, PABuilt 1976 · S/N 28R-7635209N8819PN8819p LLC · Boca Raton, FLBuilt 1965 · S/N 24-4275N881WXBaron Services Inc · Huntsville, ALS/N 32R-7880042N8822PCornwell Charles E · Tucson, AZBuilt 1965 · S/N 24-4278N8822ZSmith Roy · Houston, TXBuilt 1980 · S/N 34-8170018N8823YFerrara John M · Newtown, PABuilt 1969 · S/N 30-1981N8824ECornelius John A · Fort Worth, TXBuilt 1976 · S/N 28R-7635216N8824PAzimi Matthew H · Navarre, FLBuilt 1965 · S/N 24-4280N8826PIngalls Equipment LLC · Redlands, CABuilt 1965 · S/N 24-4282N8828CHogan Dennis E · South Hadley, MABuilt 1976 · S/N 28R-7635183N8829PInternational Air Services Inc Trustee · Carson City, NVBuilt 1965 · S/N 24-4285N882TMLance Air LLC · Madison, WIBuilt 1977 · S/N 32R-7780273N8830PCanon Daniel H · Fruit Cove, FLBuilt 1965 · S/N 24-4286N8832PRoundtree Benjamin · Cass City, MIBuilt 1965 · S/N 24-4288N8833PRegistered aircraftBuilt 1965 · S/N 24-4289N8833YGagan Samrat LLC · Charlotte, NCBuilt 1969 · S/N 30-1991N8835PFeller James P · Granite Bay, CABuilt 1965 · S/N 24-4291N8836YLodge Aviation LLC · Lewes, DEBuilt 1969 · S/N 30-1994N8837YWilfly Inc · Dahlgren, ILBuilt 1969 · S/N 30-1995N8838PLogan Flyers LLC · Logan, OHBuilt 1965 · S/N 24-4293N8838YWaterwings Seaplanes LLC · Hoover, ALBuilt 1969 · S/N 30-1993N8839YMcguinness William V IV · Houston, TXBuilt 1969 · S/N 39-2N883ACPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 28R-7535156N8840PStutzman John M · Grand Rapids, MIBuilt 1965 · S/N 24-4295N8841PBotsacos Chris S DBA · Long Beach, CABuilt 1965 · S/N 24-4296N8842PGauss Roger W · Forest Hill, MDBuilt 1965 · S/N 24-4297N8842SMcdowell Karen · Dunedin, FLS/N 2837032N8842YQuest Aviation Inc · Houlton, MEBuilt 1969 · S/N 30-2000N8843PRodarte Lionel A · Downey, CABuilt 1965 · S/N 24-4298N8844PReetz Roger D · Duluth, MNBuilt 1965 · S/N 24-4299N8844YStreater Aviation LLC · Weirsdale, FLBuilt 1969 · S/N 39-3N8846PLecrone Gregory S · Granbury, TXBuilt 1965 · S/N 24-4301N8847PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1965 · S/N 24-4302N8848PLazar Stephen D · Toledo, OHBuilt 1965 · S/N 24-4303N8848YBrunot Frank A · Spring Hill, FLBuilt 1969 · S/N 30-1907N8849PCare Management Oregon Inc · New Plymouth, IDBuilt 1965 · S/N 24-4304N884DCTanner Greg L · Bend, ORBuilt 1961 · S/N 24-2434N8850PSharp Alan D · Dallas, TXBuilt 1965 · S/N 24-4305N8851PRegistered aircraftBuilt 1965 · S/N 24-4307N8852CWobken Mark E · Orange, CABuilt 1976 · S/N 28R-7635184N8852YWikle Luther M · Laceys Spring, ALBuilt 1969 · S/N 39-7N8853CEuropa Aero LLC · Bucyrus, OHBuilt 1976 · S/N 32R-7680141N8853PGebhart Kevin E · Burley, IDBuilt 1965 · S/N 24-4309N8854YSeeds John S Jr Trustee · Tequesta, FLBuilt 1970 · S/N 39-9N8855PTja Pop Ltd · Dix Hills, NYBuilt 1965 · S/N 24-4311
Back to AD 97-01-01 R1