Registered aircraft · 47,133

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N4733N4733n LLC · Elberon, NJBuilt 1979 · S/N 18267322 N4733UEicher Marlin Dale · Sterling, AKBuilt 1964 · S/N 18051433 N4733VEdwards James W · Del Norte, COBuilt 1967 · S/N 30066 N47347Alaska Yukon Aviation Ministries Inc · Anchorage, AKBuilt 1977 · S/N 34-7770387 N4734EEnergy Transfer Aviation LLC · Spring, TXBuilt 1982 · S/N 18268263 N4734MMiller Carl J · San Dimas, CABuilt 1978 · S/N E-1257 N4734NWood Daniel Matthew · Yelm, WABuilt 1979 · S/N 18267323 N47359Mcilquham Roderick L · Bolingbrook, ILBuilt 1977 · S/N 28R-7703361 N4735NAnderson Wood Products LLC · Ellington, MOS/N 18267324 N4735PMarchman & Assosiates Inc · Krum, TXS/N P21000092 N4735VCheney David R · Sun Lakes, AZBuilt 1953 · S/N 30599 N47361Magpie Inc · Rock Springs, WYBuilt 1977 · S/N 28R-7703363 N47366Turbo Aviation LLC · Marblehead, MABuilt 1977 · S/N 34-7770389 N4736NHalter Irving L Jr · Philadelphia, PABuilt 1980 · S/N 18267315 N4736VRegistered aircraftBuilt 1967 · S/N 30067 N4737FJelm Gordon E · Aguila, AZBuilt 1978 · S/N 18503552 N4737UMoody Properties LLC · Olympia, WABuilt 1964 · S/N 18051437 N4738BEarhart Robert E · Dallas, TXBuilt 1955 · S/N 31636 N4738MRetter Christpher · Lynn, INBuilt 1978 · S/N E-1258 N4738QNeal Tyler W · Dufur, ORBuilt 1967 · S/N 185-1192 N4738USw Aviation Services Inc · Queen Creek, AZBuilt 1964 · S/N 18051438 N4739FEberwine David B · Lucas, TXBuilt 1966 · S/N P206-0339 N4739TJohn Ross St · Anchorage, AKS/N 1003 N473BCWaite Aviation LLC · Xenia, OHS/N 1658 N473BJValiair Lc Trustee · Casper, WYBuilt 2010 · S/N 3700 N473CDGrupinski Stephen · Wimberley, TXBuilt 2005 · S/N 1564 N473DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1798 N473DVStratocirrus Aviation LLC · Seattle, WABuilt 2010 · S/N 2073 N473GFHonolulu Soaring Club Inc · Waialua, HIBuilt 1967 · S/N 2018 N473MBProestakis Mijali N · Cypress, TXBuilt 2023 · S/N 9295 N473PRomeo Mike Properties LLC · Naples, FLBuilt 2021 · S/N 2244 N473SLuginbuhl Wayne E · Ormond Beach, FLBuilt 1966 · S/N 310K0131 N473TEngelsma Timothy · Grand Rapids, MIBuilt 1961 · S/N CD-299 N47404Mil2atp Inc · Pikeville, NCBuilt 1977 · S/N 34-7770392 N4740BCallahan Brian L Trustee · Kuna, IDBuilt 1955 · S/N 31638 N4740EVehorn Richard B · Carrollton, TXBuilt 1982 · S/N 18268264 N4740FSkydive Ricks LLC · Petersburg, OHBuilt 1966 · S/N P206-0340 N4740NGtz No 1 LLC · Kalispell, MTBuilt 1979 · S/N 18267329 N4740QFitzpatrick D L III · Whitefish, MTBuilt 1966 · S/N 185-1194 N4740TGerdes Douglas R · Macon, GAS/N 1004 N47416Jarriel Investments Inc · Register, GABuilt 1977 · S/N 28R-7703373 N47418Billings Chris · Duncan, OKBuilt 1977 · S/N 28R-7703374 N47419Capp Kevin C · Boswell, PABuilt 1977 · S/N 28R-7703375 N4741KCrosswind Solutions Inc · Medford, ORBuilt 1979 · S/N P21000272 N4741NCimmaron Flying Inc · Colorado Springs, COBuilt 1979 · S/N 18267330 N4741XRessel Erik P · Lakewood, COBuilt 1980 · S/N U20605529 N47424Phoenix Aviation LLC · Alexandria, VAS/N 34-7770394 N47428Nei Jeffrey G · Bemidji, MNBuilt 1966 · S/N 185-1196 N4742NRegistration Pending · Wilmington, DERegistration pendingBuilt 1979 · S/N 18267331 N4742UProtocol Enterprises LLC · Holdrege, NEBuilt 1983 · S/N 21064810

Back to AD 2000-23-21