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.

N6432PAlvarez Frank · Hartford, WIBuilt 1959 · S/N 24-1542 N6435PTriggs Andrew · Las Vegas, NVBuilt 1960 · S/N 24-1546 N6439PWalter Sean E · Vancouver, WABuilt 1959 · S/N 24-1551 N64400Mascari M Richard · Iowa City, IABuilt 1964 · S/N 26-36 N6440PMcdonald Patricia Lynn · Westcliffe, COBuilt 1959 · S/N 24-1553 N6442PV & E Aviation LLC · Wisconsin Rapids, WIBuilt 1959 · S/N 24-1555 N6443PCox William Matthew · Las Vegas, NVBuilt 1959 · S/N 24-1556 N6444PSanderson Grain Inc · Springlake, TXBuilt 1959 · S/N 24-1558 N6447PTuttle Glenn L · Lynnwood, WABuilt 1959 · S/N 24-1562 N6448PPlowman James C · Upland, CABuilt 1959 · S/N 24-1563 N644BCRegistration Pending · Sioux Falls, SDRegistration pendingBuilt 1976 · S/N 32R-7680229 N6451PRoush Benjamin F · Letart, WVBuilt 1959 · S/N 24-1566 N6453PHagel Kelton Roy · Carrington, NDBuilt 1959 · S/N 24-1568 N6455PHussey Wilfred Lee II · Martinsville, VABuilt 1959 · S/N 24-1570 N6458PHutchison Joseph C · Mebane, NCBuilt 1959 · S/N 24-1573 N6459PJaeger Timothy S · Mukwonago, WIS/N 241574 N645RD&S Development LLC · Spring, TXBuilt 1964 · S/N 30-240 N645SDDacy Julia A · Harvard, ILBuilt 1964 · S/N 30-524 N6460PAlpha Romeo Kilo Holdings Inc · Wilmington, DEBuilt 1959 · S/N 24-1575 N6461PSullenger Charles H · Statesboro, GAS/N 24-1576 N6465PKesser Gilbert M · Culpeper, VABuilt 1959 · S/N 24-1580 N6468PTevis Aviation Enterprises LLC · Newcastle, OKS/N 24-1583 N6471PWare Patrick D · Farwell, TXBuilt 1959 · S/N 24-1586 N6475CFulton Technology Corp · Caroleen, NCBuilt 1978 · S/N 28R-7803231 N6476PSky Runner Aviation LLC · Wadsworth, OHBuilt 1959 · S/N 24-1592 N6480PCmc Aero LLC · Broken Arrow, OKS/N 24-1597 N6482PCorson County Feeders Inc · Mc Laughlin, SDBuilt 1959 · S/N 24-1600 N6483PLee Charles C · New Buffalo, MIBuilt 1959 · S/N 24-1601 N6486PBerg Alvin L · Overgaard, AZBuilt 1959 · S/N 24-1604 N6488PSooner Answer Service Inc · Edmond, OKS/N 24-1607 N6494CKaminicki Craig G · Monticello, ARBuilt 1978 · S/N 34-7870161 N6494PPiehl Deborah C · Saint Petersburg, FLS/N 24-1614 N6495PBarry Steven H · Monticello, UTS/N 24-1615 N6498PSinor Delbert · Ozark, MOS/N 24-1618 N6499PHoward John · Canon City, COBuilt 1959 · S/N 24-1620 N64BACisco Beach Investments Inc · Dover, DES/N 34-7970341 N64DC64dc LLC · Bishop, CABuilt 1977 · S/N 28R-7703397 N64EEConrad John E · Flower Mound, TXBuilt 1963 · S/N 24-3526 N64PCReed Allan T · Danville, INBuilt 1963 · S/N 24-3583 N64STStefenelli Aviation N Tr Inc Trustee · AtterseeBuilt 1973 · S/N 28R7335185 N64TD377 Supplies LLC · Argyle, TXS/N 30-170 N64YBRegistration Pending · Wasilla, AKRegistration pendingS/N 30-331 N6500PDennison Ronald Walton Trustee · San Jose, CABuilt 1959 · S/N 24-1621 N6502PMelvin Kelly G · Green River, WYBuilt 1959 · S/N 24-1623 N6505PCaduda & Faulk Aero Ltd · Nederland, COBuilt 1959 · S/N 24-1626 N6507FToledo Thiago Amaral · Bonita Springs, FLBuilt 1976 · S/N 32R-7780028 N6507JBarnes Brandon M · Metamora, ILS/N 28R-7635331 N6508CMurphy Matthew · Anchorage, AKBuilt 1978 · S/N 28R-7803233 N6511PCaplinger James F · Battle Ground, WABuilt 1959 · S/N 24-1633 N6516CBarsocchini Albert P · Friday Harbor, WABuilt 1978 · S/N 28R-7803234

Back to AD 97-01-01 R1