Registered aircraft · 54,017

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-20-03-R2') 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-20-03-R2') 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-20-03-R2')
    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-20-03-R2')
  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-20-03-R2')
  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-20-03-R2')
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.

N338CALincoln Skyways Inc · Lincoln, CABuilt 1978 · S/N 17269465 N338HCapital Holdings Fund IV LLC · Boca Raton, FLBuilt 1982 · S/N 18504343 N338LMSisk Stephen A · Greenville, ILBuilt 1968 · S/N 18259244 N338TLMargolis Michael · Ruskin, FLBuilt 1973 · S/N 33701563 N3390FRodgers Christian Joseph · Ormond Beach, FLS/N 18257390 N3390JVandyke Dennis C · Rose Hill, VABuilt 1967 · S/N 15066090 N3390TTucker Lon R · East Peoria, ILBuilt 1967 · S/N 17700690 N3390YHead John T Jr · Port St Joe, FLS/N 18254390 N3391EOcala Aviation Services Inc · Ocala, FLBuilt 1978 · S/N 17271529 N3391FKingston Terry D · Irving, TXBuilt 1966 · S/N 18257391 N3391TCardinal Wings LLC · Middletown, DEBuilt 1968 · S/N 17700691 N3392DHaszard John R · Ophelia, VABuilt 1955 · S/N 32190 N3393TWilcox Russell J · Salinas, CABuilt 1967 · S/N 17700693 N3394DCartledge Charles J · Orrville, OHBuilt 1955 · S/N 32192 N3394RCurren Patrick V · Green Bay, WIBuilt 1967 · S/N 18258694 N3394TPekrul Eric C · Frankfort, MIBuilt 1968 · S/N 17700694 N3394YNolt Ivan M · Mount Solon, VABuilt 1962 · S/N 18254394 N3395DFitzgerald John A Jr · Ester, AKBuilt 1955 · S/N 32193 N3395JFly N Style · Parkland, FLBuilt 1967 · S/N 15066095 N3395RJohnston Osceola Holdings LLC · Dallas Center, IABuilt 1968 · S/N 18258695 N3395YTriple J Aviation · East Quogue, NYS/N 18254395 N3396FThompson Patrick J · Evanston, WYBuilt 1966 · S/N 18257396 N3396RSimmons Craig · Houston, TXBuilt 1967 · S/N 18258696 N3396VHarvey Christopher J · Port Leyden, NYBuilt 1974 · S/N 15076488 N3396YPlane Fun Inc · Lewes, DEBuilt 1962 · S/N 18254396 N3397FKerns Aaron R · Sullivan, INBuilt 1966 · S/N 18257397 N3397JZwerko Sherri · South Plainfield, NJBuilt 1967 · S/N 15066097 N3397RKcsi Aerial Patrol Inc · Bakersfield, CABuilt 1967 · S/N 18258697 N3397SMcrae Richard · Kent, WABuilt 1969 · S/N 21059197 N3397TMckinney Adrian R · Mineral Wells, TXBuilt 1967 · S/N 17700697 N3398YBobbitt Michael · Lamont, OKBuilt 1962 · S/N 18254398 N3399FVetter T Kevin Trustee · Phoenix, AZBuilt 1966 · S/N 18257399 N3399LMetz William · Laurel, MTS/N 185-1351 N3399RGleason Joseph P · Knoxville, TNBuilt 1967 · S/N 18258699 N3399UWorley Dan J · Perris, CABuilt 1963 · S/N 18254799 N339CHPitch And Power LLC · Indianapolis, INBuilt 1977 · S/N 18265213 N339CPHenley Mark L · Emelle, ALBuilt 1966 · S/N 18257470 N339DGRegistered aircraftS/N P21000434 N339JCNorman Robert Alan · Zanesville, OHBuilt 1973 · S/N 17262119 N339MSMile And A Half High LLC · Sarasota, FLS/N 21062036 N33AGSory Bailey B IV · Bozeman, MTS/N 21061637 N33ATKrebs Bernd R · Sandwich, ILBuilt 1969 · S/N 17258784 N33BBHendricks Timothy J · Telluride, COBuilt 1976 · S/N U20603632 N33CDElliott Kathy · South Thomaston, MEBuilt 1973 · S/N 17260989 N33DBBowers Albert Joseph Jr · Aberdeen, MDBuilt 1970 · S/N 17701451 N33DMGray Chad T · Garden Valley, IDBuilt 1968 · S/N 18259170 N33DPB&C Cejka Real Estate LLC · Sioux City, IABuilt 1967 · S/N 15066465 N33EEDes Moines Skydivers LLC · Des Moines, IABuilt 1969 · S/N 18259998 N33FCReece Trucking And Excavating Inc · Marysville, WAS/N 18501631 N33GCMarble Jere D · Dayton, NVBuilt 1954 · S/N 30913

Back to AD 87-20-03 R2