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.

N4324WWhite River Trucking Inc · Mason, WIBuilt 1974 · S/N TE-966 N4326CSeven Echo Whiskey Corp · Wilmington, DEBuilt 1976 · S/N 340A0075 N432ABWisco Flyers LLC · Middleton, WIBuilt 1987 · S/N CE-1181 N432CBAlltrade Aviation LLC · Fort Branch, INBuilt 2004 · S/N 1175 N432CDVlahos Aviation LLC · Destin, FLBuilt 2004 · S/N 0941 N432DLWhitecotton William W · Eldersburg, MDBuilt 1974 · S/N TH-561 N432DMRegistered aircraftSale reported, pending cancellationBuilt 1971 · S/N 30413 N432FMRegistered aircraftBuilt 2013 · S/N E-4018 N432RADirect Entry Holdings LLC · Port Richey, FLBuilt 1979 · S/N 340A0925 N432ZBaronhawks LLC · Jacksonville, FLBuilt 2010 · S/N TH-2284 N4331ECmb Holdings LLC · Logansport, INBuilt 2000 · S/N E-3331 N4331WRicca Gregory F Trustee · Bentonville, ARBuilt 1974 · S/N TH-436 N4332COdom Douglas · Jay, FLBuilt 1978 · S/N 18803135T N43362Plane Fun Inc Tr Trustee · Snellville, GABuilt 1984 · S/N 46-8408025 N43368Triple 4 Aviation LLC · Martindale, TXBuilt 1984 · S/N 46-8408028 N4336MSouther Field Aviation Inc · Americus, GABuilt 1975 · S/N 18802472T N433BPLeverock Richard C · Port Saint Lucie, FLBuilt 1981 · S/N P21000730 N433CFRotormate LLC · Royse City, TXS/N 0710 N433DReyenga Steven G · Shreveport, LABuilt 1966 · S/N D-8094 N433DNGary Boyce Aircraft Sales LLC · Shelbyville, TNBuilt 1990 · S/N CE-1475 N433KHuffine Kenneth A · Caswell Beach, NCBuilt 1968 · S/N TE-564 N433SBesedin Thomas E · Islandia, NYBuilt 1965 · S/N D-8006 N433TMChristensen Michael S · Mesa, AZBuilt 2002 · S/N 0144 N4340WHanger Aviation Inc · Charleston, SCBuilt 1974 · S/N D-9577 N43412Registered aircraftBuilt 1984 · S/N 46-8408034 N4341NGg And Sg Properties LLC · Seminole, FLBuilt 1984 · S/N 46-8408031 N4342AR&B Air LLC · Clayton, MOBuilt 1970 · S/N D-9133 N4344RCash Doug · Newton, IABuilt 1972 · S/N TE-859 N434CCLambo Air LLC · Springtown, TXBuilt 1982 · S/N EA-321 N434CDFlycarolina LLC · Concord, NCBuilt 2005 · S/N 1514 N434DKOshaughnessy Terrence · Boulder City, NVS/N LIV 419 N434JGGordon Adam Leo · Oakdale, LABuilt 1979 · S/N 18503785 N434LQualitair LLC Trustee · MichelstadtS/N D-8694 N434MGAviation Trust Company LLC · Oklahoma City, OKBuilt 2011 · S/N E-3953 N434RSWestfall Brent J · Three Lakes, WIBuilt 1968 · S/N TE-582 N434TBFlightworks LLC · Crozet, VAS/N 0290 N4354RNoel Laura · Erie, COBuilt 1976 · S/N 18502937 N4356RTailwind Innovations Inc · Overland Park, KSS/N 18502939 N4358MKimt LLC · Iron Mountain, MIBuilt 1984 · S/N 46-8408048 N4358QPeters Nicholas J · Eagle River, AKBuilt 1973 · S/N 18502237 N435CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 0836 N435JMBonanza A36 LLC · Nashville, TNBuilt 1975 · S/N E-762 N435MGonzalez Frank · Sun Valley, CABuilt 1992 · S/N E-2726 N435MCSmoketown Flight Center LLC · Smoketown, PABuilt 1967 · S/N TE-435 N4360VMb Powers Inc · Thompsons Station, TNBuilt 1984 · S/N 46-8408051 N4362WReaume Andrew G · Wayne, PABuilt 1974 · S/N E-557 N4363LVeritas Holdings LLC · Washington, DCBuilt 1984 · S/N 46-8408056 N4363MArk 84 LLC · Wilmington, DES/N 46-8408058 N4364QStotts Boys Aviation LLC · Corcoran, MNBuilt 1973 · S/N 18502239 N4365VPfander Scott J · Litchfield Park, AZBuilt 1972 · S/N 73-30487

Back to AD 86-13-04 R3