Skip to content

Registered aircraft · 40,471

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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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:80-04-03-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.

N8238NSilver Hawk Aviation LLC · Panora, IABuilt 1969 · S/N 28-25445 N8238WParish John I · New Braunfels, TXBuilt 1965 · S/N 28-2380 N82391Trester Boyd H · Sentinel Butte, NDBuilt 1977 · S/N 18-7709152 N82398Irwin Jeffrey C · Poland, NYBuilt 1977 · S/N 18-7709154 N8239NKattke Timothy J · Redfield, SDBuilt 1969 · S/N 28-25447 N8239P3so II LLC · Louisville, KYBuilt 1963 · S/N 24-3493 N823EJObrien Jeffrey W · Prairie Grove, ARS/N 001 N823MLLaidlaw Leslie G · Mankato, MNBuilt 2021 · S/N 0049 N823MXEmerald City Aircraft Leasing Inc · Port Orchard, WABuilt 1995 · S/N 2573 N823PPPsm Aviation LLC · Lewes, DEBuilt 1975 · S/N M-1650 N823SSArchipelago Immobilien LLC · Jacksonville Beach, FLBuilt 2000 · S/N 0001 N82405Womack Bert E · Anchorage, AKBuilt 1979 · S/N 18-7909096 N8240NStein Kenneth A · Rapid City, SDBuilt 1969 · S/N 28-25448 N8240PForsgren Keith · Wasilla, AKBuilt 1963 · S/N 18-8045 N8240WGeiger Nathaniel · Omaha, NES/N 28-2383 N8241CL & S Aircraft Holdings LLC · Yukon, OKBuilt 1975 · S/N 28-7690109 N8241WLuckey Jeffrey E · Camarillo, CABuilt 1965 · S/N 28-2385 N8241ZInternational Air Services Inc Trustee · Carson City, NVBuilt 1983 · S/N 28-8316079 N82422Bishop Boyd · Gillette, WYBuilt 1979 · S/N 18-7909098 N82424Skow Perry M · Harrison, IDS/N 18-7709163 N8242NBrezina Douglas P · Broadview, ILBuilt 1969 · S/N 28-25450 N8243EMacon Air LLC · Franklin, NCBuilt 1979 · S/N 17272155 N8243WHill Andrew M · Spokane, WAS/N 28-2389 N82443Dolat Jacqueline M · Kenai, AKBuilt 1977 · S/N 18-7709166 N82448Fejes Guide Service Ltd · Anchorage, AKBuilt 1979 · S/N 18-7909099 N8244PWright Russell · Ocala, FLBuilt 1964 · S/N 24-3499 N8244QAeroplane Co LLC · Sylvania, OHBuilt 1980 · S/N 44-8107011 N8244SExtreme Helicopter Service LLC · Alice, TXBuilt 1994 · S/N 2430 N8244UFaherty Michael F · Greensboro, NCBuilt 1980 · S/N 28-8016371 N8244XDestiny Ministries International Inc · Kissimmee, FLS/N P648R N82452Snyder Matthew A · Tok, AKS/N 18-7809139 N82453Zimmerman Tyler J · Sterling, AKBuilt 1978 · S/N 18-7809179 N8245CVector Aviation LLC · Mentor, OHBuilt 1980 · S/N 28-8090372 N8245NShimei Mark A · Titusville, FLBuilt 1969 · S/N 28-25454 N8245WJ & L Aircraft Rentals Llctrust · Oxford, GABuilt 1965 · S/N 28-2391 N82464Guthrie Richard A · Anchorage, AKBuilt 1978 · S/N 18-7809142 N8246EDubois Aviation Inc · Chino, CABuilt 1982 · S/N 28-8216189 N8246NMorgan Jeffrey P · Mc Veytown, PABuilt 1969 · S/N 28-25455 N82479Cairns Douglas S · Bozeman, MTBuilt 1977 · S/N 18-7709155 N8247NHorizon Edge LLC · Helena, MTBuilt 1969 · S/N 28-25456 N8247WDombrowski Gregory John · Mangum, OKBuilt 1965 · S/N 28-2394 N82481Bickman Jim W · Eagle River, AKBuilt 1978 · S/N 18-7809145 N82486Edwards Hillary M · Katy, TXS/N 18-7709156 N82487Woodruff Thomas C · Pacific Grove, CABuilt 1980 · S/N 28-8116007 N8248NGarcia Leobardo · Tucson, AZBuilt 1969 · S/N 28-25457 N8248TJefferson City Aviation Inc · Jefferson City, MOBuilt 1980 · S/N 28-8116003 N8248YFfrench Lawrence Rene Jr · Austin, TXBuilt 1969 · S/N 5120 N82491Mcmahan Bryan W · Gakona, AKBuilt 1976 · S/N 18-7809180 N82493Gila Aviation Co LLC · Whitefish, MTBuilt 1977 · S/N 18-7709167 N8249BEscobar Alfredo · Canyon Country, CAS/N 28-8116008

Back to AD 80-04-03 R2