Registered aircraft · 72,010

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.

N39569Jayo LLC · Winston Salem, NCBuilt 1978 · S/N 32-7840167 N3956MNew England Aviation LLC · Plainville, CTBuilt 1978 · S/N 28-7816390 N3956PWheels Up LLC · Evansville, INBuilt 1956 · S/N 22-3634 N3956RSobczak Joseph E · Groveland, CABuilt 1970 · S/N 28-7105061 N3956XHuth William L · Gulf Breeze, FLBuilt 1975 · S/N 28R-7535366 N39577Environmental Management Specialists Inc · Huntertown, INBuilt 1978 · S/N 32R-7887111 N3957FSeipp Stephen C · Laurel, DEBuilt 1976 · S/N 28R-7635392 N3957QRwm Aviation LLC · Kalispell, MTBuilt 1971 · S/N 17260057 N3957RHaushold Aviation LLC · Shelbyville, TNBuilt 1970 · S/N 28-7105062 N3957WPorter Casey · Bluffton, SCBuilt 1967 · S/N 32-906 N3957ZAlsworth Leon R · Port Alsworth, AKBuilt 1962 · S/N 18-7818 N3958KArias Benjamin H · Fort Stockton, TXBuilt 1967 · S/N 28-23837 N3958PHoward Kevin B · Plymouth, MIBuilt 1956 · S/N 22-3636 N3958QFisher Gregory S · Franklin, WIBuilt 1971 · S/N 17260058 N3958TPiowaty Craig M · Hilo, HIBuilt 1967 · S/N 28R-30303 N3958ZWelstad Blaine L · Newburg, NDBuilt 1962 · S/N 18-7819 N3959KPuertola Pascual G · Cobb, CAS/N 28-23838 N3959RBederov Alex · Redwood City, CABuilt 1970 · S/N 28-7105064 N3959XCavanaugh Brian L · Manitowoc, WIBuilt 1975 · S/N 28-7625001 N3959ZDld Corp · Ogden, UTBuilt 1962 · S/N 18-7821 N395DNational Training 1 LLC · Wilmington, DEBuilt 2016 · S/N 2843859 N395HPGarza David Javier · Mcallen, TXBuilt 1994 · S/N 3213085 N395HZPilot In Command LLC · Parker, COBuilt 1992 · S/N 492 N395JPKane Aviation LLC · Salem, VABuilt 2004 · S/N 40.410 N395LAZapel Theodore O · Colorado Springs, COBuilt 1967 · S/N 28-23836 N395MAEzelle Stephen · Savannah, GABuilt 1995 · S/N 2811044 N395MEYqa Capital Management LLC · Murfreesboro, TNBuilt 2000 · S/N T20608233 N395MTCubi Erik O · Chicopee, MABuilt 1967 · S/N 28-23834 N395PMBare Bones Aircraft Inc · Fort Walton Beach, FLBuilt 1995 · S/N 4622195 N395SPTexas State Technical College · Waco, TXBuilt 1999 · S/N 172S8292 N395TCAqz Aviation Inc Trustee · Wilmington, DEBuilt 1995 · S/N 20003 N395THChristiansen Aviation LLC · Wilmington, DEBuilt 1980 · S/N 17274174 N395XRegistration Pending · Marion, MTRegistration pending, pending cancellationBuilt 1976 · S/N 7037C N39600Inlet Shores Aviation LLC · Ponce Inlet, FLBuilt 1978 · S/N 32-7840169 N39603Bauer Jay A · Carrington, NDBuilt 1978 · S/N 32R-7887119 N39609G Medical LLC · Cedar Falls, IABuilt 1978 · S/N 28-7890542 N3960KRegistration Pending · Roanoke, TXRegistration pendingBuilt 1967 · S/N 28-23839 N3960MBales Gregory W · Enterprise, ORBuilt 1947 · S/N 12-2843 N3960QLastochka LLC · Kalispell, MTBuilt 1971 · S/N 17260060 N3960RLong William R · Jackson, TNBuilt 1971 · S/N 28-7105065 N3960TThompson Jerry C · Goldsboro, NCBuilt 1968 · S/N 28R-30305 N3960WTaylor Ryan · Lakeland, FLBuilt 1967 · S/N 32-939 N39610Archer Aviation LLC · Pittsburg, KSBuilt 1978 · S/N 28-7890543 N39613Ferrando James P · San Pedro, CABuilt 1978 · S/N 32-7840170 N39619Harclerode David A · Colorado Springs, COBuilt 1978 · S/N 32R-7887122 N3961MBluebird Aviation LLC · Bismarck, NDBuilt 1978 · S/N 28-7816392 N3961PMcquivey David · St George, UTS/N 22-3639 N3961RWhite Lightning 3961r LLC · Chandler, AZBuilt 1971 · S/N 28-7105066 N3961TMartin Noah R · Newcastle, CABuilt 1967 · S/N 28R-30306 N39621Zulu Aircraft Leasing LLC · Grants Pass, ORBuilt 1978 · S/N 44-7995016

Back to AD 87-10-06 R1