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.

N8353YSoutheast Leasing LLC · Delray Beach, FLBuilt 1967 · S/N 30-1500 N8355PSutliff Larrie G · Briarcliff Manor, NYBuilt 1963 · S/N 24-3580 N8356PEarl Tim G · Plymouth, CAS/N 24-3612 N8357PHames David W · Amarillo, TXBuilt 1964 · S/N 24-3613 N8358YGruenbaum Michael S · Eastvale, CABuilt 1967 · S/N 30-1505 N8359YManyak Louis J · Inglis, FLS/N 30-1507 N8364PSheeree Corp · Wilmington, DES/N 24-3622 N8365PHanna James L · Simi Valley, CAS/N 24-3623 N8365YTwin Time LLC · Battle Lake, MNBuilt 1967 · S/N 30-1514 N8366PBurris Robert V · Charlotte, NCBuilt 1964 · S/N 24-3624 N8366YLieberman Bill A · Port Orange, FLBuilt 1967 · S/N 30-1516 N8368PBoyko Michele A · Albuquerque, NMBuilt 1964 · S/N 24-3626 N8368YMeadows Michael M · Cypress, TXBuilt 1967 · S/N 30-1518 N8369PLeenhouts John R · Mulberry, FLBuilt 1964 · S/N 24-3627 N8370PDonovan Patrick D · Troy, MOBuilt 1964 · S/N 24-3628 N8371YAstro Star Aviation Inc · Niles, MIBuilt 1967 · S/N 30-1522 N8373PZeller Ryan P · Reno, NVBuilt 1964 · S/N 24-3631 N8375PGores Thomas J · Franklin, WIBuilt 1964 · S/N 24-3633 N8375YSimmons John William · Ocala, FLBuilt 1967 · S/N 30-1529 N8376YScharfenberg Charles · Maquon, ILBuilt 1967 · S/N 30-1530 N8377PGullett Samuel H · Lafayette, LABuilt 1964 · S/N 24-3636 N8378PBel-Aire Home Restoration LLC · Platteville, WIBuilt 1964 · S/N 24-3637 N8378YEmerald Aircraft LLC · Greenwood, SCBuilt 1967 · S/N 30-1533 N8379YSpaeth Alexander H · Aurora, ILBuilt 1967 · S/N 30-1534 N837PGG & G Comanche LLC · Magnolia Springs, ALBuilt 1965 · S/N 30-914 N8381PIndy Air Sales LLC · Anderson, INS/N 24-3640 N8381YLehrer James Rodd · Thief River Falls, MNBuilt 1967 · S/N 30-1536 N8382PKutilek Emil J · Charlottesville, VABuilt 1964 · S/N 24-3641 N8383PWhatley Mark · Orion, MIBuilt 1964 · S/N 24-3642 N8383YHolland Carl J · Dillsboro, INBuilt 1967 · S/N 30-1538 N8384PMauch Archie C · Magnolia, TXBuilt 1964 · S/N 24-3643 N8385YNesbitt Loyd B Jr · Independence, ORBuilt 1967 · S/N 30-1540 N8387YN8387y LLC · Huntsville, ALBuilt 1967 · S/N 30-1542 N8389PPower Joe D · Seguin, TXS/N 24-3648 N8390PNordwick Thomas J · Uvalde, TXS/N 24-3649 N8391PClare Enterprises LLC · Edina, MNBuilt 1964 · S/N 24-3650 N8392PVaughn Charles P · Inverness, FLBuilt 1964 · S/N 24-3652 N8392YTwinco Flyers LLC · Powell, OHBuilt 1967 · S/N 30-1547 N8393PMorrison Brian W · Zanesville, OHBuilt 1964 · S/N 24-3653 N8394PHilton Keith A · Galesville, WIBuilt 1964 · S/N 24-3654 N8396YPerkins Christopher R · Brackettville, TXBuilt 1967 · S/N 30-1492 N8398PBaca Andre · Albuquerque, NMBuilt 1964 · S/N 24-3657 N8399YHirschler Andre N · Goshen, INBuilt 1966 · S/N 30-1137 N83BWJohnson Nathan D · Pacheco, CABuilt 1965 · S/N 30-888 N8403PNewell Douglas Bryon · Sedalia, MOBuilt 1964 · S/N 24-3659 N8403YBlair Robert A · Red Bluff, CABuilt 1967 · S/N 301552 N8404PRegistration Pending · Pittsburgh, PARegistration pending, pending cancellationBuilt 1964 · S/N 24-3660 N8405PCarlin Chad P · San Juan Capistron, CAS/N 24-3661 N8405YBjorkman Marvin S · Richardson, TXBuilt 1967 · S/N 30-1554 N8406YPilgrim Robert C · Cape Coral, FLBuilt 1967 · S/N 30-1556

Back to AD 82-23-01 R1