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.

N3311KBartholomew Donald B · Gardnerville, NVBuilt 1946 · S/N 1304 N3311MAdams David R · Concrete, WABuilt 1947 · S/N 12-2170 N3311TSchulze Tom L · Smithville, MOBuilt 1967 · S/N 17700611 N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124 N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123 N33124Meyer Robert Dean Jr · California, MDBuilt 1975 · S/N 28-7510039 N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125 N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124 N3312ARegistration Pending · Myerstown, PARegistration pendingBuilt 1953 · S/N 22-1584 N3312MDiedrich Paul E · Fort Mill, SCBuilt 1947 · S/N 12-2167 N3312WMcmurray Michael J · Killeen, TXBuilt 1965 · S/N 32-150 N33138Ables John M · Tehachapi, CABuilt 1975 · S/N 28-7525161 N33139Hallert Benjamin F · Springfield, ORBuilt 1975 · S/N 28-7515320 N3313BOlling Stanley J Trustee · Wanatah, INBuilt 1954 · S/N 22-2128 N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126 N33143Bascom Jon A Trustee · Tega Cay, SCBuilt 1975 · S/N 32-7500015 N33147Johann Austin J · Richland Center, WIS/N 28-7525163 N33148Hitchcock Lonnie G · Sparta, TNBuilt 1975 · S/N 28-7515322 N33149Great Lakes Air Ventures LLC · Mason, MIBuilt 1975 · S/N 28-7515323 N3314AMichalek Construction Inc · Keosauqua, IABuilt 1953 · S/N 22-1589 N3314EEnglund Frances L · Fairport, NYBuilt 1978 · S/N 17271500 N3314SN3314s LLC · Oklahoma City, OKBuilt 1998 · S/N 18280236 N33150Iowa County Flying Club Inc · Mineral Point, WIBuilt 1975 · S/N 28-7505127 N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127 N33153Pathfinder Ff LLC · Dover, DES/N 28-7510040 N33158Mc Aviation LLC · Paducah, KYBuilt 1975 · S/N 28-7525164 N3315EBas Part Sales LLC · Greeley, COS/N 17271501 N3315MRegistered aircraftAssigned, pending cancellationS/N 12-2159 N3315TLovelady William K · Grapevine, TXBuilt 1967 · S/N 17700615 N3316Wilson Robert L · Greenfield, OHBuilt 1970 · S/N 278 N33161Fca Flight Training LLC · Washington C H, OHS/N 28-7525165 N33169Good James R H · Nevada City, CABuilt 1975 · S/N 28-7515326 N3316MHickey Aero Services LLC · White Hills, AZS/N 12-2169 N3316PCrew Sourcing Inc · Wilmington, DEBuilt 1958 · S/N 23-1267 N33170Atlanta Sky Signs LLC · Sharpsburg, GABuilt 1975 · S/N 28-7505129 N3317MJacobs Robert E · Santa Fe, NMBuilt 1947 · S/N 12-2172 N3317TGay Don A DBA · Garfield, GABuilt 1967 · S/N 17700617 N33180Van Wagner Aerial Media LLC · Hollywood, FLS/N 5-456 N3318BDeane Daniel G · Park City, UTBuilt 1954 · S/N 22-2133 N3318ERodriguez Jose R · Los Angeles, CABuilt 1978 · S/N 17271502 N3318MMh Aviation LLC · Foster City, CAFirst renewal noticeBuilt 1947 · S/N 12-2176 N3318TPipeair LLC · Vancouver, WABuilt 1967 · S/N 17700618 N33195Heathco Merle S · Scappoose, ORBuilt 1976 · S/N 177RG0918 N3319AThomas Brian D · Corning, IABuilt 1953 · S/N 22-1595 N3319MWhirley Bradley J · Brainerd, MNBuilt 1947 · S/N 12-1883 N331AHArmstrong Helicopters LLC · Laredo, TXBuilt 2003 · S/N 10042 N331BEBabich Leslie Paige · Lutz, FLBuilt 1981 · S/N M-2300 N331BGCavorite Aviation LLC · West Jordan, UTBuilt 2000 · S/N 2843373 N331CDDay Charles L · Edison, NJBuilt 1999 · S/N 333 N331CHCh Wings LLC · Arvada, COBuilt 2022 · S/N 172S12917

Back to AD 81-18-04 R2