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.

N57DJPasserby Randal K · Mesa, AZS/N 30-1292N57DVDefebo Edward · East Stroudsburg, PABuilt 1968 · S/N 28R-30732N57GBStonehocker Scott · Layton, UTBuilt 1967 · S/N 28R-30240N57JJRegistration Pending · Kewaskum, WIRegistration pendingBuilt 1977 · S/N 32R-7780165N57RROdette David N · Thief River Falls, MNBuilt 1968 · S/N 28R-30467N5800PCencula Christopher D · Roseville, CABuilt 1959 · S/N 24-880N5802PHass Morgan E · Lyons, ORBuilt 1959 · S/N 24-882N5804PWitt Aviation LLC · Naperville, ILBuilt 1959 · S/N 24-884N5805PGrace Family Fellowship Inc · Oklahoma City, OKBuilt 1959 · S/N 24-885N5807PRichter Dickinson Aviation LLC · Moultrie, GABuilt 1959 · S/N 24-887N5811PJpl Flyers LLC · Metairie, LABuilt 1959 · S/N 24-891N5822PJstream Lc · Sheridan, WYBuilt 1959 · S/N 24-903N5824FFastaire LLC · Mobile, ALBuilt 1976 · S/N 32R-7780020N5824PClaxton Fred E · La Habra, CABuilt 1959 · S/N 24-905N5825PRobles Carlos J · San Jose, CABuilt 1959 · S/N 24-906N5827PTwo Seven Papa LLC · Pueblo, COBuilt 1959 · S/N 24-908N582VWingcap LLC · Ferguson, MOS/N 28R-7703332N5833PCochran Keith W · Long Beach, CAS/N 24-914N5835PLoya Francisco · Crestline, CAS/N 24-916N5836PShort Final LLC · Murfreesboro, TNBuilt 1959 · S/N 24-917N5837PGoodman Wayne A · Conway, SCBuilt 1959 · S/N 24-918N5838PHoughtling Marvin · Pasadena, TXBuilt 1959 · S/N 24-919N5842PFlyair Flight Academy LLC · Flint, TXBuilt 1959 · S/N 24-923N5844PKoniar Steven L · Newcastle, OKS/N 24-925N5845PGriffel Brandon T · Frederick, MDBuilt 1959 · S/N 24-926N5848VSheffield David A · Silsbee, TXBuilt 1977 · S/N 32R-7780368N5849PJinnis Flight Enterprises LLC · Montgomery, TXBuilt 1959 · S/N 24-930N584SShobe Andrew S A · Clarksville, MDBuilt 1977 · S/N 28R7737112N5850PInto The Forest Equipment LLC · Placerville, CABuilt 1959 · S/N 24-932N5853PLewellen Walter G · Moreno Valley, CABuilt 1959 · S/N 24-935N5854FBravo Sierra LLC · Middletown, DES/N 32R-7780021N5856PDemontalvo Aaron M · Mansfield, TXBuilt 1959 · S/N 24-938N5859PSnider Scott E · Turner, MTBuilt 1959 · S/N 24-941N5860VAlasc Holdings LLC · Albuquerque, NMBuilt 1977 · S/N 28R-7737072N5863PB E L Flight LLC · Punta Gorda, FLFirst renewal noticeS/N 24-946N5865PLl Aviation LLC · Saint Joseph, MOBuilt 1959 · S/N 24-948N5866PBas Part Sales LLC · Greeley, COBuilt 1959 · S/N 24-949N5867PWickenheiser Kevin John · Detroit, MIBuilt 1959 · S/N 24-950N5868VSiefken Arnold G · Jamestown, NDBuilt 1977 · S/N 32R-7780369N5870PPaul Eric C · Grapevine, TXBuilt 1959 · S/N 24-953N5870VHagerstown Regional Aero Club · Dallastown, PABuilt 1977 · S/N 32R-7780370N5871PHammons John A · Maurice, LABuilt 1959 · S/N 24-954N5880VStevens Thomas G · Missoula, MTS/N 28R-7703158N5881VNomotsa LLC · Buena Vista, COS/N 28R-7703160N5882PEvans Gene · Henderson, TXBuilt 1959 · S/N 24-967N5885PCostanzo Christopher P · Staten Island, NYBuilt 1959 · S/N 24-970N5888PRegistered aircraftS/N 24-973N588CPTjomsland Bryan · Culver City, CABuilt 1958 · S/N 24-431N5890PDaniels David R · Anthony, NMBuilt 1959 · S/N 24-975N5892VShadbolt George · Merriman, NEBuilt 1977 · S/N 28R-7703162
Back to AD 97-01-01 R1