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.

N404MDDent Thomas E · Moses Lake, WABuilt 1964 · S/N D-7437 N404NEFehlhaber Wolfgang M · Port Orange, FLBuilt 1981 · S/N 404-0857 N404NSJ + D Aviation Services LLC · Centerville, MABuilt 1980 · S/N 402C0421 N404PJPrivate Jet LLC · Miami Springs, FLBuilt 1981 · S/N 402C0513 N404RGJoyner James M · Eagle River, AKS/N 18502702 N404TLBrock Christopher H · Roswell, GABuilt 2004 · S/N 3RX125 N404VDevine Timothy P · Roseville, CABuilt 1962 · S/N D-6981 N404WMArmbruster LLC · Amherst, OHS/N 29-0067 N4051CSky High Ventures LLC · Bartlett, TNBuilt 1980 · S/N 340A0995 N4052BHatter Ronnie · Newcastle, OKBuilt 1976 · S/N 76-30813 N4053BCavenagh Thomas D · Lawton, OKBuilt 1975 · S/N 76-30797 N4054BKing Ronald S Jr · Goldsby, OKBuilt 1976 · S/N 76-30831 N4056SAvery Judy J Executor · Plainfield, ILBuilt 1974 · S/N E-617 N4057BKaler Wayne J · Sayville, NYBuilt 1974 · S/N 75-30739 N4057CAberdeen Flying Service · Aberdeen, SDBuilt 1982 · S/N 414A0848 N4059BLyster Michael · Lake Havasu City, AZBuilt 1975 · S/N 76-30809 N4059SKramer Harvesting LLC · Johnson, KSBuilt 1974 · S/N D-9705 N405CDLbi Aviation Corp · Manahawkin, NJBuilt 2004 · S/N 0944 N405KCS H S Corporation · Indianola, IABuilt 1984 · S/N 46-8408044 N4061SHammerstrand John A · La Mesa, CAS/N E-619 N4062ACessna 310n4062a LLC · Tuscaloosa, ALBuilt 1978 · S/N 310R1362 N4065BTaylor Mitchell · Lodi, CABuilt 1976 · S/N 76-30847 N4065SAlpha 3 LLC · Newcastle, OKBuilt 1975 · S/N TE-1025 N406AHInternational Air Services Inc Trustee · Carson City, NVBuilt 1962 · S/N 185-0442 N406BKN406bk LLC · Nantucket, MABuilt 1984 · S/N 402C0807 N406CConstantine Jeffrey C · Charlotte, NCBuilt 2002 · S/N 0371 N406GAHyannis Air Service Inc · Hyannis, MABuilt 1980 · S/N 402C0329 N406GGCedar Creek Corp · Red Bluff, CABuilt 1967 · S/N 185-1154 N406MHJuliet Yankee Aviation LLC · Greenwich, CTBuilt 1966 · S/N CE-33 N406NWJohnson Aeronautics LLC · Billings, MTBuilt 1981 · S/N 18504244 N406PASale Reported · Rantoul, KSSale reported, canceledBuilt 1982 · S/N TH-1338 N406RCIsland Flights Inc · Wilmington, DEBuilt 1981 · S/N 402C0470 N406TLevel Wings LLC · Jefferson City, MOBuilt 1966 · S/N D-8240 N406WCCebulski Wade E · Seeley Lake, MTBuilt 1964 · S/N D-7723 N4070LDesert Air LLC · Hagerman, NMBuilt 1968 · S/N 421-0070 N4074LEminent Technology · Tallahassee, FLBuilt 1968 · S/N 421-0074 N4074SOverbeck John T · Excelsior, MNFirst renewal noticeBuilt 1975 · S/N CE-554 N4076QSandoval Juan · Valley Stream, NYBuilt 1968 · S/N 401-0176 N4077AFarmer Gary E · Saint Augustine, FLBuilt 1970 · S/N D-9109 N4077SRiedesel Lynn R · Brookings, SDBuilt 1975 · S/N E-638 N4079ABrockhoff Jonathan Allen · Sanford, NCBuilt 1999 · S/N E-3279 N4079CCalled To Care Residential Facility LLC · Avondale, AZBuilt 1978 · S/N 310R1364 N407CBLanham Kelty R · Fresno, CABuilt 1974 · S/N E-511 N407CDKelly George Sumner · Columbus, GABuilt 2004 · S/N 1005 N407DMPhillips Consulting Group Inc · Wilmington, DEBuilt 1990 · S/N EA-507 N407JCPlane Partners LLC · Newton, MABuilt 1982 · S/N E-2033 N407PCOversquare LLC · Norman, OKBuilt 1996 · S/N E-3032 N407RKMoore John C · San Miguel, CABuilt 1968 · S/N 401-0181 N407RSSiddens Tab D · Albany, MOBuilt 1975 · S/N TH-593 N407TVolunteer Aerials LLC · Stanley, NCBuilt 1966 · S/N TE-231

Back to AD 86-13-04 R3