Skip to content

Registered aircraft · 3,118

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:82-23-01-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:82-23-01-R1') 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:82-23-01-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:82-23-01-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.

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:82-23-01-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:82-23-01-R1')
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.

N8127YDragon Flight Training Academy LLC · Pembroke Pines, FLBuilt 1966 · S/N 30-1239 N8128PScotts Aviation Services LLC · Kalispell, MTBuilt 1962 · S/N 24-3381 N8130PBenedict Morris D · Kenly, NCBuilt 1962 · S/N 24-3383 N8131PCheak Alan S · Peachtree City, GABuilt 1962 · S/N 24-3384 N8132PMiller Lawrence A · Winthrop Harbor, ILBuilt 1963 · S/N 24-3385 N8132YJessen Eric Carl · La Luz, NMBuilt 1966 · S/N 30-1244 N8133PChristy H Spencer · Wetumpka, ALBuilt 1963 · S/N 24-3386 N8133YLeaders Bob O · Clear Lake, MNBuilt 1966 · S/N 30-1245 N8136PCragg Gordon E · Georgetown, TXBuilt 1963 · S/N 24-3389 N8137YSale Reported · Chisago City, MNSale reportedBuilt 1966 · S/N 30-1248 N8138PFrank Castillo Dds Inc · San Jose, CABuilt 1963 · S/N 24-3392 N8139YBuchanan Jason A · Meridian, IDBuilt 1966 · S/N 30-1250 N8143P8143 Leasing LLC · Manassas, VABuilt 1963 · S/N 24-3396 N8143YTennave LLC · Dublin, OHBuilt 1966 · S/N 30-1254 N8145PRegistered aircraftBuilt 1963 · S/N 24-3398 N8147PHinson Jerry W · Nederland, TXBuilt 1963 · S/N 24-3400 N8147YRietz Douglas W · Walla Walla, WABuilt 1966 · S/N 30-1259 N814RCCamelot Express LLC · Naples, FLBuilt 1966 · S/N 301202 N8150YBok Hans · North Dartmouth, MAFirst renewal noticeBuilt 1966 · S/N 30-1263 N81514Soar Above Flight Solutions LLC · Englewood, TNS/N 30-1264 N8151P63 Comanche LLC · Las Vegas, NVBuilt 1963 · S/N 24-3406 N8154YRawson Aviation LLC · Collinsville, OKBuilt 1966 · S/N 30-1267 N8155PSanders Tyler George · Tehachapi, CABuilt 1963 · S/N 24-3410 N8155YTalley John T · Clifton, TXS/N 30-1269 N8156PVectors West LLC · Coeur D Alene, IDBuilt 1963 · S/N 24-3411 N8157YSchmidt Zachary P · Raleigh, NCBuilt 1966 · S/N 30-1270 N8159PRegistration Pending · Tucson, AZRegistration pendingBuilt 1963 · S/N 24-3414 N8160PSouth Texas Weather Modification Association · Pleasanton, TXBuilt 1963 · S/N 24-3415 N8164PHobbs Phillip E · Matthews, NCBuilt 1963 · S/N 24-3419 N8164YBrewer Steven G · Laconia, NHBuilt 1966 · S/N 30-1277 N8165PJohnson Warford B II · Ozark, MOBuilt 1963 · S/N 24-3420 N8167PDiehl Matthew · Elk River, MNBuilt 1963 · S/N 24-3423 N8168PSchrump Donald R · Putnam, CTBuilt 1963 · S/N 24-3424 N8169PLudlow Brent G · Murray, UTBuilt 1963 · S/N 24-3425 N8170PLock Haven Aircraft Sales · Lock Haven, PABuilt 1963 · S/N 24-3426 N8172YKline John C · Wolcottville, INBuilt 1966 · S/N 30-1286 N8173YAltitude Aviation Group LLC · Kissimmee, FLS/N 30-1287 N8174PIglewski Rudolph Daniel II · Apache Junction, AZBuilt 1963 · S/N 24-3430 N8174YStansbury Todd V · Centennial, COS/N 30-1289 N8175PCunningham James L · Tucson, AZBuilt 1963 · S/N 24-3431 N8176PHundley Jeffrey S · Parker, COBuilt 1963 · S/N 24-3432 N817KBaquero Eric P · New Castle, COBuilt 1963 · S/N 24-3445 N8180PGriffin Robert · Middletown, DES/N 24-3436 N8180YG2g Aviation LLC · Wray, COBuilt 1966 · S/N 30-1296 N8181PTascosa Trail Inc · Gruver, TXBuilt 1963 · S/N 24-3437 N8182PFaulkner Ronnie L · Mount Ida, ARBuilt 1963 · S/N 24-3439 N8186YHeiter Aviation Services LLC · Leesburg, INS/N 30-1303 N8187PKlein Dale A · Mandan, NDBuilt 1963 · S/N 24-3443 N8187YWhite Jack S · Boone, NCFirst renewal noticeBuilt 1966 · S/N 30-1304 N8188PPurdy Bryan T · Bryant, ARBuilt 1963 · S/N 24-3444

Back to AD 82-23-01 R1