Registered aircraft · 40,394

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

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 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 N8249NAero Club Aviation LLC · Apollo Beach, FLBuilt 1969 · S/N 28-25459 N8249WHartpence Damian K · Newcastle, OKBuilt 1965 · S/N 28-2397 N824DXElon Aviation LLC · Burlington, NCBuilt 1978 · S/N 28-7990061 N824GEaa Aviation Foundation Inc · Oshkosh, WIBuilt 1994 · S/N 01-P N824JTRenfro Jacqueline L · Bethel, AKBuilt 1957 · S/N 18-6040 N824PAHot Wings Aviation LLC · Indianapolis, INBuilt 2020 · S/N 2881336

Back to AD 79-10-03 R2