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.

N5162TAdvanced Insulation Enterprises LLC · Calhoun, LABuilt 1967 · S/N 253 N5162XMcmorries Kyle Patrick · Nacogdoches, TXBuilt 1969 · S/N 691 N5163DHaddix Stanley D · Hagerhill, KYBuilt 1979 · S/N 17272438 N5163THendrickson Duane J · Rocklake, NDBuilt 1967 · S/N 11 N5163UValor View Aviation LLC · Midland, TXS/N 172RG0267 N5163VKopacz Thomas · Glen Flora, WIBuilt 1980 · S/N 172RG0457 N5164EWilliams Kevin J · Giltner, NEBuilt 1978 · S/N 17271746 N5164TLeonard Bruce Danield · Spokane, WABuilt 1966 · S/N 178 N5165BNovember 46a Leasing Inc · St Augustine, FLBuilt 1979 · S/N 15283783 N5165RAvocado Air LLC · Perkasie, PABuilt 1974 · S/N 17263382 N5166RCrown Flying Club · Overland Park, KSBuilt 1974 · S/N 17263383 N5166XRegistered aircraftBuilt 1969 · S/N 185 N51670Colorado Northwestern Community College · Rangely, COBuilt 1980 · S/N 17274336 N5167EJkg LLC · Murfreesboro, TNBuilt 1978 · S/N 17271747 N5167HBest Joseph J · Coldwater, MIBuilt 1975 · S/N 17265357 N5168ATurning Final LLC · Granby, COBuilt 1979 · S/N 21063294 N5168TVrooman Lawrence M · Winterville, NCBuilt 1967 · S/N 12 N5168XCulver Marc D · Anchorage, AKBuilt 1968 · S/N 616 N5169VMalcolm Douglas · Shell Beach, CABuilt 1980 · S/N 172RG0458 N5169XRegistration Pending · Palmer, AKRegistration pendingBuilt 1969 · S/N 676 N516AC39 Victor Aviation Inc · Macomb, ILBuilt 2000 · S/N 1294-2000 N516APStewart Stewart D · South Egremont, MABuilt 1977 · S/N 177-RG-1259 N516AVN388v LLC · Manassas, VABuilt 1981 · S/N 17275205 N516JWAerostar LLC · Newport Beach, CABuilt 1975 · S/N 17265201 N516TGNatchez Flight Training LLC · Natchez, MSBuilt 1977 · S/N 17268889 N51700Brown County Flying Club · Aberdeen, SDBuilt 1980 · S/N 17274338 N5170THardison Aviation LLC · Hampton, SCBuilt 1966 · S/N 527 N5170XFitzpatrick Robert M · Fredericksburg, TXBuilt 1969 · S/N 677 N5171HPan Air Flying Club · Miami, FLBuilt 1975 · S/N 17265358 N5171KBrewer Curtis E · Millington, TNBuilt 1980 · S/N 17273998 N5171RSamuels Jay M · East Tawas, MIBuilt 1974 · S/N 17263388 N5171SHalsted Holdings LLC · Yankton, SDBuilt 1980 · S/N R18201513 N5171TGowins Steven M · Eagle, AKBuilt 1966 · S/N 563 N5171USummers Jeffrey L · Pekin, INBuilt 1980 · S/N 172RG0272 N5172HMsi Fuel Management Inc · Vacaville, CABuilt 1975 · S/N 17265359 N5172TJacksonville Aviation Group LLC · Jacksonville, FLBuilt 1966 · S/N 525 N5172XO'Daniel Mike · Elkhorn, NEBuilt 1969 · S/N 679 N5173TMorris Dennie R · North Fort Myers, FLBuilt 1966 · S/N 545 N5173XInabnit Michael S · Colville, WABuilt 1969 · S/N 680 N51748Planenutz LLC · Deland, FLBuilt 1980 · S/N 17274342 N5174BSky Associates Inc · Jupiter, FLBuilt 1979 · S/N 15283790 N5174EBlue Sky Pilots Inc · Salem, ORBuilt 1978 · S/N 17271752 N5174HFlying Finn Enterprises LLC · Wilmington, DEBuilt 1975 · S/N 17265360 N5174TMarnoch Kenneth S Trustee · Canyon Country, CAS/N 163 N5175EWinston Jacob · Granbury, TXBuilt 1978 · S/N 17271753 N5175TMcclain Timothy J · Tucson, AZBuilt 1966 · S/N 147 N5176RRight Rudder Flight Training LLC · La Verne, CABuilt 1979 · S/N 172RG0044 N5176TScott Judson M · Wasilla, AKBuilt 1967 · S/N 153 N5176VVangorder Donna · Greenwood, ARS/N 172RG0459 N5176XThiel Douglas E · Chowchilla, CAS/N 188

Back to AD 80-25-07 R1