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.

N8483LChickasha Wings Inc · Chickasha, OKBuilt 1968 · S/N 17256683 N84840Worman Russell L · Enumclaw, WABuilt 1969 · S/N 17258638 N84849Groen Nicki M · Lynden, WABuilt 1969 · S/N 17258641 N84863Pierce Aerospace LLC · Hammond, LABuilt 1969 · S/N 17258644 N8486LPockevich Dave A · Palmer, AKBuilt 1968 · S/N 17256686 N84870Carr James B · Sarita, TXS/N 17258646 N84872Bystedt Lance H · Meridian, CABuilt 1969 · S/N 17258647 N84877N84877 LLC · Fernandina Beach, FLS/N 17258649 N84878Yankton Flyers · Yankton, SDBuilt 1969 · S/N 17258650 N84879Propwash Aviation LLC · Midland, MIBuilt 1969 · S/N 17258651 N84888Harker Rulon J · Enterprise, UTS/N 17258655 N8488LHarrier Aviation LLC · South Saint Paul, MNBuilt 1968 · S/N 17256688 N84891Bohl Robert M · Williamsburg, OHS/N 17258656 N84896An Aircraft LLC · Springfield, MOBuilt 1969 · S/N 17258658 N84897Independent Aviation Services LLC · Sachse, TXBuilt 1970 · S/N 17258659 N84898Coles County Airport Authority · Mattoon, ILBuilt 1969 · S/N 17258660 N8489LBarlow Warren P · Madison, ALBuilt 1968 · S/N 17256689 N848ACOgan Michael J · Pierre, SDBuilt 2024 · S/N 643-2024 N84901Boerne Flight Options LLC · Boerne, TXBuilt 1969 · S/N 17258661 N84907Wang Qiuyuan · Arcadia, CAS/N 17258663 N8490LMgg Aviation 2025 LLC · Annandale, MNBuilt 1968 · S/N 17256690 N8491LDeb Air Inc · Norcross, GABuilt 1968 · S/N 17256691 N8492LCarey Thomas A · Carabaset Vly, MEBuilt 1968 · S/N 17256692 N8493LBriss David S Dmd · Somerset, NJBuilt 1968 · S/N 17256693 N8494LHess Garrett · Fullerton, CABuilt 1968 · S/N 17256694 N8498LWestern Slope Aviators LLC · Delta, COBuilt 1968 · S/N 17256698 N8499LKennedy Christopher S · Canton, ILBuilt 1968 · S/N 17256699 N84ABBald Eagle Aero LLC · Chesapeake, VABuilt 1967 · S/N 670461 N84ACAmerican Champion Aircraft Corp · Rochester, WIS/N 521-2016 N84ATJ Squared Enterprises Corp · Hendersonville, TNBuilt 1980 · S/N 172RG0791 N84DLAirplanes And Helicopters Of Oregon LLC · Sisters, ORBuilt 1979 · S/N 17272771 N84ERDelapp Duncan P · Camino, CABuilt 1981 · S/N 24-1160 N84JDBeving Charles D · Garden City, SDBuilt 1993 · S/N 700-93 N84MKNew Horizons Aviation Inc · Goshen, INBuilt 1977 · S/N 15281230 N84SJLabelle Gregory D Trustee · Newbury Park, CABuilt 1984 · S/N 21064867 N8503Finney Michael E Trustee · Albany, INBuilt 1973 · S/N 910-73 N8505Lunetta Peter Joseph Jr · Niskayuna, NYBuilt 1973 · S/N 69-73 N851DEO'Neal Sean M · Santa Cruz, CABuilt 1980 · S/N R18201494 N851LW578 Airplane Leasing Inc · Kissimmee, FLBuilt 1968 · S/N 17257189 N8526Core Tech Services & Supply LLC · Odessa, FLBuilt 1973 · S/N 449-73 N8528Somerville Billy J · Newport, NCBuilt 1973 · S/N 68-73 N852DAHendrix Rex · Pell City, ALBuilt 1975 · S/N 17264427 N852SDauenhauer Manufacturing Inc · Ketchum, IDBuilt 1978 · S/N P21000081 N8537Kopaska Linda · Guthrie Center, IABuilt 1973 · S/N 452-73 N8541KNoack Kevin L · Oconto, WIS/N 17264513 N8547Carlson Cory R · Trail, MNBuilt 1973 · S/N 914-73 N8548Collum Aviation LLC · Milton, FLBuilt 1973 · S/N 72-73 N8549Koenig Steven T · Ostrander, OHBuilt 1973 · S/N 351-73 N854ACKurchian Aram M · Sunland, CABuilt 1975 · S/N 17265443 N854KMSparrowhawk Aviation LLC · Hollister, CABuilt 1978 · S/N 15282977

Back to AD 80-25-07 R1