Skip to content

Registered aircraft · 20,481

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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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:84-10-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.

N715HPOhio Department Of Public Safety · Columbus, OHBuilt 2000 · S/N 18280921 N715MASim International Inc · Fort Mill, SCBuilt 1980 · S/N 18267469 N715RCEide David B · Saint Michael, MNBuilt 2002 · S/N 18281085 N715WBRichardson Clay W · Ozona, TXBuilt 1978 · S/N 18052915 N71607Hamby Robert Eidson · Martin, GABuilt 1969 · S/N 18259685 N7160EKenyon Larry H · Grafton, OHBuilt 1959 · S/N 51717 N71610Bowyer Steele · Long Beach, CABuilt 1969 · S/N 18259687 N71614Naylor Scott Trustee · Salinas, CABuilt 1969 · S/N 18259688 N71616Summit Helicopters Inc · Salem, VABuilt 1969 · S/N 18259689 N7161ERegistration Pending · Thomasville, NCRegistration pendingBuilt 1959 · S/N 52161 N71621Skyward Bound Associates Ltd · Newark, DEBuilt 1969 · S/N 18259691 N71622Gabrielson Richard A · Lyons, COBuilt 1969 · S/N 18259692 N71623Bond Kevin · Sandy, UTBuilt 1969 · S/N 18259693 N71624Tyler Terry Lynn Trustee · Tulsa, OKBuilt 1969 · S/N 18259694 N71626Terwilliger Ron · Belton, MOBuilt 1969 · S/N 18259695 N7162DFaulkner Winthrop Sewell · Anchorage, AKBuilt 1978 · S/N U20604342 N71634Hester Daniel R · Stokesdale, NCBuilt 1969 · S/N 18259697 N71637Schneider Gregory P · Laguna Beach, CABuilt 1969 · S/N 18259698 N71638Fisher Logan S · Rudyard, MTBuilt 1969 · S/N 18259699 N71640Thom Derek · Peck, MIBuilt 1969 · S/N 18259700 N71641Fortenberry Aviation LLC · Crossville, ALBuilt 1969 · S/N 18259701 N71651J2k Fly By Night LLC · Hickman, NEBuilt 1969 · S/N 18259703 N71652Leftovers Aviation LLC · Reno, NVBuilt 1969 · S/N 18259704 N71655Starr Digital Technologies Inc · Medina, OHBuilt 1969 · S/N 18259706 N71656Kindsvater Harold E · Boulder City, NVBuilt 1969 · S/N 18259707 N71659Monroe Belle LLC · Greensboro, GAS/N 18259708 N71665Misener Mark J · Central Point, ORBuilt 1969 · S/N 18259709 N7166ESutton Aircraft Salvage LLC · Palmer, AKBuilt 1959 · S/N 52166 N71670Wreyford James S · Marble Falls, TXBuilt 1969 · S/N 18259711 N71675Sea To Summit Aero LLC · Mertzon, TXBuilt 1969 · S/N 18259713 N71678Mitchell Flying Service LLC · Cushing, OKBuilt 1969 · S/N 18259714 N71685Hamilton Thomas S DBA · Priest River, IDBuilt 1969 · S/N 18259718 N7168ERampton Curtis D · Reno, NVBuilt 1959 · S/N 52168 N71699Grit Ventures LLC · Throckmorton, TXBuilt 1969 · S/N 18259722 N716CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 18281711 N716HPState Of Ohio · Columbus, OHBuilt 2005 · S/N 18281581 N716MCWing & A Prayer LLC · Wilmington, DEBuilt 2005 · S/N 18281717 N716MTColvin Mariann · Round Rock, TXBuilt 2001 · S/N 18281037 N716PCPcfo Air LLC · Plymouth, MNBuilt 2021 · S/N 18283159 N71705Wilson Alfred C · Salisbury, NCBuilt 1969 · S/N 18259724 N7170EMcknight Thomas N · Fredericksburg, TXBuilt 1959 · S/N 52170 N71710Warp Six Aviation LLC · Manitowoc, WIBuilt 1969 · S/N 18259725 N7171EPhillips John · Vernal, UTBuilt 1959 · S/N 52171 N7171SGuerra Carrie E · Lompoc, CABuilt 1976 · S/N 18265077 N71726Mayes John · Carson City, NVBuilt 1969 · S/N 18259730 N7172EGibson James T · Brookhaven, MSBuilt 1959 · S/N 52172 N71731Brisson Michael Paul · Enterprise, ALBuilt 1969 · S/N 18259733 N71735Dinota Dominick · Wallkill, NYBuilt 1969 · S/N 18259735 N71736Nixon Leland Bryan · Stapleton, ALBuilt 1969 · S/N 18259736 N7173EMcpherson David R · Sturgis, SDBuilt 1959 · S/N 52173

Back to AD 84-10-01 R1