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.

N38120Hudson Wilburn Joel · Rocky Face, GABuilt 1977 · S/N 28-7790520 N3812CChristiansen Aviation LLC · Wilmington, DES/N ME-390 N3812FGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1977 · S/N 0780 N3812QN3812q LLC · San Diego, CABuilt 1981 · S/N WA-214 N3812TGtm Services LLC · Ames, IABuilt 1967 · S/N 28R-30127 N3812UBasquit Kenneth H · Pittsburgh, PABuilt 1980 · S/N WA-215 N3812WTuned Up Services Inc · Waldo, FLBuilt 1966 · S/N 32-742 N38131Rivera Ar · Nevada City, CABuilt 1941 · S/N 5874 N3813FN3813f Inc · Wilmington, DEBuilt 1977 · S/N 0781 N3813TCenturion Transportation LLC · Weatherford, OKBuilt 1967 · S/N 28R-30129 N3813WTaylor Bruce W · Stroudsburg, PABuilt 1966 · S/N 32-744 N38146Olson Richard H Trustee · Walla Walla, WAS/N 28-7790241 N38147St Denis Robert G · Lake City, FLBuilt 1977 · S/N 28-7725251 N3814FSnuffer Michael K · Reno, NVBuilt 1977 · S/N 0782 N3814PJasinski Jack J · Necedah, WIS/N 22-3504 N3814RCarlton Kevin · Mount Vernon, WABuilt 1970 · S/N 28-5835 N3814VCert Works LLC · Bennett, COBuilt 1977 · S/N R1722264 N3814WN3814w LLC · Maumee, OHBuilt 1966 · S/N 32-745 N3815EHonest Dog Farms LLC · Fayetteville, GABuilt 1966 · S/N 30-1335 N3815FOrr Charles W III · San Ramon, CABuilt 1977 · S/N 0783 N3815WCk Aviation LLC · Milledgeville, GABuilt 1966 · S/N 32-746 N3816FHotzel Jeffrey F · Gladstone, MOBuilt 1977 · S/N 0784 N3816MAnderson Jeremy J · Ankeny, IABuilt 1947 · S/N 12-2737 N3816PJohnson Dale M · Seminole, TXBuilt 1955 · S/N 22-3506 N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916 N3816T1 Vision General Aviation LLC · Sioux City, IABuilt 1967 · S/N 28R-30132 N3816YDegregorio Dennis P · Tinley Park, ILBuilt 1981 · S/N M-2304 N3816ZBouchard Timothy D · Valdez, AKBuilt 1961 · S/N 18-7554 N38177Archer Enterprises Corp · Ossining, NYBuilt 1977 · S/N 28-7790526 N38178Gcs Aero LLC · Laramie, WYBuilt 1977 · S/N 28-7790527 N3817PCoslor Donald D Jr · Grand Island, NEBuilt 1955 · S/N 22-3507 N3817QMoses Aviation Services LLC · Uvalde, TXS/N 17259917 N3817ZLivermont Joann M · Dillingham, AKS/N 18-7555 N3818QRanch Hand Flying Club Inc · Gardiner, NYBuilt 1972 · S/N 17259918 N3818TMccawley Gerald J · Parksley, VABuilt 1967 · S/N 28R-30134 N3818WHeadwinds Maintenance Inc · Fort Pierce, FLBuilt 1966 · S/N 32-750 N3818ZRigney Mark E · Ponca City, OKBuilt 1981 · S/N WA-225 N38190Classic Aviation Inc · Pella, IABuilt 1977 · S/N 28-7725260 N38191Burgess Sheldon A · Raymond, MSBuilt 1981 · S/N M-2303 N38193Ramirez Katherin · Homestead, FLBuilt 1977 · S/N 28-7725265 N38195Inspiration Aviation Ministries · Waterville, MEBuilt 1977 · S/N 28-7716230 N38197Anderson Loran · Cooperstown, NDBuilt 1977 · S/N 28-7716231 N3819FBuntings Grassroots Aviation LLC · Selbyville, DEFirst renewal noticeS/N 0787 N3819PLucas Lester L · Napa, CAS/N 22-3509 N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919 N3819TChism Alicia L · Lawrence, KSBuilt 1967 · S/N 28R-30136 N381ABWitt Anthony Joseph · Plymouth, INBuilt 2006 · S/N 3232063 N381AVNelson Allen R · Oakdale, MNS/N 38-78A0638 N381BTPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 28010085 N381CAOltman Neil R · Sandia Park, NMBuilt 2004 · S/N 1368-2004

Back to AD 81-18-04 R2