Skip to content

Registered aircraft · 25,370

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-07-R1') 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-07-R1') 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-07-R1')
    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-07-R1')
  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-07-R1')
  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-07-R1')
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.

N1668GNewport Signal Air Inc · Anacortes, WAS/N 641 N1668REdwards Air Force Base Aero Club · Edwards Afb, CAFirst renewal noticeBuilt 1978 · S/N R18200505 N1669GTaylor Michael P · East Olympia, WAS/N 642 N166DBStokes Lowell W · Kingwood, TXBuilt 1967 · S/N 276 N166RSThiessen David · Brownsville, TXBuilt 1972 · S/N 876-72 N166XKd Real Estate LLC · Sheridan, WYBuilt 1979 · S/N 24-0914 N1670GKing John D · Midland, VABuilt 1968 · S/N 137 N1672EWichita Area Technical College · Wichita, KSBuilt 1978 · S/N 17271089 N1672GGivens Benjamin T · Ruffin, SCBuilt 1968 · S/N 643 N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507 N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090 N1673GLake Robert F · Mechanicsville, MDBuilt 1968 · S/N 644 N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508 N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709 N1675GKraft Jesse · Twain Harte, CAS/N 130 N1676GCain Landa B · San Diego, CAS/N 131 N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N167BWMartin Jennifer · Palm Desert, CABuilt 1974 · S/N 12475 N167LDRegistered aircraftS/N 670105 N167PCBlue Mountain Flyers Inc · Palmerton, PABuilt 2003 · S/N 1349-2003 N167QQGrondahl Chad R · Peyton, COBuilt 1966 · S/N 670149 N167TCFarzaneh-Far Ramin · Brookline, MABuilt 2001 · S/N 1304-2000 N1680GSears Richard A · Stevensville, MDBuilt 1968 · S/N 135 N1680RSchulze Roger F · Hanford, CABuilt 1978 · S/N R18200512 N1681UMeise Bill · Spring Green, WIBuilt 1982 · S/N 21064725 N1682RDelcamp Don D · Troy, OHBuilt 1978 · S/N R18200513 N1684GMitchell Gary N · Kansas City, KSBuilt 1968 · S/N 139 N1685GBrisson Gisele A · Hollister, CABuilt 1968 · S/N 194 N1686ELiddick Terry S · Spearfish, SDBuilt 1978 · S/N 17271093 N1687GSimon Mitchell B · Edison, NJFirst renewal noticeS/N 196 N1688ERegistered aircraftFirst renewal noticeBuilt 1978 · S/N 17271095 N1688VAvstem Incorporated · Mc Grath, AKBuilt 1974 · S/N 17263714 N168BCWildlife Air LLC · Dubois, WYBuilt 2006 · S/N 482-2006 N168JMMarshall John A · Pacific, MOBuilt 1974 · S/N 457-74 N168SDCometenterprises.Net LLC · Kalispell, MTBuilt 1979 · S/N P21000460 N1690GRansom Bryce P · Richland, ORS/N 75 N1691GPalmer Christopher John · Upper Lake, CABuilt 1968 · S/N 134 N1691NFletcher Flying Service 419 LLC · Labelle, FLBuilt 1972 · S/N 18-72 N1692GSmith Theodore M · Van Buren, MES/N 135 N1693RLeap Aviation Inc · Wilmington, DEBuilt 1978 · S/N R18200518 N1694EAerobiz LLC · Lewes, DEBuilt 1978 · S/N 17271097 N1695GSmith Winston R · Durham, NCBuilt 1968 · S/N 141 N1695RLehne Michael · Portland, ORBuilt 1978 · S/N R18200519 N1696GRives James · Moore Haven, FLBuilt 1968 · S/N 197 N1696RMoore Alan · Glenwood, ARS/N R18200520 N1697GConnell Edward A · Crescent City, FLBuilt 1968 · S/N 581 N1698RRussell Robert Q · Genoa City, WIBuilt 1978 · S/N R18200521 N1699GBeckham Samuel G · Saint Charles, MOBuilt 1968 · S/N 647 N1699RMacdonald Eric J · Belleville, MIBuilt 1978 · S/N R18200522

Back to AD 80-25-07 R1