OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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:80-25-02-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-25-02-R2')
  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.

N89377Bishops' Ltd · Virginia Beach, VABuilt 1978 · S/N 15282732N89390Nevill Jordan J · Ukiah, CABuilt 1978 · S/N 15282734N89392Story John D · Harrah, OKBuilt 1946 · S/N 8424N89430Flabob Airport LLC · Jurupa Valley, CAS/N 15282741N89433Chapel Hill Flying Club Inc · Sanford, NCBuilt 1978 · S/N 15282743N89438Sun Aircraft Management LLC · Ormond Beach, FLBuilt 1978 · S/N 15282747N89456Czyzewski Justin · East Brunswick, NJBuilt 1978 · S/N 15282755N89469Hershberger David A · Unionville, INBuilt 1978 · S/N 15282759N8951LWoolslayer John P · Tulsa, OKBuilt 1974 · S/N AA1B-0401N89531Glynco Manning Aviation Inc · Brunswick, GABuilt 1978 · S/N 15282771N89533Ashby Shawn Alan · San Luis Obispo, CABuilt 1978 · S/N 15282773N89539Jkg LLC · Murfreesboro, TNBuilt 1978 · S/N 15282775N89549Jodkin Jason J · Confluence, PAFirst renewal noticeBuilt 1978 · S/N 15282781N89585Vinland Flight School LLC · Topeka, KSBuilt 1978 · S/N 15282796N89588Jet & Rotor Aviation LLC · Sacramento, CABuilt 1978 · S/N 15282797N8958LBarron John C · Tulsa, OKBuilt 1974 · S/N AA1B-0408N89600Philbrick Rodney C DBA · Bishop, CABuilt 1978 · S/N 15282801N8961LStanton Kathleen Z · Burneyville, OKS/N AA1B0661N896482fly-Safety LLC Trustee · Azle, TXBuilt 1977 · S/N 15282816N89652Lexington Flying Club Inc · Lexington, KYBuilt 1978 · S/N 15282819N89653Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282820N89661Kelly William W · Springfield, ORBuilt 1978 · S/N 15282821N89664Mulligan James Michael Trustee · Mesa, AZBuilt 1978 · S/N 15282822N8966LMoffatt Thomas O · Kennesaw, GABuilt 1974 · S/N AA1B-0416N8967LGoertz Anton O · Santa Fe, NMS/N AA1B-0417N89681Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282824N8968LAg Aircraft Holdings LLC · Port Saint Lucie, FLBuilt 1974 · S/N AA1B-0418N89693Rjw Aviation LLC · Tampa, FLBuilt 1978 · S/N 15282827N89702Carter Flygare Inc · Sacramento, CABuilt 1978 · S/N 15282830N89718Schad Paul E · Gainesville, TXBuilt 1978 · S/N 15282839N89735N89735 LLC · Stuart, FLBuilt 1978 · S/N 15282847N89743Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15282850N89753Aerohead Planes LLC · Savannah, GAS/N 15282853N89764South Aero LLC · Albuquerque, NMS/N 15282857N89770Seals Richard W · Torrance, CAS/N 15282860N8977LSarigul Klijn Nesnn · Dixon, CABuilt 1974 · S/N AA1B-0427N89780Huffman Jacob M III · Burleson, TXBuilt 1978 · S/N 15282865N89800Ballesteros Irlena · Glendale, CAS/N 15282872N89812Fremont Aviation Inc · Fremont, NEBuilt 1978 · S/N 15282879N89815Pinnacle Aviation Services Inc · Encinitas, CABuilt 1978 · S/N 15282881N8983LSale Reported · Austin, TXSale reportedBuilt 1974 · S/N AA1B-0433N89859Hess Garrett J · Fullerton, CABuilt 1978 · S/N 15282894N89863Ruess Richard M · Anchorage, AKBuilt 1978 · S/N 15282896N89869Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282897N8986LHenrichs Jason · Pearland, TXBuilt 1974 · S/N AA1B-0436N89877Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282900N8987LScholten John E · Marne, MIBuilt 1974 · S/N AA1B-0437N89881Fulton Gene · Spartanburg, SCBuilt 1978 · S/N 15282903N89887Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15282904N8991LSky Clock LLC · Mesa, AZBuilt 1974 · S/N AA1B-0441
Back to AD 80-25-02 R2