Skip to content

Registered aircraft · 54,017

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

N50RCBuric Ivan Nmn · Panama City, FLBuilt 1974 · S/N 177-02087 N50RHPlane Fun Inc Tr Trustee · Snellville, GABuilt 1981 · S/N P21000738 N50SHVitatoe Industries Inc · Chillicothe, OHBuilt 1978 · S/N P21000178 N50TFLittlefield Keith A · Kent, WABuilt 1979 · S/N 18503952 N50THD&J Aviation LLC · Sandy, UTS/N 18267759 N50TLSmith Lynn D · Roosevelt, UTBuilt 1970 · S/N A1500203 N50XFHdw Florida Helicopters Inc · Pompano Beach, FLS/N 15074345 N51000Jet-I Aviation LLC · Palm City, FLS/N 15069700 N51009Bowers Shane A · Bixby, OKBuilt 1968 · S/N 15069706 N5100APlane Sense Inc · Kindred, NDBuilt 1955 · S/N 28100 N5100EWatson Lloyd Marshall · Sublette, KSBuilt 1978 · S/N 17271713 N5100FAir & Space Education Instittute Inc · Pine Knot, KYBuilt 1964 · S/N 17251947 N5100GAero Leasing LLC · Snohomish, WABuilt 1979 · S/N 17273548 N5100QTulsa Technology Center School District 18 · Tulsa, OKBuilt 1981 · S/N 15285075 N5100VSmith Gordon J · Manhattan, KSBuilt 1980 · S/N 172RG0450 N5101DGavin Ronald A · East Helena, MTS/N 51201 N5101HAberdeen Flying Service · Aberkeen, SDBuilt 1979 · S/N 15284061 N5101NMerrill Charles Jay · Manhattan, KSBuilt 1980 · S/N 18267516 N5101YSchrock Marvin J · Sterling, AKS/N 18052550 N51029Cywan Alex M · Sherman Oaks, CABuilt 1968 · S/N 15069716 N5102DB & R Aircraft LLC · Wadsworth, OHBuilt 1979 · S/N 17272422 N5102ECag Aircraft Holdings LLC · Crystal River, FLBuilt 1978 · S/N 17271714 N5102URegistered aircraftBuilt 1979 · S/N 172RG0236 N5103AWinkelstein Aaron B · Lehi, UTS/N 28103 N5103EShannon Patrick · New Waverly, TXBuilt 1958 · S/N 50403 N5103UMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1980 · S/N 172RG0237 N51040Pruitt Benny G · Reidsville, NCBuilt 1968 · S/N 15069721 N51046Weeks Thomas W · Ypsilanti, MIBuilt 1968 · S/N 15069726 N51047Huls Timothy J · Stevensville, MTBuilt 1968 · S/N 15069727 N51048Heermance Timothy Jr · West Palm Beach, FLBuilt 1968 · S/N 15069728 N51052Smithard Austin · Peachtree, GAS/N 15069730 N51059Donadio Gerard J · Ronkonkoma, NYS/N 15069736 N5105DPaulsden LLC · Caldwell, IDBuilt 1958 · S/N 51205 N5105ESayers James B · Edison, OHBuilt 1959 · S/N 50405 N5105MAscend Aviation LLC · Bountiful, UTBuilt 1980 · S/N 15284499 N5105PJet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15284877 N5105QBailey Glenn E · Oldenburg, INBuilt 1973 · S/N 17261749 N5105YMcduff Douglas M · Cook, MNBuilt 1980 · S/N 21064074 N51060Elmore Eric T · Colorado Springs, COS/N 15069737 N51068Hodges Michael D · Glenpool, OKBuilt 1968 · S/N 15069743 N51069Sport Flyer LLC · Jackson, WYBuilt 1968 · S/N 15069744 N5106BBabcock Lori A · Salina, KSBuilt 1979 · S/N 15283747 N5106CQuest Aviation Inc · Lake City, FLBuilt 1979 · S/N 21063704 N5106DOut Of The Blue Skydiving LLC · Parker, COBuilt 1958 · S/N 51206 N5106SDawson Michael · Lynnwood, WAS/N R18201505 N51070Rabbit Hill Industries Inc · Bedford, NYS/N 17274262 N51074Donner John R · Clara City, MNBuilt 1968 · S/N 15069747 N5107BWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15283748 N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705 N5107DHardman Lorin D · Wasilla, AKBuilt 1958 · S/N 51207

Back to AD 87-20-03 R2