Skip to content

Registered aircraft · 6,916

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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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:97-01-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.

N8339YBas Part Sales LLC · Greeley, COBuilt 1967 · S/N 30-1485 N833DFAirdorrin Inc · New Castle, DEBuilt 1967 · S/N 30-1473 N8340PChristiansen Lance W · Anacortes, WAS/N 24-3595 N8341PLife Is Flying Inc · Deerfield Beach, FLBuilt 1963 · S/N 24-3596 N8341YPepper Dale D · Newnan, GABuilt 1967 · S/N 30-1487 N8342CBennett Donald B · Birmingham, ALBuilt 1976 · S/N 28R-7635149 N8342PGibbs Randy Shane · Louisburg, NCBuilt 1964 · S/N 24-3597 N8343YSpector Steven D · Glenview, ILBuilt 1967 · S/N 30-1489 N8344PGulledge Richard · Deland, FLS/N 24-3600 N8345PMcgough Christopher M Trustee · Hurricane, UTBuilt 1964 · S/N 24-3601 N8346PPhelps Michael J Trustee · Oneida, TNBuilt 1964 · S/N 24-3603 N8348PEchols Mark R · Diana, TXBuilt 1964 · S/N 24-3605 N8348YNelson Brian · Wakefield, NEBuilt 1967 · S/N 30-1495 N8349PPickett Douglas M · Romeo, MIBuilt 1964 · S/N 24-3606 N8351CSilver Express Co DBA · Miami, FLNon-citizen corporation, flight hours not reportedBuilt 1975 · S/N 34-7670077 N8351PComanche Air Holdings LLC · Austin, TXBuilt 1964 · S/N 24-3608 N8352YSkylandsair LLC · Port Orange, FLBuilt 1967 · S/N 30-1499 N8353COstwinkle Jeffrey J · Justin, TXBuilt 1976 · S/N 28R-7635152 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 N8368COchoa Luis M · Hollywood, FLBuilt 1976 · S/N 32R-7680102 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 N8375CHammett Jeb Stuart · Monroe, LABuilt 1976 · S/N 32R-7680103 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 N8382CSwickert Donald L II · Merritt Island, FLBuilt 1976 · S/N 28R-7635154 N8382PKutilek Emil J · Charlottesville, VABuilt 1964 · S/N 24-3641 N8383PWhatley Mark · Orion, MIBuilt 1964 · S/N 24-3642

Back to AD 97-01-01 R1