Skip to content

Registered aircraft · 25,369

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.

N152NSNovember Sierra Aviation LLC · Oneill, NES/N 15279673 N152PFTfa Holding Corp · Daytona Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1981 · S/N 15285380 N152PRSantaella Guillermo R · Huntley, ILBuilt 1979 · S/N 15283504 N152PTWiger Theodore L · Falcon Heights, MNBuilt 1977 · S/N 15280065 N152RAIndiana State University · Terre Haute, INS/N 15279562 N152REWings Over Texas Holdings LLC · Denton, TXBuilt 1980 · S/N 15284555 N152SJBonus Kurt W · Wind Lake, WIBuilt 1978 · S/N 15282476 N152SKCade Matt C · Canton, TXS/N 15281404 N152SLAvtech Group LLC · Saint Augustine, FLBuilt 1978 · S/N 15282742 N152SPFogelberg Scot · Stillwater, MNBuilt 1978 · S/N 15282536 N152SQSpartan Education LLC · Tulsa, OKBuilt 1980 · S/N 15284185 N152STMckenney Vernon L · Rodeo, CAFirst renewal noticeS/N 1558 N152TRWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281247 N152UCSkylink Xpress Inc · San Bernardino, CABuilt 1978 · S/N 15281879 N152UFWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15284001 N152WBing Kenneth · Millersport, OHS/N 15282154 N152WAAces High Aviatio LLC · Long Beach, CABuilt 1979 · S/N 15283845 N152WHBecker Steven Hollyfield · New Meadows, IDBuilt 1977 · S/N 15279700 N152XTDiaz Alcides L · Archbald, PABuilt 1979 · S/N A1520907 N1531VOneonone Flight Training LLC · Hagerstown, MDBuilt 1974 · S/N 17263648 N1534EStull Carl · Farmington, UTBuilt 1978 · S/N 17271038 N1534HCooley Norbert · Elkton, MDBuilt 1975 · S/N 177RG0709 N1535HStramer Todd Personal Representative · Hazelton, NDBuilt 1975 · S/N 177RG0710 N1538VEvergreen Flying Club Inc · Medina, WABuilt 1974 · S/N 17263651 N1539EMls Aviation LLC · Yorba Linda, CABuilt 1978 · S/N 17271040 N1539HAve Maria LLC · Batesville, INBuilt 1975 · S/N 177RG0713 N153ACN153ac LLC · Eldon, MOBuilt 1993 · S/N 702-93 N153AMMedford Daniel E · Lakeville, MNS/N 17702222 N153GReese Paul D · Elkview, WVBuilt 2007 · S/N 1039-2007 N153MTMiller Nathan · Irwin, OHBuilt 1978 · S/N 15282694 N153RAWeiner Marc H · Hoboken, NJBuilt 2001 · S/N 1311-2001 N153SKWings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281770 N1540HFurtick Reginald D · Iuka, MSBuilt 1975 · S/N 177RG0714 N1541HAtkin Cris R · St George, UTBuilt 1975 · S/N 177RG0715 N1541UWings Over Texas Holdings LLC · Denton, TXBuilt 1976 · S/N 17267169 N1542HCessna N1542h LLC · Fond Du Lac, WIBuilt 1975 · S/N 177RG0716 N1544EAtlas Aero Training LLC · Casper, WYBuilt 1978 · S/N 17271041 N1544HBaugh Ashton C · Petal, MSBuilt 1975 · S/N 177RG0718 N1545ESlipstream Aviation LLC · Carrollton, GABuilt 1978 · S/N 17271042 N1546VAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17263654 N1548HShrader Brian K · Marion, INBuilt 1975 · S/N 177RG0722 N154JBLevingston Brendan W · Denali Park, AKBuilt 1979 · S/N 15282685 N154RAFulwiler Air LLC · Green Bay, WIBuilt 2005 · S/N 1391-2005 N154SKReign Aviation LLC · Fresno, CABuilt 1978 · S/N 15282110 N154SPSheilds Christopher M · Reading, PABuilt 1992 · S/N 24-3274 N154WKObx Airplanes LLC · Manteo, NCBuilt 1974 · S/N 451-74 N1550EWilts George W · Streator, ILBuilt 1978 · S/N 17271043 N1550VJar Investments LLC · Kalispell, MTBuilt 1974 · S/N 17263655 N1551VBumpe Logistics LLC · South Jordan, UTBuilt 1974 · S/N 17263656 N1552HLewis Daniel Bryce · Waller, TXBuilt 1975 · S/N 177RG0726

Back to AD 80-25-07 R1