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.

N4197XBarr Air Patrol LLC · Mesquite, TXBuilt 1999 · S/N 18280449 N4197YAgnew Michael D · Pardeeville, WIS/N 1193-77 N4197ZBurns Barry D · Amarillo, TXS/N 18-8389 N41980Warren Donald E · Pine Bluff, ARBuilt 1974 · S/N 28-7415377 N41983Brotherman LLC · Hereford, TXBuilt 1974 · S/N 28-7415379 N41985Aerospace Systems And Training LLC · Orange City, FLBuilt 1974 · S/N 28-7405157 N4198BAero Flight Flying Club · Minneapolis, MNBuilt 1959 · S/N 23-1687 N4198FRal Aviation LLC · Trumbull, CTBuilt 1976 · S/N 28-7790006 N4198RTaf Aerial Services LLC · Beeville, TXBuilt 1999 · S/N 14096C N4198YGallo Michael R · High Falls, NYBuilt 1977 · S/N 292-77 N4198ZMcfarlane Bradley J · Port Alsworth, AKBuilt 1966 · S/N 18-8391 N41992Stein Anthony J · Locust Grove, GABuilt 1974 · S/N 28-7415380 N41995Columbus State Community College · Columbus, OHFirst renewal noticeBuilt 1974 · S/N 28-7415382 N41997Caae Leasing LLC · Lake Zurich, ILBuilt 1974 · S/N 28R-7435235 N4199AKiser Richard K · Mount Solon, VABuilt 1951 · S/N 18-924 N4199HN4199h Club Llp · Oshkosh, WIBuilt 1978 · S/N 24-0661 N4199JHallenbeck Jesse · Bellingham, WAS/N 28-22543 N4199TEnga James Craig · Madison, SDBuilt 1998 · S/N 18280372 N4199ZSymanowski Kevin · Reeder, NDBuilt 1966 · S/N 18-8392 N419ACSimmons Scott · Anchorage, AKBuilt 2000 · S/N 408-99 N419AKSpats Aviation LLC · Toledo, OHBuilt 1951 · S/N 18-1067 N419ALTomahawk Aero Services LLC · Bellingham, WABuilt 1978 · S/N 38-78A0401 N419BCVagabond LLC · Baton Rouge, LABuilt 1982 · S/N 60-8265045 N419CCHills Craig · Avon, INBuilt 1979 · S/N 28-7911268 N419CMN419cm LLC · Bloomington, ILBuilt 2026 · S/N 43003 N419CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N 172S12348 N419CSGarza Richard · Monterey, CABuilt 2016 · S/N 18282419 N419DTurner Spencer A · Modesto, CABuilt 1995 · S/N 20419 N419DMNote Clayton R · Eagle Point, ORBuilt 2003 · S/N 442-2003 N419DSLien Christian B · Rapid City, SDBuilt 2006 · S/N 1030-2006 N419EPEpic Aviation Inc · New Smyrna Beach, FLBuilt 2019 · S/N 172S12278 N419FKlenoski Brian D · Fulton, MIBuilt 2000 · S/N 22690 N419FRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11446 N419FWFlorida Fish & Wildlife Conservation Commission · Lakeland, FLBuilt 2002 · S/N 419-19/0B2 N419GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881176 N419GCRiley Bradlee A · Archdale, NCBuilt 2016 · S/N AAZA0167 N419JARaw Aviation LLC · Wichita, KSBuilt 2007 · S/N 18281885 N419JNWheeler Kelly · Columbia Falls, MTBuilt 2017 · S/N 419 N419LJGowenmleah Jill · Lawrenceburg, TNBuilt 1977 · S/N 32-7840060 N419LKSluka Christopher · San Diego, CABuilt 1978 · S/N 17271787 N419MGAnderson Todd · Bondurant, IABuilt 2007 · S/N 05-503 N419PASkywest Leasing Inc · St George, UTBuilt 2000 · S/N 2843413 N419PHTaylor Septic Services LLC · Deltona, FLBuilt 1979 · S/N 32-7940039 N419RStruthers Robert J · Geneva, ILBuilt 2009 · S/N 0001 N419SGilpin Nathan L · Cornelia, GAS/N 419-S N419SAStephens Kristi J · Bellingham, WABuilt 2003 · S/N 912-2003 N419SBLipscomb Brian · Fulshear, TXBuilt 1992 · S/N 2811034 N419SFTotal Flight Aircraft Leasing LLC · Apex, NCS/N 17262659 N419TEEp Enterprises Inc · San Juan, PRS/N 20-0039 N419WAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 1995 · S/N 2843001

Back to AD 81-18-04 R2