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.

N8383YHolland Carl J · Dillsboro, INBuilt 1967 · S/N 30-1538 N8384CMountain Flying Adventures LLC · Missoula, MTBuilt 1976 · S/N 32R-7680105 N8384PMauch Archie C · Magnolia, TXBuilt 1964 · S/N 24-3643 N8385CPaul David M · Peoria, AZBuilt 1976 · S/N 34-7670134 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 N8397CParker Edward M Jr DBA · Griffin, GABuilt 1976 · S/N 28R-7635156 N8398PBaca Andre · Albuquerque, NMBuilt 1964 · S/N 24-3657 N8399YHirschler Andre N · Goshen, INBuilt 1966 · S/N 30-1137 N839JCGng LLC · New Market, ALBuilt 1973 · S/N 28R-7335193 N839RDRoyal D Farms LLC · Baytown, TXBuilt 1975 · S/N 34-7570081 N83BWJohnson Nathan D · Pacheco, CABuilt 1965 · S/N 30-888 N83RMPemc Air LLC · Evansville, INBuilt 1977 · S/N 34-7770265 N83VKSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 32R-7780226 N8400PPiper Aviation Museum Foundation Inc · Lock Haven, PABuilt 1963 · S/N 26-3 N8401PPrecision Design Inc · Weatherford, OKBuilt 1963 · S/N 26-4 N8403PNewell Douglas Bryon · Sedalia, MOBuilt 1964 · S/N 24-3659 N8403YBlair Robert A · Red Bluff, CABuilt 1967 · S/N 301552 N8404CLudwick Paul W · Lighthouse Point, FLBuilt 1976 · S/N 28R-7635157 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 N8407FPan Bar Aviation Inc · Pittsburgh, PABuilt 1976 · S/N 34-7770082 N8407YAwad Aviation LLC · Pooler, GABuilt 1967 · S/N 30-1557 N8408PBeavers Jeffrey · Metairie, LABuilt 1964 · S/N 24-3664 N8409PStevenson Gregory J · Sutter Creek, CABuilt 1964 · S/N 24-3665 N840CWCentral Washington University · Ellensburg, WABuilt 2018 · S/N 2844182 N8413CBrown Lawrence L · Millington, TNBuilt 1976 · S/N 28R-7635159 N8414CInternational Flying Club Inc · Winfield, ILBuilt 1976 · S/N 28R-7635160 N8414PRudd Wayne · Basalt, COBuilt 1965 · S/N 26-8 N8416YHenze Charles R · Waukee, IABuilt 1967 · S/N 30-1567 N8417P250 Dash 4 Associates Ltd · Yellow Springs, OHBuilt 1964 · S/N 24-3669 N8418YHefner Joseph C · Mount Pleasant, TXS/N 30-1570 N8419YMorrone Richard W · Westerly, RIS/N 30-1572 N841PSLivin The Dream Aviation LLC · Jupiter, FLBuilt 1967 · S/N 24-4684 N8421PWills Terry W · Cedar Park, TXBuilt 1964 · S/N 26-12 N8421YKesser Gilbert M · Culpeper, VABuilt 1967 · S/N 30-1575 N8422MDymond Mark S · Monterey, TNBuilt 1975 · S/N 28R-7535225 N8422PAnderson William · Creve Coeur, ILBuilt 1964 · S/N 24-3672 N8426CHarper-Smith Michael · Tarzana, CABuilt 1976 · S/N 32R-7680114 N8427YBiernacki David F · Rockford, ILBuilt 1967 · S/N 30-1584

Back to AD 97-01-01 R1