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.

N29444Pikula Eric Martin · Brainerd, MNS/N 17700893 N29448Central Virginia Aviation Inc · North Dinwiddie, VABuilt 1968 · S/N 17700894 N29449Brown D W · Wasilla, AKBuilt 1968 · S/N 17700895 N2944LJohnson Tyler Jeffrey · Pensacola, FLBuilt 1967 · S/N 670078 N2944ZCorcoran Brian L · Hampstead, MDS/N 378-78 N29455Heir Richard T · Lambert, MTBuilt 1968 · S/N 17700899 N29459Frana Cody R · Eagle Rock, MOBuilt 1968 · S/N 17700901 N2945LDutko Adam Michael · Elyria, OHBuilt 1967 · S/N 670079 N29462Thomas Stanley L · Thermopolis, WYBuilt 1968 · S/N 17700904 N29467Teel Kevin E · Fallbrook, CAS/N 17700908 N29468Cummings Mark R · Laveen, AZBuilt 1968 · S/N 17700909 N29469Gem Property Investments LLC · San Antonio, TXBuilt 1968 · S/N 17700910 N2946EHigh Wing Air Services LLC · Merritt Island, FLBuilt 1978 · S/N 17271380 N2946LRegistration Pending · Denver, NCRegistration pending, pending cancellationBuilt 1967 · S/N 670080 N29474Leslie Jason · Dayton, OHBuilt 1968 · S/N 17700913 N29479Kozminski Michael J · Caledonia, WIBuilt 1968 · S/N 17700914 N2947LPeoples John Robert Jr · Hixson, TNBuilt 1967 · S/N 670081 N29480Cobra Aviation LLC · Kalispell, MTBuilt 1968 · S/N 17700915 N29481Walle Heidi N · Coarsegold, CABuilt 1968 · S/N 17700916 N29485Lily Anne Aviation LLC · Bad Axe, MIBuilt 1968 · S/N 17700919 N29488Luther Charles A · Walnut Creek, CABuilt 1968 · S/N 17700921 N29495Beaudine Robert J · Westlake Village, CABuilt 1968 · S/N 17700926 N2949LShaker M R · Green Bay, WIS/N 670083 N29509Empty Nest Aviation LLC · Mckinney, TXBuilt 1968 · S/N 17700934 N2950XEagle Sky Patrol Inc · Deadwood, SDBuilt 1967 · S/N 17700350 N29512Heck Jean M · Colorado Springs, COBuilt 1968 · S/N 17700935 N29518Cardinal Aviation LLC · Chambersburg, PAS/N 17700939 N2951GFletcher Flying Service 419 LLC · Labelle, FLBuilt 1967 · S/N 62 N29520Best Equipment Leasing LLC · Bakersfield, CABuilt 1968 · S/N 17700940 N29521Harmon Brian L · Wichita, KSS/N 17700941 N29523Mcgaha Edgar E Jr · Rio Vista, CABuilt 1968 · S/N 17700942 N2952EDayton Michael R · Glen Allen, VABuilt 1978 · S/N 17271382 N29530Rockdale Flying Tigers Inc · Rockdale, TXBuilt 1968 · S/N 17700944 N29531Pell George D · Hillsboro, ORBuilt 1968 · S/N 17700945 N2953829538 Aviation LLC · Fernandina Beach, FLBuilt 1968 · S/N 17700949 N29539Hoosier Fliers LLC · Bloomington, INBuilt 1968 · S/N 17700950 N2953EJensen James A · Madison, WIBuilt 1978 · S/N 17271383 N2953GNolde Norman L · Fayetteville, GABuilt 1967 · S/N 586 N2953XJohnston Daryl T · Euless, TXBuilt 1967 · S/N 17700353 N29548Novelli William L · Orangevale, CABuilt 1968 · S/N 17700956 N2954XWilson Katelyn · Parkville, MOBuilt 1967 · S/N 17700354 N29552Montgomery Skyhawk LLC · Bethesda, MDBuilt 1974 · S/N 17264118 N29554Eagle Sky Patrol · Deadwood, SDBuilt 1968 · S/N 17700960 N29563Brown Winn D Jr · Horn Lake, MSBuilt 1968 · S/N 17700966 N2956LZembower Christopher L · Cumberland, MDBuilt 1967 · S/N 670090 N2956ZAm Flite Inc · Valley, NEBuilt 1978 · S/N 1245-78 N2957LJohnson Cullen L · Abernathy, TXS/N 670091 N29581Bas Part Sales LLC · Greeley, COBuilt 1968 · S/N 17700972 N29584Eagle Sky Patrol Inc · Deadwood, SDBuilt 1968 · S/N 17700974 N29585Ramold Corey M · Gretna, NEBuilt 1968 · S/N 17700975

Back to AD 80-25-07 R1