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.

N275RBlue Card Aviation LLC · Conifer, COS/N TC-1885N275RCGianopoulous William · Lawrence, MAFirst renewal noticeBuilt 1979 · S/N 402C0117N275RMRodgers Kenneth · Appleton, WIBuilt 1974 · S/N 340-0511N275RSMonaco Aviation LLC · Duluth, MNBuilt 2003 · S/N 1280N275TCirrusly Flying LLC · Missoula, MTBuilt 2020 · S/N 2083N275TCQualitair LLC Trustee · MichelstadtBuilt 1994 · S/N E2914N275VFly Collier LLC · Naples, FLBuilt 1973 · S/N TH-376N275ZZWardell Robert · Montrose AuNon-citizen corporation, flight hours not reportedBuilt 1976 · S/N 18503238N2761GMartinell Justin E · Dell, MTBuilt 1959 · S/N 52061N2761TSmith Corey J · Liberty Township, OHBuilt 1967 · S/N D-8492N2762ADorman Richard E · Mesa, WABuilt 1957 · S/N 32849N2762FFreflite LLC · Wilmington, DEBuilt 1966 · S/N 18256862N2763Valiair Lc Trustee · Casper, WYBuilt 2007 · S/N 2859N27634Middaugh Terry E · Chattaroy, WABuilt 1952 · S/N G-15N2763FSeawings LLC · Holualoa, HIBuilt 1965 · S/N 18256863N2763TOrmsby Stephen J · Somerville, OHBuilt 1967 · S/N D-8469N2763XThompson Lyndon R · West Fargo, NDBuilt 1965 · S/N 18051563N2764JMcgregor Daniel A · Denali Park, AKBuilt 1969 · S/N 185-1514N2764QLong Donald G Jr · Gaston, ORBuilt 1967 · S/N 18257964N2765FStoup Lyndal K · Cordell, OKBuilt 1965 · S/N 18256865N2765XBa Aviation LLC · Anacortes, WAS/N 18051565N2766FBrach Raymond S · Henderson, NVBuilt 1966 · S/N 18256866N2766QThree Airmigos LLC · New Port Richey, FLBuilt 1967 · S/N 18257966N2767GBrowns Valley Aviation LLC · Utica, KYS/N 52067N2767TCarr Jeffrey L · Hot Springs, ARBuilt 1967 · S/N D-8476N2768GCarrion John H · Colusa, CABuilt 1959 · S/N 52068N2768JRussell Mark Alex · Fairbanks, AKBuilt 1969 · S/N 185-1518N2768TNorth Wind Aviation LLC · Chelan, WABuilt 1967 · S/N CD-1107N2768XMullett James L · Mccall, IDBuilt 1965 · S/N 18051568N2769FMatthews George W · Hillsboro, OHBuilt 1965 · S/N 18256869N2769GFraser Kevin J · Snohomish, WABuilt 1959 · S/N 52069N2769QPrecision Truck Equipment Inc · Lansing, ILBuilt 1967 · S/N 18257969N2769TRakhmatulin Evgeny A · Carlsbad, CABuilt 1967 · S/N D-8477N276AKSalo Mark W · Poulsbo, WABuilt 1958 · S/N 50284N276BXSmith William P · Chandler, OKBuilt 1966 · S/N D-8257N276CDGandia Justin Kidd · Chicago, ILBuilt 2005 · S/N 1385N276CMTwo Fly Guys LLC · Orlando, FLBuilt 2006 · S/N 29-0445N276CPRothlisberger Ben · Farmington, MOBuilt 2008 · S/N 3243N276DBN276db LLC · Mesa, AZBuilt 1976 · S/N 34-7670238N276GEMaricorp U S LLC · Shell Knob, MOBuilt 2014 · S/N 4150N276GSSampson Gabriel · Huntsville, UTBuilt 2017 · S/N 1603N276KCLitchfield Derek A · Macomb, ILBuilt 2006 · S/N 1602N276LFMaloney Leasing LLC · Tupelo, MSBuilt 2015 · S/N T24002078N276LHPinnacle Medical Solutions LLC · New York, NYS/N T24002099N276NYFogarty Richard · Mandeville, LAS/N R1722393N2770FEmmons Jack E · Elizabeth City, NCBuilt 1965 · S/N 18256870N2770THanson Leasing Inc · Bad Axe, MIBuilt 1967 · S/N CD-1104N2771GWhitt Sana F III · East Quogue, NYS/N 52071N2771TKleine James S · New Buffalo, MIS/N D-8487N2772JMagoffin David S · Fairbanks, AKBuilt 1969 · S/N 185-1522
Back to AD 2000-23-21