Skip to content

Registered aircraft · 20,483

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.

N42623Boulware Randall R Trustee · Bolivar, MOBuilt 1968 · S/N 18259110 N42625Tull Matthew W · Niceville, FLBuilt 1968 · S/N 18259112 N42627Henry Mark A · Dickinson, TXS/N 18259114 N42631Ga Elite LLC · Camarillo, CABuilt 1968 · S/N 18259115 N42632Hebert Mark R Trustee · Lakeville, MNBuilt 2022 · S/N 18283184 N42645Williams Ray H Jr Trustee · Austin, NVBuilt 1968 · S/N 18259120 N42647Glenwood Tank Facility LLC · Ramsey, MNBuilt 1968 · S/N 18259121 N42648Propwash 182 LLC · Visalia, CABuilt 1968 · S/N 18259122 N42649Skydive Harbor Springs Inc · Charlevoix, MIBuilt 1968 · S/N 18259123 N42652West Dennis M · Lexington Park, MDBuilt 1968 · S/N 18259124 N42653Stockwell William · Dowagiac, MIBuilt 1968 · S/N 18259125 N42655Hawes Pamela M · Lancaster, MABuilt 1968 · S/N 18259126 N4266298x LLC · Caddo Mills, TXBuilt 1968 · S/N 18259128 N42672Dowden Lairon W Jr · Nederland, TXBuilt 1968 · S/N 18259131 N42673Chase Donald C · Erie, PABuilt 1968 · S/N 18259132 N42678Merow Michael C · Algoma, WIBuilt 1968 · S/N 18259135 N42687Cal Coast Reps Inc · Costa Mesa, CABuilt 1968 · S/N 18259138 N42689Alc Aviation LLC · Waseca, MNBuilt 1968 · S/N 18259140 N42693Paul D Barkhurst Pc · San Antonio, TXBuilt 1968 · S/N 18259141 N42694Jaffa Bruce E · Moose Pass, AKBuilt 1968 · S/N 18259142 N42698Bruch Stein · Randolph, MNBuilt 1968 · S/N 18259145 N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590 N426PWElectron International Aviation LLC · Phoenix, AZBuilt 2020 · S/N 18283111 N42700Van Matre Thomas A Jr · Mineola, TXBuilt 1973 · S/N 18052371 N42704White Dog I LLC · Bend, ORBuilt 1968 · S/N 18259149 N42705Henry James A · Fresno, CABuilt 1968 · S/N 18259150 N42707Management Assistance Group LLC · Hamilton, NJBuilt 1968 · S/N 18259152 N42712Adams William Kelly · Tulia, TXBuilt 1968 · S/N 18259155 N42713Prater Bobby D · Grand Ledge, MIBuilt 1968 · S/N 18259156 N42714Crouch Jeffrey Lane Sr · Rockingham, NCBuilt 1968 · S/N 18259157 N42715Coleman Robert B · San Francisco, CABuilt 1968 · S/N 18259158 N42718Circle K Bar LLC · Ardmore, OKBuilt 1968 · S/N 18259161 N42725Tepper Jeremy A · Vail, AZBuilt 1968 · S/N 18259165 N4272QKeech Mark A · Fairbanks, AKBuilt 1976 · S/N U20603042 N42732Wampole David R · Miami, FLBuilt 1968 · S/N 18259169 N42742Still Russell F · Cumming, GABuilt 1968 · S/N 18259171 N42748Crowe Tanner L · Anchorage, AKBuilt 1968 · S/N 18259173 N4274RCatset Funding LLC · Coral Gables, FLBuilt 1997 · S/N 18280027 N42754Shade Donald S · Big Bear City, CABuilt 1968 · S/N 18259175 N42758Carver Steven R · Scottsville, KYS/N 18259177 N42763Vf 126 Aviation LLC · Chicago, ILBuilt 1968 · S/N 18259178 N427653 B Farms Inc · Pinetown, NCBuilt 1968 · S/N 18259180 N42766Jessee Robert A · Winter Haven, FLBuilt 1968 · S/N 18259181 N42768Horn Terry D · Sharpsburg, GAS/N 18259183 N42770Barthelette Kenneth E · Pawleys Island, SCBuilt 1968 · S/N 18259184 N42777Cantwell Patrick W · San Francisco, CABuilt 1968 · S/N 18259185 N42792Baxter Adam W D · Anchorage, AKBuilt 1968 · S/N 18259193 N427CSVan Bortel Aircraft Inc · Arlington, TXBuilt 2016 · S/N 18282427 N427GBBoies Guy J · Mason, TXBuilt 1973 · S/N 18262174 N427JDMule Air LLC · San Antonio, TXBuilt 2005 · S/N 18281593

Back to AD 84-10-01 R1