Skip to content

Registered aircraft · 25,369

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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N75824Williams John S · Fort Walton Beach, FLBuilt 1976 · S/N 17267981 N75825Patrick Ronald D · Locust Grove, GAFirst renewal noticeBuilt 1976 · S/N 17267982 N75829Hofmann LLC · Blauvelt, NYBuilt 1976 · S/N 17267985 N7582FCassano Graham S · Canandaigua, NYS/N 738-70 N7582GCapps Christopher T · Anchorage, AKBuilt 1970 · S/N 17259282 N7582VKlebanoff Mark · Worthington, OHBuilt 1976 · S/N 177RG0873 N75831Mccall Freddie W · Century, FLBuilt 1976 · S/N 17267987 N75833Blees James E · Anchorage, AKBuilt 1976 · S/N 17267989 N75837Linder Ronald G · Fort Wayne, INBuilt 1976 · S/N 17267992 N75838Fadel Shaheen J · Charlotte, NCS/N 17267993 N75839Rocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1976 · S/N 17267994 N7583FDienst Lon C · Poplar Grove, ILBuilt 1970 · S/N 739-70 N7583GPebworth Properties LLC · Auburn, WABuilt 1970 · S/N 17259283 N7583WJoseph Kenneth W DBA · Canton, OHBuilt 1977 · S/N R18200064 N75840Planebros LLC · Bixby, OKBuilt 1976 · S/N 17267995 N75842Foree John Baird · New Castle, KYBuilt 1976 · S/N 17267997 N75844Command Aviation Inc · Bellingham, WABuilt 1976 · S/N 17267998 N75845Stark Russell Allen · Madison, WIBuilt 1976 · S/N 17267999 N75846Rodgers Lynn C · Springfield, MOBuilt 1976 · S/N 17268000 N7584HUav Pro Inc · Blackstone, VABuilt 1981 · S/N 18267919 N7584YMaher Andrew · Woodinville, WABuilt 1977 · S/N R18200139 N7585GCessna85g LLC · Manassas, VABuilt 1970 · S/N 17259285 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 N7586FJh Aviation Services LLC · Daisy, GABuilt 1970 · S/N 742-70 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 N75871Blue Wing Flyer LLC · Marietta, GABuilt 1977 · S/N 17268011 N75874Walled Lake Flying Club · Waterford, MIBuilt 1976 · S/N 17268012 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 N7587VBradley Vaylan L · Keller, TXBuilt 1976 · S/N 177RG0878 N75885Mds Enterprises LLC · Lemont Furnace, PABuilt 1976 · S/N 17268019 N7588FWilbanks Kari L · North Port, FLBuilt 1970 · S/N 751-70 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 N7589FAerial Advertising Services · Livermore, CAS/N 236-70 N7589VCorwin Lloyd D · Idaho Falls, IDBuilt 1976 · S/N 177RG0880 N758PANew Horizons Aviation Inc · Goshen, INBuilt 1978 · S/N 15282932 N758YSFly Sky Ads LLC · Manalapan, NJBuilt 1982 · S/N A1521017 N758YTMountain Air Flying LLC · Brigham City, UTBuilt 1982 · S/N A1521018 N75904Worley Dan L · Heber Springs, ARS/N 17268028 N75907Rmb Leasing Inc · Dover, DEBuilt 1976 · S/N 17268031 N75909Martin Michael J · Anchorage, AKS/N 17268033 N75917Abs Aviation · Lanham, MDBuilt 1976 · S/N 17268040

Back to AD 80-25-07 R1