Skip to content

Registered aircraft · 17,027

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:72-03-03-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3') 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:72-03-03-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
  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:72-03-03-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-03-03-R3')
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.

N42673Chase Donald C · Erie, PABuilt 1968 · S/N 18259132 N42678Merow Michael C · Algoma, WIBuilt 1968 · S/N 18259135 N4267QDhf LLC · Valentine, NEBuilt 1971 · S/N 17260167 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 N4269LBussey Stuart · Lafayette, CABuilt 1966 · S/N 17254338 N426ASSaylor Alvin N Jr · Friendswood, TXBuilt 1970 · S/N P206-0590 N426MCMagic Carpet LLC · Wilmington, DEBuilt 1971 · S/N 17260022 N426XARound Engine Aero · Nashville, MIS/N 15063198 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 N4270LDavenport Sam · Gail, TXBuilt 1966 · S/N 17254339 N4270QReeves James C · Locust Grove, GABuilt 1971 · S/N 17260170 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 N4271LRoberts David W · Arden, NCS/N 17254340 N42725Tepper Jeremy A · Vail, AZBuilt 1968 · S/N 18259165 N4272LStechbart Kurt E · Glendora, CABuilt 1966 · S/N 17254341 N42732Wampole David R · Miami, FLBuilt 1968 · S/N 18259169 N4273QSimmons Robert J · Justin, TXBuilt 1971 · S/N 17260173 N42742Still Russell F · Cumming, GABuilt 1968 · S/N 18259171 N42748Crowe Tanner L · Anchorage, AKBuilt 1968 · S/N 18259173 N4274QLjn Aircraft LLC · Jamestown, NYBuilt 1971 · S/N 17260174 N42754Shade Donald S · Big Bear City, CABuilt 1968 · S/N 18259175 N42758Carver Steven R · Scottsville, KYS/N 18259177 N4275LBarney Jared L · Tully, NYBuilt 1966 · S/N 17254344 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 N4276QOjdrovich George · Steamboat Springs, COBuilt 1971 · S/N 17260176 N42770Barthelette Kenneth E · Pawleys Island, SCBuilt 1968 · S/N 18259184 N42777Cantwell Patrick W · San Francisco, CABuilt 1968 · S/N 18259185 N4277QRawlins William David Sr · Martinez, GABuilt 1971 · S/N 17260177 N42792Baxter Adam W D · Anchorage, AKBuilt 1968 · S/N 18259193 N427BPBest Kenneth M · Sullivan, ILBuilt 1973 · S/N 177RG0434 N427JWDyer Ray R · Kalispell, MTBuilt 1972 · S/N 15073873 N42801Aas LLC · Ovid, MIBuilt 1968 · S/N 18259195 N42804N42804 LLC · Brush, COBuilt 1968 · S/N 18259196 N4280LShellbourne Aviation LLC · Ormond Beach, FLBuilt 1966 · S/N 17254349 N42818Cleveland Jeffrey Allen Trustee · Indian Trail, NCBuilt 1968 · S/N 18259203 N4281LKiger Aviation LLC · Corvallis, ORBuilt 1966 · S/N 17254350 N4281QMcdonald Air Services LLC · Saint Johns, MIBuilt 1971 · S/N 17260181

Back to AD 72-03-03 R3