Registered aircraft · 25,368

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.

N955LCSewell Michael D DBA · Russellville, ALBuilt 1974 · S/N 17264572 N955MATaylor Christopher B · Vacaville, CABuilt 1966 · S/N 3384 N955PTCappe Investment Group LLC · Homestead, FLBuilt 1974 · S/N 17264573 N955SAMiller David S · Mt Sterling, KYBuilt 2005 · S/N 1383-2005 N955WGReich Stephen B · Kentfield, CABuilt 1978 · S/N P21000185 N95606Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1984 · S/N 15285936 N9560MPontarolo Michael A Trustee · Pacific Grove, CABuilt 1966 · S/N 670137 N9560VRegistration Pending · Big Spring, TXRegistration pendingBuilt 1974 · S/N 17264362 N95615Li LLC · Seattle, WABuilt 1984 · S/N 15285938 N9561GFlying D Aero LLC · Colorado City, TXBuilt 1974 · S/N 18801536T N9561MAck & Co LLC · East Helena, MTBuilt 1967 · S/N 670106 N9561SFerguson Glen P · Cascade, MTS/N 56 N95626Smith Charles · Hays, NCBuilt 1984 · S/N 15285943 N9562BCharleston Flying Club LLC · Charleston, SCBuilt 1981 · S/N 172RG0882 N9562HL & W Aircraft Investments LLC · Homestead, FLBuilt 1975 · S/N 17266230 N9562MPhillips Gary C · Midland, MIBuilt 1966 · S/N 670139 N9562SVon Bevern Brian J · Overland Park, KSBuilt 1966 · S/N 84 N9562VWinged Winds LLC · Douglassville, PABuilt 1974 · S/N 17264364 N95639Barbee Donald · Columbus, OHS/N 15285949 N9563SMumm Paul D · Geneva, NEBuilt 1965 · S/N 337 N9563TStone Michael S · Chamois, MOBuilt 1978 · S/N 38-78A0132 N95646Advantage Aviation Inc · Palo Alto, CABuilt 1985 · S/N 15285951 N9564HLafleur Laurence J · Natick, MABuilt 1975 · S/N 17266232 N9564MCheung Charlotte · San Jose, CABuilt 1966 · S/N 670141 N9564SRegistration Pending · Taylorsville, KYRegistration pendingBuilt 1965 · S/N 7ECA-62 N9565SLittle Lambert W · Hamilton, TXFirst renewal noticeS/N 373 N9566BQualitair LLC · MichelstadtBuilt 1981 · S/N 172RG0885 N9566HGarcia Mario · Yuma, AZBuilt 1975 · S/N 17266233 N9566LNorth Sound Aviation · Sedro Woolley, WABuilt 1986 · S/N 17276578 N9566MRegistered aircraftAssigned, pending cancellationS/N 670143 N9566VS D Enterprises Ltd · Brookhaven, NYBuilt 1974 · S/N 17264368 N95670Board Of Trustees Of Southern Illinois Univ DBA · Murphysboro, ILBuilt 1985 · S/N 15285957 N9567HCurley Mark L · Alamosa, COBuilt 1975 · S/N 17266234 N9567MArrowline Holdings LLC · Brookfield, CTBuilt 1966 · S/N 670144 N9567VBdc Aero LLC · Miami, TXRegistration expired, pending cancellationBuilt 1974 · S/N 17264369 N9568GTakai Hiroyasu · San Jose, CABuilt 1979 · S/N 17273631 N9568LD & S Aviation LLC · Spring, TXBuilt 1986 · S/N 17276580 N9568MKinney William A · Missouri City, TXBuilt 1966 · S/N 670145 N9568VAnderson Zachery D · Bigfork, MTBuilt 1974 · S/N 17264370 N9569HOsborn Larry R · Summerville, SCBuilt 1975 · S/N 17266235 N956DPInfinity Aviation LLC · Comstock, WIBuilt 2021 · S/N 614-2021 N956ERZulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 15282201 N956JWKms Investigations & Consulting LLC · Colleyville, TXBuilt 2021 · S/N 1479-2021 N956MAAllen William D · Tampa, FLBuilt 1966 · S/N 3431 N956RHHuston Ben E · Sanger, TXBuilt 2006 · S/N 510-2007 N956RWTrevitue LLC · San Antonio, TXBuilt 1979 · S/N 38-79A0721 N956WBEd Payne Motors Inc · Weslaco, TXBuilt 1981 · S/N 21064532 N9571HWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266236 N9571MSale Reported · Sacramento, CASale reportedBuilt 1966 · S/N 670148 N9571SShetterly Maxine M · Livingston, TXBuilt 1965 · S/N 7ECA-379

Back to AD 80-25-07 R1