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.

N2523BJenny Joe S · Fresno, CABuilt 1978 · S/N 38-79A0107 N2523FCavin Dale L · Marianna, FLBuilt 1965 · S/N 143 N2523ZBchr Aviation LLC · Boerne, TXBuilt 1977 · S/N 337-77 N2524FWilkins Shelley A · Claremore, OKBuilt 1966 · S/N 72 N2524ZEgan Brian M · Saint Charles, ILBuilt 1977 · S/N 338-77 N25252Scott Wilson A · Norman, OKBuilt 1980 · S/N 38-80A0005 N25255Flm Aviation LLC · Vernal, UTBuilt 1977 · S/N 15280556 N2525BOn Course LLC · Saint Charles, MOBuilt 1978 · S/N 38-79A0108 N2525FGarbani Jacob R · Caldwell, IDBuilt 1966 · S/N 419 N2525SJbird Aviation LLC · Elizabeth City, NCBuilt 2025 · S/N 1225-2025 N25265My Toys Inc · Spartanburg, SCS/N 15280561 N25269Yankaskas Kurt D · Ijamsville, MDBuilt 1977 · S/N 15280563 N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347 N25271Byrnes Daniel P · Anchorage, AKS/N 15280564 N2527FHightower Marc S · Sevierville, TNBuilt 1965 · S/N 147 N25284Riverside Flight Center Inc · Tulsa, OKBuilt 1977 · S/N 15280572 N25286Recreational Enterprises LLC · Sanford, FLS/N 15280573 N25287Greenwood John R · Bellevue, NEBuilt 1980 · S/N 38-80A0107 N2528BMankowski Luke Ray · Granbury, TXBuilt 1978 · S/N 38-79A0110 N2529FEvanson Scot A · Monroe, TNBuilt 1965 · S/N 149 N2529VPiper Aircraft Inc · Vero Beach, FLS/N 38-82A0074 N252ERBeaurayne Holdings LLC · Prairieville, LABuilt 1978 · S/N 17271635 N252MTAero Quest LLC · Olive Branch, MSBuilt 1977 · S/N 15280407 N252RAReynolds Darryl G · Wills Point, TXBuilt 1977 · S/N 17269911 N252SBRoberts Christopher E · Anchorage, AKS/N 17270764 N252SWSymns Robert A · Aguila, AZBuilt 1978 · S/N 21063029 N252TTRex Ron · Ocala, FLBuilt 2015 · S/N 1208 N252WCMosier Paul L · Ventura, CABuilt 1979 · S/N 15284145 N25301Southern Arkansas University Technical Branch · Camden, ARBuilt 1977 · S/N 15280581 N25302Steiner Jason A · Sabetha, KSBuilt 1977 · S/N 15280582 N2530NGibbs Robert I · Ravenswood, WVBuilt 1979 · S/N 38-79A0899 N2530VAnderson Jeffrey L · Harrisburg, SDBuilt 1974 · S/N 177RG0604 N2531ATyler Jeffery Jack · Anchor Point, AKBuilt 1978 · S/N 38-78A0735 N2531FFishwick Steve K · Hamilton, OHBuilt 1966 · S/N 22 N25325Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280596 N2532FQuinn Michael A · Ruby, AKBuilt 1965 · S/N 154 N25332Ewing John L Jr · Yuma, AZBuilt 1977 · S/N 15280600 N2533FMacdonald Craig R · Sonoma, CABuilt 1965 · S/N 155 N2533VHasselvander Brian K · Columbia, MSBuilt 1974 · S/N 177RG0605 N25340Resetich Michael J · Gravois Mills, MOBuilt 1980 · S/N 38-80A0111 N2534FCentral Virginia Aviation Inc · North Dinwiddie, VAS/N 7ECA-156 N25351Russell Robert Q · Genoa City, WIBuilt 1977 · S/N 15280609 N25357Jameson George T · Auburn, MABuilt 1977 · S/N 15280612 N25359Kelly John M · Gastonia, NCBuilt 1977 · S/N 15280614 N2535FBryan Michael R · Brownfield, TXBuilt 1965 · S/N 7GCAA-33 N2535VRegistration Pending · Fort Worth, TXRegistration pendingBuilt 1974 · S/N 177RG0606 N25362Sunrise Aviation Inc · Ormond Beach, FLBuilt 1977 · S/N 15280616 N2536AA & J Air Sales Inc · San Antonio, TXBuilt 1978 · S/N 38-78A0739 N2536ZLemanski Thomas A · Port Townsend, WAS/N 1250-78 N2537DBurdette William E · Corpus Christi, TXBuilt 1978 · S/N 38-79A0359

Back to AD 80-25-07 R1