OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,915

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.

N47915Lewis Mechanical Inc · Wasilla, AKBuilt 1977 · S/N 34-7870014N4792TBrooks Donald D · Baton Rouge, LABuilt 1972 · S/N 28R-7235109N47945Countee Roger Brendan · Los Angeles, CABuilt 1977 · S/N 28R-7837018N4795TCammack Van R Jr · Willow Park, TXBuilt 1972 · S/N 28R-7235110N47961Thomas Brian E · Virginia Beach, VABuilt 1977 · S/N 32R-7880029N47977Cossi Restaurant Corp · Ballston Spa, NYBuilt 1977 · S/N 32R-7880031N47987Mongo Corp · Santa Fe, NMBuilt 1977 · S/N 28R-7803052N47990Williams Charles · Wadsworth, OHBuilt 1977 · S/N 34-7870024N47BBRogers Joseph O III · Fernandina Beach, FLBuilt 1960 · S/N 24-1889N47JEHurley Nicholas John · Trinity, NCBuilt 1977 · S/N 32R-7780532N47KWAirgo Inc · Centralia, ILS/N 34-7970230N47SSandlapper Aviation Of De Inc · Bennington, VTBuilt 1970 · S/N 28R-35769N4802JSwaz Aviation LLC · Mesa, AZBuilt 1968 · S/N 28R-30603N4802TSmith Terry G · Kamuela, HIS/N 28R-7235111N48086Spohrer Wilner And Maxwell P A · Jacksonville, FLS/N 30-1421N4812JJohnson Chris A · Fort Mohave, AZS/N 28R-30605N4816TBulldog Air LLC · Wilmington, DEBuilt 1972 · S/N 28R-7235114N4817TJoly Paul A · Henderson, NVBuilt 1972 · S/N 28R-7235115N4823FEden'S Marine LLC · Jensen Beach, FLBuilt 1976 · S/N 28R-7635437N4827FVictory Lake Marine Inc · Fremont, NES/N 32R-7680479N482DRThurston Steven Curtis · Salisbury, NCBuilt 1977 · S/N 32R-7780391N482KKilo Kilo Enterprises LLC · Commerce Township, MIS/N 347770272N4831TPower Flow Systems Inc · Daytona Beach, FLBuilt 1972 · S/N 28R-7235120N4833TDodson International Parts Inc · Rantoul, KSBuilt 1972 · S/N 34-7250155N4845FMattern Jeffrey A · Brunswick, OHBuilt 1976 · S/N 32R-7680482N4846JMiehle Arthur R · Villa Park, ILBuilt 1968 · S/N 28R-30610N4846TChurchill Scott W · Le Sueur, MNBuilt 1972 · S/N 28R-7235125N4847TKempton Larry G Jr · Grand Junction, COBuilt 1972 · S/N 34-7250158N484QJKaa Corp · Chino, CAS/N 34-7970159N4851FRagland Brady J · Amarillo, TXBuilt 1976 · S/N 32R-7680483N4854JTrio Bravo Ltd · Hudson, OHBuilt 1968 · S/N 28R-30611N4855TVaitai Rei LLC · Spring, TXBuilt 1972 · S/N 34-7250159N4857JWogan Ted E · Russellville, ALBuilt 1968 · S/N 28R-30613N4858JSchapiro Stephen Alexander · Lambertville, NJBuilt 1968 · S/N 28R-30614N4874TSmith Richard R Sr · Wellington, NVS/N 28R-7235128N4876TAyers Terry · Boise, IDBuilt 1972 · S/N 34-7250162N487SCRegistered aircraftBuilt 1959 · S/N 24-1346N4884TRedstone Arsenal Flying Activity · Redstone Arsenal, ALBuilt 1972 · S/N 28R-7235131N4892TTwo Tango Aviation LLC · Plant City, FLBuilt 1972 · S/N 28R-7235132N48ARGacey Inc Trustee · Wilmington, DEBuilt 1966 · S/N 30-1328N48LJSga Alaska Leasing LLC · Anchorage, AKBuilt 1977 · S/N 347770030N48SLLauff Samuel Jr · Ocala, FLBuilt 1975 · S/N 34-7570042N48WRRasquinha Warren · Sanford, FLBuilt 1977 · S/N 28R-7703355N4900JUniversal Technical Institute Inc · Avondale, AZBuilt 1968 · S/N 28R-30617N4904JLunken Air Group LLC · Cincinnati, OHS/N 28R-30622N4905JMoore Albert III · Las Vegas, NVBuilt 1968 · S/N 28R-30623N4906JSeal Air LLC · San Juan Capo, CABuilt 1968 · S/N 28R-30624N4906TSmith Bruce · Leonardtown, MDBuilt 1972 · S/N 28R-7235158N4907JHarmon Neil A · North Chelmsford, MABuilt 1968 · S/N 28R-30625N4907TPhoenix East Aviation LLC · Daytona Beach, FLBuilt 1972 · S/N 34-7250184
Back to AD 97-01-01 R1