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.

N34821Gibbs Keith L · Eaton Rapids, MIBuilt 1973 · S/N 17702025 N34823Eight Twenty Three LLC · Santa Barbara, CABuilt 1973 · S/N 17702026 N34829Woods Roderick D · Collierville, TNBuilt 1974 · S/N 17702029 N3482CLacewell Matthew K · Chugiak, AKFirst renewal noticeBuilt 1954 · S/N 26525 N3482DKrumins Arvids · Wichita, KSBuilt 1955 · S/N 27025 N3482JShelton David R · Potter Valley, CABuilt 1967 · S/N 15066182 N3482THaskell Thomas Edward · Georgetown, TXBuilt 1968 · S/N 17700782 N3482UMitchell Philip T · Moreland, GABuilt 1963 · S/N 18254882 N3482VBorden Leon D · Arcadia, CAS/N 7182 N34830Airworx LLC · Gotha, FLBuilt 1973 · S/N 17702030 N34833Dallman Bruce D · Terre Haute, INBuilt 1973 · S/N 17702032 N34835Saddleback Enterprises LLC · Newport Beach, CABuilt 1973 · S/N 17702033 N3483CBorreson Michele R · Reno, NVBuilt 1954 · S/N 26526 N3483RCentury White Worldwide Inc · Casper, WYBuilt 1968 · S/N 18258783 N3483SHickey Bill J · La Veta, COBuilt 1964 · S/N 18255883 N3483TCalhoun Edward J · Whitney, NEBuilt 1968 · S/N 17700783 N3483UPool Robert Brooks · Lake Charles, LABuilt 1963 · S/N 18254883 N3483YGrimes William H · Seabrook, SCBuilt 1968 · S/N 18051983 N34843Radler Glenn E · Livingston, NJBuilt 1973 · S/N 17702037 N34845Ccf Ventures Inc · Bangor, MES/N 17702039 N34847Hanna David G · Imperial, NEBuilt 1973 · S/N 17702041 N3484RTouch And Go Aviation LLC · Jackson, MNBuilt 1968 · S/N 18258784 N3484TCairo Jane LLC · Ponca City, OKBuilt 1968 · S/N 17700784 N3484VWeiss Elliott · Fresno, TXS/N 7184 N3484YSport Obermeyer Ltd · Aspen, COBuilt 1968 · S/N 18051984 N34850Axs Sourcing It LLC · Chugiak, AKBuilt 1973 · S/N 17702044 N34852Pride Electric Enterprises · Prescott Valley, AZBuilt 1973 · S/N 17702046 N34858Schmid Walter Allen · Fruitland, IDFirst renewal noticeBuilt 1973 · S/N 17702049 N3485LEhalt Christopher J · Lester Prairie, MNBuilt 1967 · S/N U206-0785 N3485SThorp Contractors LLC · Vinita, OKBuilt 1964 · S/N 18255885 N3485VMyron Alexander Tedrow · Morristown, TNBuilt 1948 · S/N 7211 N34860Pittman Charles R Trustee · Waterloo, ILBuilt 1973 · S/N 17702051 N34865Schmedeman Andrew J · Sanford, FLBuilt 1973 · S/N 17702053 N34866Schroeder David C · Norfolk, NEBuilt 1976 · S/N 177RG1015 N34868Leonard Isaacs Aviation LLC · Fairfield, TXBuilt 1973 · S/N 17702056 N34869Aviation Advantage LLC · Phoenix, AZBuilt 1976 · S/N 177RG1016 N3486CZachary Maydole · Fairbanks, AKBuilt 1954 · S/N 26529 N3486UZhills Pilot LLC · Zephyrhills, FLBuilt 1963 · S/N 18254886 N3486VLiberty Aviation LLC · Henderson, NVBuilt 1974 · S/N 15076518 N34873Payne Richard L · Flint Hill, VABuilt 1973 · S/N 17702058 N34876Clear Sky Flyers LLC · Lincoln, NEBuilt 1973 · S/N 17702059 N3487CWhitten Chris K · Alton, MOBuilt 1954 · S/N 26530 N3487DSowles John W · North Yarmouth, MEBuilt 1955 · S/N 27030 N3487SAscent Investments LLC · Kasota, MNS/N 18255887 N3487ULawser Ron · Townsend, MTBuilt 1963 · S/N 18254887 N34886Brooks Aviation LLC · Wilmington, DEBuilt 1974 · S/N 17702064 N34888Double J3 Aviation LLC · West Palm Beach, FLS/N 17702066 N3488CBaker Dean C · Cave Creek, AZBuilt 1954 · S/N 26531 N3488DSugarloaf Aviation LLC · Carrabassett Vly, MES/N 27031 N3488SBarbosa Javier · Edinburg, TXBuilt 1964 · S/N 18255888

Back to AD 87-20-03 R2