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.

N446BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2023 · S/N 4496553 N446BLBlue Line Aviation LLC · Smithfield, NCBuilt 2025 · S/N 4496600 N446CACivil Air Patrol · Maxwell Afb, ALBuilt 2024 · S/N 172S13263 N446CBEastern Stearman Inc Trustee · Leesburg, VABuilt 1995 · S/N 24-3359 N446CSSocal Pilot Center · La Quinta, CABuilt 2017 · S/N 172S12001 N446DCAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 40.446 N446DLHodge Ronald R · Granbury, TXBuilt 1996 · S/N 085 N446DSFun Air LLC · Houston, TXBuilt 2002 · S/N 40.246 N446ERWingsleasing LLC · Wichita, KSBuilt 2006 · S/N 172S10220 N446GWPrati Paul B · El Paso, TXBuilt 1978 · S/N 3 N446KWClementi Frank R · Wesley Chapel, FLBuilt 2011 · S/N 1474R N446MKNorth Star Aviation · Mankato, MNBuilt 2018 · S/N 4496448 N446PAHillsboro Aero Academy LLC · Hillsboro, ORBuilt 2001 · S/N 4496086 N446RMRocky Mountain College · Billings, MTBuilt 2023 · S/N 28020111 N446SPLam Capital Management LLC · Sheridan, WYBuilt 1999 · S/N 172S8310 N446TTC5 Aviation LLC · Sheridan, WYBuilt 1974 · S/N 28R-7435317 N446YBBeal James M Trustee · Eugene, ORBuilt 2012 · S/N 91919 N44702Shawback Brian D · Anchorage, AKBuilt 1974 · S/N 28-7515007 N44704Bender Aviation Services Inc · Clearwater, FLBuilt 1974 · S/N 28-7515008 N44705Warden James L · West Milford, NJBuilt 1974 · S/N 28-7515010 N44708Interthal Mike · Butler, PABuilt 1974 · S/N 28-7405277 N4470AAnderson Stephen A · Yuba City, CABuilt 1956 · S/N 18-4822 N4470ETurner John C R · Broken Arrow, OKS/N 38-78A0622 N4470JBister John C · Culver, ORBuilt 1967 · S/N 28-22886 N4470YAmundson Daryl A · Blue Earth, MNBuilt 1966 · S/N 25-4124 N4470ZRegistration Pending · Weatherford, TXRegistration pendingBuilt 1969 · S/N 18-8819 N44710Bonin David P · Belmond, IABuilt 1974 · S/N 28-7515012 N44714Burchfield Bill · Tanner, ALBuilt 1974 · S/N 28-7515013 N44715Skogen Karl L · White Bear Lake, MNBuilt 1974 · S/N 28-7515014 N4471NSpitzer Helicopter LLC · Wilmington, DEBuilt 2011 · S/N 4508 N4471ZEgolf Charles F · Spokane, WAS/N 18-8821 N4472DSky Helicopters Inc · Desoto, TXBuilt 2025 · S/N 4913 N4472FA&J Aircraft Leasing Inc · Burlington, COBuilt 1976 · S/N 28-7715034 N4472HSalamon Uri · Boerne, TXBuilt 1978 · S/N 24-0743 N4472MStone Aviation Enterprises Inc · East Syracuse, NYS/N PRICE 1 N4472RFlyrite Aviation LLC · Fort Myers, FLBuilt 1974 · S/N 17263214 N4472YSilent Flight LLC · Payette, IDBuilt 1966 · S/N 25-4128 N4473FPate Elaine · Thousand Oaks, CABuilt 1976 · S/N 28-7715035 N4473JAj Aviation LLC · Gwinner, NDBuilt 1967 · S/N 28-22889 N4473PSemeniuk Steven T · Houston, TXS/N 23-2018 N4473RMiller Keith A · Reedy, WVBuilt 1974 · S/N 17263215 N4473XSlipstream Aviation LLC · Calera, ALBuilt 1975 · S/N 28-7690018 N4473YJackson Robert S · Gallatin, TNBuilt 1949 · S/N 16-375 N4473ZEriksen Rodney B Trustee · Juneau, AKBuilt 1969 · S/N 18-8822 N44747Goldenburg Timothy A · Ypsilanti, MIBuilt 1974 · S/N 32-7500001 N44749Hoprich Jeffrey S · Roanoke, VABuilt 1974 · S/N 28-7515021 N4474FN44107 LLC · Marlton, NJBuilt 1976 · S/N 28-7790029 N4474XToledo City School District · Swanton, OHS/N 28R-7635054 N4474ZWatts Craig W · Incline Village, NVBuilt 1969 · S/N 18-8824 N44753Registration Pending · Torrance, CARegistration pendingBuilt 1974 · S/N 28-7505006

Back to AD 81-18-04 R2