AD 98-21-21 R1

Registered aircraft · 85,620

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:98-21-21-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:98-21-21-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.

N231KYMorris Kevin William · Camden, SCBuilt 1980 · S/N 25-0293N231LFranckowiak Bernard A · Nokomis, FLBuilt 1979 · S/N 25-0055N231LATrexler Gary A · Abingdon, VABuilt 1978 · S/N 25-0014N231LCFirst United Inc · Seminole, FLBuilt 1975 · S/N TH-696N231LEIntegrated Realty Group Inc · Laguna Hills, CABuilt 1979 · S/N 25-0205N231LFLong James Robert Leslie · Reno, NVBuilt 1979 · S/N 25-0218N231LGTerpening Brian E · Roanoke Rapids, NCBuilt 1980 · S/N 25-0296N231LMAsianov Alexander · Saint Johns, FLBuilt 1979 · S/N 25-0232N231LPTaylor Leslie G Trustee · Cody, WYBuilt 1980 · S/N 25-0300N231LRMowbray-Parker Nicoya Jade · Flower Mound, TXBuilt 1978 · S/N 25-0025N231LTWhitfield Michael Lee · Leander, TXBuilt 1979 · S/N 25-0056N231LULewis Matthew G · Wilmington, MABuilt 1980 · S/N 25-0302N231LVFalcon Global LLC · Sedona, AZBuilt 1980 · S/N 25-0303N231LWNewberg Edgar T · Hector, MNBuilt 1979 · S/N 25-0147N231LXGlueck Robert Gary · Astor, FLBuilt 1980 · S/N 25-0304N231MMitchell Philip A · Rhome, TXBuilt 1978 · S/N 25-0011N231MAGolden Age N231ma LLC · Norwalk, IABuilt 2022 · S/N 2881564N231MEBass Daniel · Winona, MNBuilt 1979 · S/N 25-0166N231MFCoker Steve L · Tyler, TXBuilt 1979 · S/N 25-0077N231MGRichard F Marshall Inc · Fort Jones, CABuilt 1978 · S/N 25-0023N231MHPacific Commonwealth Mortgage Co · Incline Village, NVBuilt 1980 · S/N 25-0307N231MJOchabauer August · Burlingame, CABuilt 1979 · S/N 25-0308N231MKEastman Gregory L · Pueblo, COBuilt 1980 · S/N 25-0309N231MLL8n Aero LLC · New Harmony, UTBuilt 1980 · S/N 25-0310N231MMPitts Arnold · Elizabethtown, NCS/N 25-0038N231MNMacair LLC · Santa Barbara, CAS/N 25-0717N231MPCraig Steven A · Olympia, WAS/N 25-0049N231MSKimmerly Andrew · Chandler, AZBuilt 1980 · S/N 25-0313N231MTBell Kenneth M · Cedar Park, TXBuilt 1979 · S/N 25-0189N231MUStorey Otto John · Lake Oswego, ORBuilt 1980 · S/N 25-0314N231MVSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N 250457N231MYCastle Compu Systems LLC · New Castle, PABuilt 1979 · S/N 25-0152N231NABrien Lucas M · Norwich, VTBuilt 1980 · S/N 25-0318N231NCCross Joshua A · San Antonio, TXBuilt 1980 · S/N 25-0447N231NDPowers Jimmy Lee · San Antonio, TXBuilt 1979 · S/N 25-0207N231NET & M Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 25-0320N231NFAratreus Holdings LLC · South Charleston, WVS/N 25-0321N231NHBooska Steven A · Angwin, CABuilt 1980 · S/N 25-0323N231NJQuinton Aaron S · Columbus, INBuilt 1980 · S/N 25-0324N231NLBurkhart Scott C · Livermore, CABuilt 1980 · S/N 25-0325N231NNKelly Luciano LLC · Independence, OHBuilt 1980 · S/N 25-0326N231NPStiritz Thomas A · Spokane Valley, WAS/N 25-0111N231NSLawrence Steven R · Chowchilla, CABuilt 1980 · S/N 25-0329N231NUMcmillan Keith A · Milwaukee, WIBuilt 1980 · S/N 25-0331N231NZSchumacher Kim L · Beach City, OHBuilt 1980 · S/N 25-0336N231PWilverding Jerome C · Stockton, CABuilt 1979 · S/N 25-0066N231PBSnapp Steven J · Los Alamos, NMBuilt 1979 · S/N 25-0163N231PDDuncan William Thomas Jr · Virginia Beach, VAS/N 25-0337N231PEHiawatha Valley Aviation Inc · Hawley, MNBuilt 1980 · S/N 25-0338N231PFStephans Emery J · Waitsfield, VTBuilt 1979 · S/N 25-0102
Back to AD 98-21-21 R1