Skip to content

Registered aircraft · 81,733

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N3276PFly Rite Aviation LLC · Fort Myers, FLS/N 23-1221 N32773Dalba Andrew Naim · Anaheim, CABuilt 1974 · S/N 28R-7535088 N32779Bcm Enterprise LLC · Phoenix, AZBuilt 1974 · S/N 28-7515238 N3277CSandstrom Mark R · Minot, NDBuilt 1978 · S/N R18200264 N3277MSmith Carmen Marie · Juneau, AKBuilt 1947 · S/N 12-2134 N3277ZBacklund Scott W · Greybull, WYFirst renewal noticeS/N 22-7229 N32781Arends Aviation And Instruction LLC · Mahomet, ILBuilt 1974 · S/N 28-7515239 N32783Frederick Michael A · Cleves, OHBuilt 1974 · S/N 28R-7535089 N32784Denicola Frank J · Visalia, CABuilt 1974 · S/N 28R-7535090 N32785Registration Pending · Kodiak, AKRegistration pending, pending cancellationBuilt 1974 · S/N 32-7500009 N3278BAllen Craig S · Hico, TXBuilt 1954 · S/N 22-2099 N3278WEvans Jacob · Mona, UTBuilt 1965 · S/N 32-109 N32790N32790 LLC · Avilla, INBuilt 1974 · S/N 28-7515242 N32793Garrido Albert · Kensington, CTBuilt 1974 · S/N 28-7515243 N32794Gilbert Thomas D · Gladstone, MIBuilt 1974 · S/N 28-7505094 N32796Mcvey Austin L · Lakewood, COBuilt 1974 · S/N 28-7510030 N32798Poor Mans Pitts LLC · Waynesville, OHS/N 1001 N3279CHunsucker Michael A · Seguin, TXS/N R18200265 N3279PSouth Bay Flight Training Center · Carolina, PRBuilt 1957 · S/N 23-1224 N3279YCrisler Garret · Rice Lake, WIBuilt 1995 · S/N 21942 N327ABN327ab LLC · Omro, WIBuilt 2023 · S/N 42127 N327AKPearce David W Trustee · Anchorage, AKBuilt 1981 · S/N 18-8109034 N327BEBlack Swamp Flyers LLC · Fremont, OHBuilt 2000 · S/N 1296-2000 N327DPZamboni Fisheries LLC · Ketchikan, AKBuilt 2016 · S/N 2010-1 N327EDKrejsa David L · Chagrin Falls, OHBuilt 1996 · S/N EB-102-2033 N327FFoster Gary R · Mineola, TXBuilt 2000 · S/N 22021 N327HBMatthews Michael B · Statesville, NCBuilt 1980 · S/N 221 N327MYankaitis Michael J · Mosinee, WIBuilt 2022 · S/N 09190062 N327MBCaptain Steeeve LLC · N Topsail Beach, NCBuilt 1990 · S/N 1577 N327MSMason Phillip R · Jacksonville Beach, FLBuilt 1992 · S/N 11 N327NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881657 N327PFMo-Col Medical Services Inc · Kirksville, MOBuilt 1998 · S/N 21038C N327PPEnglish Paul L Jr · Enterprise, ALBuilt 2005 · S/N 70380 N327RVEvans Ryan C · Scranton, NDBuilt 2024 · S/N 73591 N327SBSchultz Christopher A · Lake Forest, CABuilt 2014 · S/N 01573-SB N327SPAmeriflyers Of Texas Inc · Addison, TXBuilt 1999 · S/N 172S8254 N327TBuerk Christian E · West Ossipee, NHBuilt 1953 · S/N 18-2441 N327XNew Horizon Aviation Inc · Warwick, RIBuilt 2008 · S/N 1058-2007 N32801Registration Pending · Indianapolis, INRegistration pendingBuilt 1971 · S/N 28-7525117 N32805Scheffler Frederick L · Corinth, KYBuilt 1974 · S/N 28-7525115 N32808Strander Chad A · Lodi, WIS/N 28-7515247 N3280FChristian Edward A · Evans, GABuilt 1967 · S/N 670373 N3280PRiggin Flight Service Inc · Madison, SDBuilt 1956 · S/N 23-679 N3280RAmson Technology Lc · Des Moines, IABuilt 1969 · S/N 28R-31260 N32813Clear Sky Investments LLC · Martinsville, INS/N 28-7515248 N32816Williamson Flying Club Inc · Williamson, NYBuilt 1974 · S/N 28-7515249 N32817Keating William P · New Port Richey, FLBuilt 1974 · S/N 28-7515250 N3281FCapps Daniel Boyce · Newcastle, OKS/N 670374 N3281MSomerville Airport LLC · Grand Rapids, MIBuilt 1947 · S/N 12-2140 N3281RNowicki Stanislaw · Cottonwood Heights, UTS/N 15284363

Back to AD 81-18-04 R2