Skip to content

Registered aircraft · 6,349

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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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-25-02-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.

N6637RSchawang Darrin E · Falls City, NES/N WA-35 N6638LNewby Danny A · Mc Leansville, NCBuilt 1979 · S/N WA-37 N6638WTugmon Danny · Locust Grove, OKBuilt 1965 · S/N 28-20737 N663BFFoster Robert B · Erie, PABuilt 2017 · S/N 034 N66512Capp Sam · Juneau, AKBuilt 1942 · S/N 51426 N66545Mcclellion William R III · Anderson, SCBuilt 1942 · S/N 5-1416 N66603Bosco Gina · Caldwell, IDBuilt 1978 · S/N 15281662 N666YZDon Jones Inc · Orange Beach, ALBuilt 1969 · S/N AA1-0290 N66931Laguna Verde Leasing Inc · Wilmington, DES/N 15281668 N66941Blue Mountain Airways LLC · Woodstock, GABuilt 1978 · S/N 15281676 N66946Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15281681 N66948Kuriger Michael R · Santa Clarita, CABuilt 1978 · S/N 15281683 N66954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281689 N66970California Airways LLC · Hayward, CABuilt 1978 · S/N 15281696 N66971Meridian Airport Authority · Meridian, MSBuilt 1978 · S/N 15281697 N66977Unique Educational Experiences · Signal Hill, CABuilt 1978 · S/N 15281699 N669AMForry Anthony · Athens, TNBuilt 2003 · S/N 20-1025 N669NEAcme Aircraft Flying Club LLC · Kalispell, MTBuilt 1981 · S/N 15285368 N669PMKohl Rex · Eden Prairie, MNBuilt 2015 · S/N 1161 N669XDiehl Steven K · Homestead, FLBuilt 1966 · S/N 68 N66AZVia International Inc · Reunion, FLBuilt 1995 · S/N 11221 N66JMRussman Nicholas S · Farmersville, TXBuilt 1981 · S/N 15285251 N6707MLouis & Clark Aviation LLC · Fort Myers, FLBuilt 1979 · S/N WA-48 N6708XBaumbach James P · Lodi, CABuilt 1979 · S/N WA-53 N6709LBowlin Frank J · Santa Fe, NMBuilt 1979 · S/N WA-56 N6711RAme Flight Holdings LLC · Oasis, IDBuilt 1979 · S/N WA-60 N6713VMclendon Donnie E · Winder, GABuilt 1979 · S/N WA-61 N6715VByrds Wholesale Inc · Clayton, NCS/N WA-70 N6715YTrevitue LLC · Dripping Springs, TXS/N WA-65 N67169Arai Eisuke · San Jose, CABuilt 1979 · S/N WA-67 N6716SShelby Monroe Group LLC · Sioux City, IABuilt 1979 · S/N WA-71 N6718RVernier Deborah J · Goshen, KYBuilt 1980 · S/N WA-76 N6719VDaniel Scott · Kingston, GABuilt 1980 · S/N WA-81 N67201Sale Reported · Sunman, INSale reportedBuilt 1980 · S/N WA-111 N67217Pompano Hangars Inc · Lighthouse Point, FLBuilt 1980 · S/N WA-91 N6721VNoll Brent M · Burbank, CABuilt 1980 · S/N WA-89 N6722NShipman Jesse L · Honey Grove, TXBuilt 1968 · S/N 680177 N67282Grandy Boyd · Arcadia, CABuilt 1978 · S/N 15281722 N67286Mars Aerospace Inc · Bay Shore, NYBuilt 1978 · S/N 15281725 N67289Cosklo Ronald J · Fell Township, PABuilt 1981 · S/N 15285291 N67292Mock Joseph R · Huntsville, TXBuilt 1978 · S/N 15281728 N67300Florida Flight Training Center Inc · Venice, FLBuilt 1978 · S/N 15281732 N67303Walden Taylor G · Pueblo, COBuilt 1978 · S/N 15281735 N67306Dagenais David W · Keystone Heights, FLBuilt 1978 · S/N 15281738 N67307Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281739 N6730WPrucha Derek L · Hideaway, TXBuilt 1965 · S/N 28-20846 N67314Wisconsin Aviation Inc · Watertown, WIBuilt 1978 · S/N 15281746 N67322West Valley Flying Club · Palo Alto, CABuilt 1981 · S/N 15285294 N67324Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281755 N67329Kropp Christian Trustee · Azle, TXBuilt 1978 · S/N 15281758

Back to AD 80-25-02 R2