Registered aircraft · 7,563

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

N68504US Liberty Holdings LLC · Caldwell, IDBuilt 1972 · S/N 369-72 N68505Volara Aviation LLC · Glendale, AZS/N 322-72 N68507Gall Peter D · Morgantown, WVS/N 55-72 N68508Williams Houston · Minot, NDBuilt 1972 · S/N 374-72 N68509Luvsflying Flight Training LLC · Staten Island, NYS/N 866-72 N68511Urban Larry D · Conroe, TXBuilt 1972 · S/N 239-72 N68512Ohio Aircraft Refinishing And Repair Inc · Edison, OHBuilt 1972 · S/N 32-72 N68514Twin Cities Aviation Inc · Yuba City, CAS/N 325-72 N68515Gator Flight LLC · Saint Cloud, FLBuilt 1972 · S/N 867-72 N68516Brothers Aviation LLC · Black Rock, ARBuilt 1972 · S/N 54-72 N68517Hanna Kirk · Portland, ORS/N 37-72 N68519King Michelle L · Atlanta, GABuilt 1972 · S/N 240-72 N68521Bowman Eagles Inc · Louisville, KYBuilt 1972 · S/N 244-72 N68522Registration Pending · Anchorage, AKRegistration pendingBuilt 1972 · S/N 864-72 N68525N917az LLC · Miami, FLBuilt 1972 · S/N 871-72 N68526Vapor Global Aviation LLC · Munford, TNBuilt 1972 · S/N 869-72 N68527Morton Jerry D Jr · Dade City, FLBuilt 1972 · S/N 870-72 N68529Jcads Inc · Tampa, FLBuilt 1972 · S/N 59-72 N68531Jts Aircraft LLC · Rock Hill, SCS/N 321-72 N68533Sunrise Aviation Company · Santa Ana, CABuilt 1972 · S/N 873-72 N68536George Mattson Farms Inc · Chester, MTBuilt 1972 · S/N 381-72 N68537Hanson David J · Elgin, TXBuilt 1972 · S/N 382-72 N68538Maneely Roy H · Wadsworth, OHBuilt 1972 · S/N 60-72 N68540Frazee Zachary S · Meridian, IDBuilt 1972 · S/N 383-72 N68541Britt Crop Care Inc · Indianola, MSBuilt 1972 · S/N 384-72 N68543Waltemath Troy A · Augusta, KSBuilt 1972 · S/N 247-72 N68544Small Kevin D · Dallas, TXBuilt 1972 · S/N 248-72 N68545Klamar Spraying Inc · Gatzke, MNBuilt 1972 · S/N 386-72 N68547Seley Ronald J · South Pasadena, CABuilt 1972 · S/N 874-72 N68550Gembala Randall L · Kalispell, MTBuilt 1972 · S/N 388-72 N68553Holmes David D · Spokane, WABuilt 1972 · S/N 389-72 N68564Beck Donald W · Garrison, MTBuilt 1972 · S/N 394-72 N68567Goldbach Charles H · Valleyford, WABuilt 1972 · S/N 395-72 N68570Chmiel John P · Wausau, WIBuilt 1972 · S/N 878-72 N68572Precision Guided Solutions LLC · Sioux Falls, SDBuilt 1972 · S/N 397-72 N68573Etherington Sara L · Belton, MOBuilt 1972 · S/N 327-72 N68574All Attitude Aviation Inc · Edgewater, FLBuilt 1972 · S/N 45-72 N68575Kushner Herbert A · Bridgewater, NJBuilt 1972 · S/N 879-72 N68576Robinson Neil A · Madison, WIBuilt 1972 · S/N 398-72 N68579Schaefer Gerard P · Olive Branch, MSBuilt 1972 · S/N 880-72 N6857STailgate LLC · Felton, GABuilt 1968 · S/N 183 N68588Shipman Jared K · Bismarck, MOS/N 7BCM-254 N68593Dunlap Russell Morgan · Palmer, AKFirst renewal noticeBuilt 1956 · S/N 7BCM-9 N685JWGiurtino Joel F · Spring Hill, FLS/N 868-72 N685SMKendrick Michael L · Rochester, MNBuilt 2025 · S/N 1227-2026 N685TTwist Air Inc · Overland Park, KSBuilt 2022 · S/N 622-2022 N686RWBetancourt Ernest B · Lascassas, TNBuilt 1999 · S/N 1256-98 N689MAN28179 Inc · West Gilgo Beach, NYBuilt 2006 · S/N 506-2006 N68DEMazzoni Dennis · Mays Landing, NJBuilt 1974 · S/N 745-74 N68DGDellar Randy Roger · Wasilla, AKS/N 1208-95

Back to AD 2000-25-02 R1