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.

N9573CBarber Scott H · Redwood Falls, MNBuilt 1978 · S/N 34-7870198N9585KPuetthoff Jan H · Mount Sterling, KYBuilt 1976 · S/N 32R-7680230N9594CPassino Nicholas J · Latham, NYBuilt 1978 · S/N 28R-7837209N959PEParis Air Inc · Vero Beach, FLBuilt 1974 · S/N 34-7450084N95EPFlying Cow LLC · Falls City, NEBuilt 1975 · S/N 32R-7680075N95FSN95fs Ltd · Chicago, ILBuilt 1969 · S/N 30-1786N95HFEddings Samuel David · Camino, CABuilt 1973 · S/N 28R7335311N95PGAviation Sensation LLC · Clearwater, FLBuilt 1974 · S/N 28R-7535026N9603CJtp Aviation LLC · Little Canada, MNBuilt 1978 · S/N 34-7870201N9608KPiper Arrow N9608k LLC · Ann Arbor, MIBuilt 1976 · S/N 28R-7635250N9613CSmall James F Jr · Great Mills, MDBuilt 1978 · S/N 28R-7803269N961DJSeibly Larry · Mckinney, TXBuilt 1960 · S/N 24-1955N961PEParis Air Inc · Vero Beach, FLS/N 34-7250197N9621KHinson Bradford L · Thomasville, GABuilt 1976 · S/N 32R-7680232N962MSMt San Antonio College · Walnut, CABuilt 1976 · S/N 28R-7635459N962WWMindlin Frank August · New Haven, CTBuilt 2000 · S/N 2844022N9634K137 Lynwood LLC · Elmira Heights, NYS/N 28R-7635251N9636KVanderwerf Stan L · Colorado Springs, COBuilt 1976 · S/N 32R-7680234N9637KClik Services LLC · Forestdale, MABuilt 1976 · S/N 32R-7680235N963JKeith William F · Bakersfield, CABuilt 1962 · S/N 24-3195N963WWCash Management Consulting LLC · Granite Springs, NYBuilt 2000 · S/N 2844023N9644KLuck Aviation LLC · Glen Allen, VABuilt 1976 · S/N 28R-7635252N9646KHumphreys Garfield · Port Saint Lucie, FLBuilt 1976 · S/N 32R-7680236N9652KPfeiff Koren T · Chandler, AZS/N 32R-7680238N9659KBell Michael J · Duck Key, FLBuilt 1976 · S/N 28R-7635254N9669KMelton Joseph C · Parker, AZS/N 32R-7680240N9676TWindy Road LLC · Vancouver, WABuilt 1977 · S/N 28R-7703065N9678CUfnn Aviation LLC · Lake Charles, LAS/N 34-7870208N967EYJoy Ventures LLC · Helena, MTBuilt 1967 · S/N 30-1577N9686KGaasedelen Trading Co · Edina, MNBuilt 1976 · S/N 28R-7635255N9687KMorris Zane F · Draper, UTBuilt 1976 · S/N 32R-7680242N9690CWindsock Inc · Red Wing, MNBuilt 1978 · S/N 28R-7837216N969LAJackson Aviation Of South Georgia LLC · Thomasville, GABuilt 1967 · S/N 28R-30138N969WAMiloud Chadd K · Fort Worth, TXBuilt 1980 · S/N 348070112N96GCSky West Aviation Inc Trustee · Albuquerque, NMS/N 28R-7703190N96JNPetz Leroy E Jr · Montverde, FLBuilt 1985 · S/N 39-91N96PGWood David L · Lubbock, TXBuilt 1977 · S/N 34-7770277N9701KEmory Christopher W · Lexington Park, MDBuilt 1976 · S/N 28R-7635257N971RJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1971 · S/N 39-111N9721CFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28R-7837218N9722BBosshard Steven A · Midlothian, VABuilt 1966 · S/N 30-1156N9722CRobbins Joseph R · Madison, ALBuilt 1978 · S/N 28R-7837219N9724CGlobal Capital Partners LLC · Tualatin, ORBuilt 1978 · S/N 28R-7803276N972LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844172N972MWKo Hee Sun · Norwood, NJBuilt 1999 · S/N 2844019N972QJInvictus Health LLC · Yorktown, VAFirst renewal noticeBuilt 1978 · S/N 28R7803366N9731KAnywhere Atp LLC · Mt Juliet, TNBuilt 1977 · S/N 34-7870036N973LTUniversity Of La System DBA · Ruston, LABuilt 2017 · S/N 2844173N9764KSchoff Wardell R · Hamilton, MOBuilt 1977 · S/N 28R-7837038N9768KArrow Aviation LLC · Topeka, KSBuilt 1977 · S/N 28R-7803067
Back to AD 97-01-01 R1