Registered aircraft · 18,497

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:86-13-04-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3') 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:86-13-04-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
  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:86-13-04-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:86-13-04-R3')
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.

N6657ZVas Incorporated · Reston, VABuilt 1979 · S/N CE-874 N66585Haines Jay A · Summerland Key, FLBuilt 1983 · S/N EA-353 N6658DThietten Gary L Trustee · Washington, UTBuilt 1979 · S/N D-10312 N6658KEdelman Freddie L · Manlius, NYBuilt 1979 · S/N D-10278 N6658SKgb58 Aviation LLC · Gibsonia, PAS/N TH-681 N6658ZClark Lloyd E · Hanover, MDBuilt 1979 · S/N TJ-222 N6659GGallentine Gene W · Clayton, KSBuilt 1979 · S/N CE-876 N6659LControl Data Inc · Indianapolis, INBuilt 1979 · S/N D-10279 N665JTN665jt LLC · Shoreline, WABuilt 1974 · S/N TE-990 N665LFStandridge Color Corp · Social Circle, GABuilt 2008 · S/N TH2233 N665SCGold Star Beacon LLC · Sarasota, FLBuilt 1975 · S/N 340A0006 N66619West Bend Air Inc · West Bend, WIBuilt 1979 · S/N TH-1070 N6661NSmith Joel L · Cedar Park, TXBuilt 1978 · S/N 21063137 N6661YSchlosser David · Scottsdale, AZBuilt 1979 · S/N TH-1068 N6662HIrwin Dennis · San Diego, CABuilt 1979 · S/N D-10290 N6662NRegistration Pending · Uvalde, TXRegistration pendingS/N TH-1073 N6662TSeipp Edwin A III · Portola Valley, CABuilt 1979 · S/N D-10284 N6662VOlson Larry L · Timmonsville, SCBuilt 1967 · S/N 30026 N66648Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1979 · S/N D10289 N6664LTt Aviation LLC · Oxnard, CABuilt 1979 · S/N EA-20 N6665VBetts Miley F · Highlands Ranch, COBuilt 1967 · S/N 30035 N6665WIal Corp · Lewes, DEBuilt 1979 · S/N TJ-227 N6665ZDunkley Music Inc · Meridian, IDBuilt 1979 · S/N D-10291 N6666XBlack Sheep Aviation LLC · Palm City, FLBuilt 1979 · S/N TH-1093 N6667NSmith William F · Hindsville, ARBuilt 1978 · S/N 21063141 N6668QRegistered aircraftBuilt 1983 · S/N E-2077 N6669BConstantia Group LLC · Green Cove Springs, FLBuilt 1978 · S/N 21062814 N6669XEdm-Van LLC · Maple Lake, MNBuilt 1979 · S/N TK-108 N666CNHamon John · Paso Robles, CABuilt 1979 · S/N E-1470 N666CPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1985 · S/N 46-8508080 N666JBCopenhaver Tracy K · Anthony, KSBuilt 1973 · S/N 18801427 N666MSSandy Bayou Planting Co · Osceola, ARBuilt 1969 · S/N D-9004 N666RREllis James F · Culver City, CAFirst renewal noticeBuilt 1973 · S/N 74-30632 N666RSLoney James A Trustee · West Chesterfield, NHBuilt 1979 · S/N 79-30936 N666SBBredin Robert R · Pacific Palisades, CABuilt 1980 · S/N 18503994 N666WFFehlhaber Wolfgang M · Port Orange, FLBuilt 1976 · S/N D-9885 N6670GSterling Park Corp · Ashland, KYBuilt 1979 · S/N EA-26 N6670JMccracken Scott D · Maysville, OKBuilt 1979 · S/N D-10295 N6670VCollum Aviation LLC · Milton, FLS/N 30021 N6670ZMortan Robert F · Mckinney, TXBuilt 1979 · S/N E-1585 N66719Dusch William C · Concord, NCBuilt 1983 · S/N E-2078 N6671DGruber Mark W · Edmond, OKBuilt 1979 · S/N E-1613 N6671LArias Aviation Inc · Wilmington, DEBuilt 1983 · S/N E-2079 N6671XDairy Air LLC · Mount Crawford, VABuilt 1979 · S/N TH-1077 N66722Lumpkin Ed · Rosie, ARS/N E-2081 N6672BYour World Inc · Draper, UTBuilt 1979 · S/N E-1584 N6672CBayview Direct LLC · Dover, DEBuilt 1978 · S/N 414A0053 N6672KMaremy LLC · Ramona, CABuilt 1979 · S/N E-1564 N6674CAire Tracks Corp · Wilmington, DEBuilt 1980 · S/N 335-0058 N6675ATool Equipment Leasing Corporation · Bethany, OKBuilt 1979 · S/N EA-30

Back to AD 86-13-04 R3