Skip to content

Registered aircraft · 54,015

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.

N7585EKauffman Larry R · Auburn, WABuilt 1984 · S/N 18268383 N7585GCessna85g LLC · Manassas, VABuilt 1970 · S/N 17259285 N7585SHayes John Martin · Mcalester, OKBuilt 1976 · S/N 18265234 N7585TBustamante Luis E · Longview, TXBuilt 1959 · S/N 47185 N7585UMoody Joshua Michael · Springfield, ORBuilt 1975 · S/N 15077752 N7585VMollahan Joseph P · Yamhill, ORBuilt 1976 · S/N 177RG0876 N75860Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 1976 · S/N 17268005 N75866Gibson Aviation Services LLC · Menomonie, WIBuilt 1976 · S/N 17268009 N7586MStar Valley Aviation Club LLC · Afton, WYBuilt 1959 · S/N 55886 N7586VSchroeder Terry E · Tuscola, ILBuilt 1976 · S/N 177RG0877 N7586XDpair LLC · Rome, GABuilt 1977 · S/N R18200107 N7586YJaskoski Leo D · Avondale, AZBuilt 1977 · S/N R18200140 N75870Westwind Aviation Inc · Phoenix, AZBuilt 1980 · S/N 20700648 N75871Blue Wing Flyer LLC · Marietta, GABuilt 1977 · S/N 17268011 N75874Walled Lake Flying Club · Waterford, MIBuilt 1976 · S/N 17268012 N75875Schumacher Matthew · Wenatchee, WAS/N 18877 N75876Roe Amber · Scotts Valley, CABuilt 1976 · S/N 17268013 N75878Milosevich Nikola · Deland, FLBuilt 1976 · S/N 17268014 N75879Griffin Aviation LLC · Spokane, WABuilt 1976 · S/N 17268015 N7587SWerner Matthew J · Shiner, TXS/N 18265236 N7587TStreater Stephen · Palm Coast, FLBuilt 1959 · S/N 47187 N7587VBradley Vaylan L · Keller, TXBuilt 1976 · S/N 177RG0878 N7587XBrown Bomber LLC · Missoula, MTS/N 17248087 N75885Mds Enterprises LLC · Lemont Furnace, PABuilt 1976 · S/N 17268019 N7588MRucinski Edward A · Climax, NCS/N 55888 N7588SPeraro Thomas A · Brighton, COBuilt 1979 · S/N R1723281 N7588TSale Reported · Orlando, FLSale reported, pending cancellationBuilt 1960 · S/N 47188 N75890Milligan Tony L · Rumford, MEBuilt 1976 · S/N 17268020 N75897Gopalakrishnan Sanjeev K · Spring, TXBuilt 1976 · S/N 17268023 N75898Center O Flying Club · Tumwater, WABuilt 1976 · S/N 17268024 N7589DBergstrom Aircraft Inc · Pasco, WABuilt 1979 · S/N 17272927 N7589VCorwin Lloyd D · Idaho Falls, IDBuilt 1976 · S/N 177RG0880 N758AASager Joseph M · Milford, PABuilt 1978 · S/N R1722931 N758ABBaerwolf Roy · Lake Havasu City, AZBuilt 1978 · S/N R1722938 N758AFSims Hollow M · Lithonia, GABuilt 1978 · S/N R1722936 N758AJHolman David · Bishop, CABuilt 1978 · S/N R1722939 N758AKFirst Flight LLC · Titusville, FLBuilt 1978 · S/N R1722940 N758ALPayne Austin · Weslaco, TXBuilt 1978 · S/N R1722941 N758AMZeid Aviation LLC · Houston, TXBuilt 1978 · S/N R1722942 N758APHawthorne Corporation · Richmond, VABuilt 1978 · S/N R1722944 N758ARValiair Ltd Co Trustee · Casper, WYBuilt 1978 · S/N R1722946 N758BAFlying Aces Aviation LLC · Seminole, TXBuilt 1978 · S/N R1722954 N758BDBoggs Richard D · Monroe, WABuilt 1979 · S/N R1722957 N758BHBlankenship Richard A · Stillwater, MNBuilt 1978 · S/N R1722961 N758BKEros Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R1722963 N758BQMccrink Joseph J · Borrego Springs, CABuilt 1978 · S/N R1722968 N758BTMikula Julie A · Half Moon Bay, CAFirst renewal noticeBuilt 1978 · S/N R1722971 N758BVPhilippi Joseph E · Judith Gap, MTS/N R1722973 N758BYOdom Bobby R · Berry, ALBuilt 1978 · S/N R1722976 N758CBRegistration Pending · Merced, CARegistration pendingBuilt 1978 · S/N R1722979

Back to AD 87-20-03 R2