Skip to content

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.

N346BJDixon Craig S · Rimrock, AZBuilt 1967 · S/N 15066160 N346CBKombi Brazil Inc · Fort Lauderdale, FLS/N 21060712 N346RNSchroll Charles E · Tucson, AZBuilt 1969 · S/N P206-0567 N34700Jenner Stephen R · Dunnellon, FLBuilt 1976 · S/N 177RG1013 N34701Spirit Of St Louis Flying Club Inc · Chesterfield, MOBuilt 1973 · S/N 17701945 N34707Swanborg Valerie · Wausau, WIBuilt 1973 · S/N 17701946 N34708Ebner Raymond J III · Middleburg Heights, OHBuilt 1973 · S/N 17701947 N34709Neal Randall C · Lincoln City, ORBuilt 1973 · S/N 17701948 N3470CMoorhead Equipment LLC · Belton, SCBuilt 1954 · S/N 26513 N3470JEdson Vincent · Auburn, CAS/N 15066170 N3470TPorte Elvis · Miami, FLFirst renewal noticeBuilt 1968 · S/N 17700770 N3470UThird Loop Partners · Paso Robles, CABuilt 1963 · S/N 18254870 N34710Warden Leonard D · Anacortes, WABuilt 1973 · S/N 17701949 N34717Schwenker Richard L · Maquoketa, IABuilt 1973 · S/N 17701955 N3471FDel Norte Flying LLC · Del Norte, COBuilt 1966 · S/N 18257471 N3471JLogtime Flight LLC · Lancaster, TXBuilt 1967 · S/N 15066171 N3471SClint Woodword Construction LLC · Prineville, ORBuilt 1964 · S/N 18255871 N34720Bulls Eye Trading LLC · Bethany, MOBuilt 1973 · S/N 17701957 N34723Pulliam Donald Edward · Wake Forest, NCBuilt 1973 · S/N 17701960 N34727Valley Fliers Flying Club · Auburn, WABuilt 1973 · S/N 17701962 N34728Deleon Joseph M · Saint Petersburg, FLBuilt 1973 · S/N 17701963 N34729Registered aircraftBuilt 1973 · S/N 17701964 N3472CTotal Tailwheel LLC · Weston, MABuilt 1954 · S/N 26515 N3472DHill Kevin James · Aurora, MNS/N 27015 N3472FMiller Robert F · Locust Grove, GAS/N 18257472 N34731Edenhoffer Peter J · Paris, TXBuilt 1973 · S/N 17701965 N34732Kohles Terrance · Portsmouth, IABuilt 1973 · S/N 17701966 N34735Stramer Todd Personal Representative · Hazelton, NDBuilt 1973 · S/N 17701968 N34737Seareylife LLC · Orlando, FLBuilt 1973 · S/N 17701969 N34739Flying Pterodactyl LLC · Sarasota, FLBuilt 1973 · S/N 17701971 N3473CKubecka Donald P · Seminole, TXS/N 18051760 N3473FBoone Bruce L · Woodland, CAS/N 18257473 N3473RBrooks Gregory Keith · Green Cove Springs, FLBuilt 1967 · S/N 18258773 N3473WGades Gary A · Montevideo, MNBuilt 1980 · S/N 18504080 N34743Rogers Ronald · Olney, TXFirst renewal noticeBuilt 1973 · S/N 17701972 N34749Hardy Camden L · Seattle, WABuilt 1973 · S/N 17701975 N3474CLeroux Todd Carl · Palmer, AKBuilt 1954 · S/N 26517 N3474VWestern North Carolina Air Museum · Hendersonville, NCBuilt 1948 · S/N 7174 N3474YHanson Dan B Jr · Lusk, WYS/N 18051974 N347513218t Inc · Omaha, NEBuilt 1973 · S/N 17701977 N34753Vanhook Enterprises Inc · West Somerset, KYBuilt 1973 · S/N 17701979 N34756Devereaux Christopher L · Raleigh, NCBuilt 1973 · S/N 17701982 N34757James David C · Redlands, CABuilt 1973 · S/N 17701983 N34758Vaccaro Glen J · Trinidad, COBuilt 1973 · S/N 17701984 N34759Steckbeck Richard James · Enid, OKBuilt 1973 · S/N 17701985 N3475EOlmedo Refugio Junior · Lancaster, CABuilt 1978 · S/N 17271561 N3475FSanguinetti Mark · Winnsboro, LAS/N 18257475 N3475RMccullough Hugh J · Glennville, GABuilt 1968 · S/N 18258775 N3475SSmith Reine K IV · Lockhart, TXBuilt 1965 · S/N 18255875 N3475TWitt Jerry D · Marana, AZBuilt 1968 · S/N 17700775

Back to AD 87-20-03 R2