OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,138

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

N231KXQualitair LLC Trustee · MichelstadtBuilt 1980 · S/N 25-0292N231KYMorris 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-696N231LFLong James Robert Leslie · Reno, NVBuilt 1979 · S/N 25-0218N231LGTerpening Brian E · Roanoke Rapids, NCBuilt 1980 · S/N 25-0296N231LLTen-Xray LLC · Woodside, NYBuilt 2002 · S/N 0199N231LMAsianov 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-0147N231MMitchell Philip A · Rhome, TXBuilt 1978 · S/N 25-0011N231MCBrad Barnett Insurance Agency Inc · Springdale, ARBuilt 2008 · S/N E-3858N231MEBass 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-0307N231MKEastman Gregory L · Pueblo, COBuilt 1980 · S/N 25-0309N231MLL8n Aero LLC · New Harmony, UTBuilt 1980 · S/N 25-0310N231MNMacair 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-0066N231PDDuncan 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-0102N231PGHartford Aircraft LLC · Monument, COBuilt 1979 · S/N 25-0242N231PLBryan Shawn D · Kempner, TXBuilt 1979 · S/N 25-0110N231PNTaylor Richard · Pacific Palisades, CABuilt 1980 · S/N 25-0341
Back to AD 2000-23-21