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.

N4182JBialecki Aviation Leasing LLC · Getzville, NYBuilt 2001 · S/N 2842118 N4182LHorizon Dreams LLC · Homer, GABuilt 2001 · S/N 2843416 N4182MGreer Guy A · Wasilla, AKBuilt 1947 · S/N 12-3089 N4182TMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17270319 N4182YShouling & Philip Enterprise · Lancaster, CABuilt 1977 · S/N 604-77 N4182ZKing Air Inc · Naknek, AKBuilt 1966 · S/N 18-8367 N41838Baker Arthur M II · Mundelein, ILBuilt 2000 · S/N 3246171 N4183CLockhart Curtis M · Bay Village, OHBuilt 1978 · S/N R18200338 N4183NEndeavour Flight Training Inc · Miami, FLBuilt 1998 · S/N 18280150 N4183ZTirrell Troy L · Cordova, AKBuilt 1966 · S/N 18-8368 N41842Robinson Helicopter Co · Torrance, CABuilt 1993 · S/N 0010 N4184JGorman Jeffrey M · Ellensburg, WAS/N 28-22523 N4184TMullys Equipment Leasing LLC · Castle Pines, COBuilt 2001 · S/N 2843418 N4184VUpper Jets Maintenance LLC · Miami, FLBuilt 2001 · S/N 2843420 N4184YMoncrief Rick L · Melba, IDS/N 600-77 N4184ZCross L Ranch Inc · Cohagen, MTBuilt 1966 · S/N 18-8369 N41858Skybound Aviation LLC · Kernersville, NCBuilt 1974 · S/N 28-7415338 N41859Morale Joseph D · Dallas, TXBuilt 1974 · S/N 28-7405145 N4185WJames William S · Orange Park, FLBuilt 2001 · S/N 2843417 N4185ZHill Leslie E · Patten, MEBuilt 1966 · S/N 18-8370 N41867Stevens Charles O · Columbus, MSBuilt 1974 · S/N 28-7415340 N4186ZSturgeon Ronald A · Anchorage, AKBuilt 1966 · S/N 18-8371 N4187JPeterson Erik J · Revillo, SDBuilt 1967 · S/N 28-22526 N4187YStohr Beuford G · Woden, IABuilt 1977 · S/N 289-77 N4187ZPickus Norman F · Fairbanks, AKBuilt 1966 · S/N 18-8372 N41880Brown Terry K · Eddyville, IABuilt 1974 · S/N 28-7425292 N41882Monroe Robert E · Navarre, FLBuilt 1974 · S/N 28-7415345 N41888Lanyi Clifford M · Attleboro, MABuilt 1974 · S/N 28-7415348 N4188JLaib Aaron B · Emporia, KSS/N 23022 N4188MLindholm Michael D · Anchorage, AKBuilt 1947 · S/N 12-3078 N4188PAero Club Valkaria LLC · Malabar, FLS/N 23-1676 N4188TBird Acquisition LLC · Phoenix, AZBuilt 1998 · S/N 2843124 N4188ZDanielson Debra · Skillman, NJBuilt 1966 · S/N 18-8373 N41896Hoffman Rick · Buckley, WABuilt 1974 · S/N 28-7415349 N41897Unlimited Upside LLC · Boggstown, INBuilt 1974 · S/N 28-7415350 N4189MSchettler Patrick J · Garnett, KSBuilt 1947 · S/N 12-3090 N4189PAdams Carlos · Hawi, HIS/N 23-1677 N4189YBaldacci Eric · Katy, TXBuilt 1977 · S/N 1191-77 N418AAAltitude & Anchor LLC · Kalispell, MTS/N 0582 N418ALMckeen Alan P · Liverpool, NYBuilt 1997 · S/N 23130 N418BSNorton Ranch LLC · Baker City, ORBuilt 1947 · S/N 12-2831 N418CBDallas Aero & Sales LLC · Poplar, MTBuilt 2001 · S/N 2144 N418CCRedfield James A · Simi Valley, CABuilt 1976 · S/N 17702464 N418DBNewton Thomas L Jr · Fredericksburg, VABuilt 1974 · S/N 6737 N418DCCunningham Dan · Bismarck, ILBuilt 1998 · S/N 331 N418DMMria LLC · Phoenix, AZBuilt 2015 · S/N 18282418 N418FLKinney Richard · West Des Moines, IABuilt 1971 · S/N 28-7125197 N418FPUtah State University · Logan, UTBuilt 2006 · S/N 40.FC018 N418JTDavies Lloyd G · Orofino, IDBuilt 1978 · S/N 13123 N418KN418k LLC · Jupiter, FLBuilt 2016 · S/N 005

Back to AD 81-18-04 R2