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.

N3642MCraig James P · Jacksonville, ARBuilt 1947 · S/N 12-2497 N3642PSkyranch Knoxville Youth Inc · Knoxville, TNBuilt 1955 · S/N 22-3393 N3642QPorte Elvis · Miami, FLS/N MB-262 N3642WMasia Matt D · Paso Robles, CABuilt 1966 · S/N 32-545 N36434Phillips Aaron W · Fort Scott, KSBuilt 1973 · S/N 275-73 N36438Dorman Richard E · Mesa, WABuilt 1973 · S/N 577-73 N3643DNevins Robert · North Palm Beach, FLBuilt 1981 · S/N 6008358161238 N3643MKing Jay M · King Salmon, AKS/N 12-2496 N3643NHoward Trae · San Antonio, TXBuilt 1967 · S/N 680023 N3643TBds Flyer LLC · Middletown, DEBuilt 1981 · S/N 6008998161255 N3643XBurbey Mark G · Racine, WIS/N 301 N3644KDraheim Allan C · Lagrange, GABuilt 1967 · S/N 28-23663 N3644PHanselmann Seth · Lincoln, VTFirst renewal noticeBuilt 1955 · S/N 22-3395 N3644RRegistration Pending · Sarasota, FLRegistration pendingBuilt 1969 · S/N 28-5742 N36456Charles Ho Consultants LLC · Beverly, MABuilt 1978 · S/N 28-7890516 N3645WDodson International Parts Inc · Rantoul, KSBuilt 1966 · S/N 32-549 N3645XAubrey James M · North Little Rock, ARBuilt 1968 · S/N 302 N3646063nl LLC · Willmar, MNBuilt 1981 · S/N 62P09008165029 N36463S&D Adventures LLC · Saint George, UTBuilt 1978 · S/N 32R-7887044 N3646HAdams Toby R · Paris, TXBuilt 1980 · S/N 6008568161245 N3646KParrish Doug · Monument, COBuilt 1981 · S/N 61P08578163453 N3646PMr Group · Rapid City, SDS/N 6108598162155 N3646WWap Air LLC · Newburgh, INBuilt 1966 · S/N 32-550 N36470Proctor Charles H · Conroe, TXBuilt 1978 · S/N 28-7890518 N3647KRayman Bethany A · Salem, SDS/N 28-23666 N3647PHubbard Robert Thomas · Atlanta, GABuilt 1955 · S/N 22-3398 N3647RRegistration Pending · Indianapolis, INRegistration pendingBuilt 1970 · S/N 28-5744 N3647WNichols Robert H Jr · Normandy, TNBuilt 1966 · S/N 32-551 N3648BMcgill Aviation Inc · Greensboro, GABuilt 1981 · S/N 62P08668165006 N3648KBonanno John W · Oceanside, NYBuilt 1967 · S/N 28-23667 N3648QRegistration Pending · Graham, WARegistration pendingBuilt 1967 · S/N MA-233 N3648ZMow The Sky LLC · Midway, UTBuilt 1960 · S/N 22-7545 N3649151st Aero Squadron LLC · Hoover, ALBuilt 1978 · S/N 28-7890519 N3649PHelmer Daniel W · Eagle, AKBuilt 1955 · S/N 22-3400 N3649QSteinberg Stephen M · Happy Valley, ORBuilt 1967 · S/N MA-234 N3649RCummings Jason M · San Rafael, CABuilt 1969 · S/N 28-5746 N3649WTurbo Six LLC · Wilmington, DEBuilt 1966 · S/N 32-554 N364AGPeregrine Howard Aeroflight Owner LLC · New Orleans, LABuilt 2025 · S/N 2881990 N364BTFlying B Land And Timber Co LLC · Pineville, LABuilt 2013 · S/N 25621 N364CKSchneider William J Jr · Cedar Key, FLS/N 17260354 N364DMMoon David A · Valkaria, FLS/N 1001 N364FSN927nw LLC · Watchung, NJBuilt 2000 · S/N 23065C N364GSpruce Creek Consultants LLC · Port Orange, FLBuilt 1972 · S/N 17701776 N364HKoberg Lance L · Dallas, GABuilt 1974 · S/N 364 N364MNakamura Hajime Trustee · Long Beach, CAS/N 0364 N364MCLesser Antilles Corp Trustee · Wilmington, DEBuilt 1973 · S/N 32-7300039 N364MGCw Aviation LLC · Washta, IABuilt 1979 · S/N R18201246 N364MKNorth Star Aviation Inc · Mankato, MNBuilt 2023 · S/N 2881654 N364MSSkyhawk Aviation LLC · Omaha, NEBuilt 1997 · S/N 17280015 N364SLRegistration Pending · Carmel, CARegistration pendingBuilt 1980 · S/N 1011

Back to AD 87-10-06 R1