Registered aircraft · 72,007

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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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:87-10-06-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.

N3400WTop Flight Aircraft Holdings LLC · Dover, DEBuilt 1966 · S/N 32-261 N3400ZHojnacki Frank · Hobart, INBuilt 1960 · S/N 22-7311 N34011Cross Charles W Jr · Willoughby, OHBuilt 1970 · S/N 17701594 N34012Cap Flyers Aero Club LLC · Ocala, FLBuilt 1970 · S/N 17701595 N34015Leftwich Brian · Savannah, GABuilt 1970 · S/N 17701597 N34019Kortum Ronald L · Williamstown, NJBuilt 1970 · S/N 17701599 N3401WAerial Crop Protection Inc · Belle Glade, FLBuilt 1954 · S/N 18-4064 N34029Rigdon William K · Hazel Green, WIBuilt 1970 · S/N 17701605 N3402WCw Baker Investments LLC · Baton Rouge, LABuilt 1965 · S/N 32-262 N34038B&B Cardinal LLC · Alexandria, VABuilt 1970 · S/N 17701608 N3403PCarper Ryan W · Marietta, OHBuilt 1958 · S/N 23-1367 N3403WSchendel Daryl R · Barstow, CABuilt 1965 · S/N 32-264 N3403XWenkman Michael J · Madison, WIBuilt 1966 · S/N 1108 N3403ZCharpie Mark E · Ottawa Lake, MIBuilt 1960 · S/N 22-7314 N34041Lange Charles A · Portageville, MOBuilt 1970 · S/N 17701610 N34043Wrg Flyers LLC · Denver, COBuilt 1970 · S/N 17701611 N34045Ackerman Mark R · Box Elder, SDBuilt 1970 · S/N 17701612 N34049Osetek James · Harbor Springs, MIBuilt 1971 · S/N 17701616 N3404THaik Kevin Jerome · Ozark, MOS/N 17700704 N3404XAero Nautical Electronics Inc · Starke, FLBuilt 1966 · S/N 1109 N3404ZDevils Lake Aero Repair Inc · Devils Lake, NDBuilt 1960 · S/N 22-7315 N34052Bauerle William L · Imperial, NEBuilt 1971 · S/N 17701617 N3405FGo Up High LLC · Grafton, WIBuilt 1967 · S/N 17700602 N3405XMurray Lacounte O · Leander, TXBuilt 1966 · S/N 3391 N3405ZHeinrich Steven A · Corvallis, ORBuilt 1960 · S/N 22-7317 N34064Kupka John J · Okeechobee, FLBuilt 1971 · S/N 17701622 N3406A406a Inc · Hollywood, FLS/N 3257044 N3406WQwikflights LLC · Herriman, UTBuilt 1965 · S/N 32-267 N3406XThuerauf John E · Plum City, WIBuilt 1966 · S/N 3392 N3407WYounkin Anthony · Ruffs Dale, PABuilt 1966 · S/N 32-299 N3407XAerodrome Aviation LLC · Brighton, COBuilt 1966 · S/N 1110 N3407ZBug Smashers LLC · Winfield, KSS/N 22-7319 N3408TSpectron Aviation Inc · West Boylston, MAS/N 17700708 N3408XHeid Jason A · Crystal, MNBuilt 1966 · S/N 1111 N34097Brennan Benjamin M · Pensacola, FLBuilt 1971 · S/N 17701638 N34099Nehrbass Daniel · Santa Ana, CABuilt 1971 · S/N 17701639 N3409MBelleau Clifford D · Anchorage, AKBuilt 1947 · S/N 12-2260 N3409NSchaffhauser Daniel · Garland, TXBuilt 1967 · S/N 680042 N340ACMajor Travis S · Phoenix, AZBuilt 2003 · S/N 1340-2003 N340BFRegistration Pending · Simi Valley, CARegistration pending, pending cancellationBuilt 2003 · S/N 6055 N340BGBowling Green Flight Center LLC · Bowling Green, OHBuilt 2022 · S/N 2881526 N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228 N340HPBeartooth Aviation LLC · Kalispell, MTBuilt 2000 · S/N 18280889 N340MASoar Aviation LLC · Rllng Hls Est, CABuilt 2001 · S/N 27-0314 N340MCConrardy Michael Victor · San Jose, CABuilt 2026 · S/N 4102 N340PAVidal Aviation LLC · Gaithersburg, MDBuilt 2002 · S/N 2843516 N340PSPowell Lester E Jr · Savannah, GAS/N 5338 N340XLMoppert Robert C · Berryville, ARBuilt 2005 · S/N R3X010 N34101Aldrich Andrew J · Soulsbyville, CABuilt 1971 · S/N 17701641 N34102Jaquez Marlene D · Baton Rouge, LABuilt 1971 · S/N 17701642

Back to AD 87-10-06 R1