Skip to content

Registered aircraft · 6,349

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

N3725MPaczkowski John P · Culpeper, VABuilt 1947 · S/N 12-2544 N3725XShultz L E · Brentwood, TNBuilt 1980 · S/N WA-114 N3726BThomas Allen Lee · Cedar Rapids, IABuilt 1980 · S/N WA-127 N3726UPillor Dalton John · Surprise, AZBuilt 1980 · S/N WA-124 N37271Jones Alva L · Craig, COBuilt 1941 · S/N 114 N37275Sky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N WA-129 N37276Fedorenko Vladimir Y · Estacada, ORBuilt 1980 · S/N WA-138 N3727BLonghorn Holding LLC · De Pere, WIBuilt 1980 · S/N WA-133 N3728MMohr Robert J · Wausau, WIBuilt 1947 · S/N 12-2668 N3729BFredericks William D · Charleston, WVBuilt 1980 · S/N WA-140 N3729DLambert David C · Conway, ARBuilt 1980 · S/N WA-141 N372FTTownsend Frederick H · Ortonville, MIBuilt 1972 · S/N 832-72 N372JHReynolds Eugene F · Mosheim, TNBuilt 1989 · S/N 472 N3730NHealy David Paul · Arlington, TXS/N WA-152 N3730SWingfield Ronald T · Little Rock, ARBuilt 1980 · S/N WA-115 N3731BSf-Gb Enterprises · Shelbyville, KYBuilt 1980 · S/N WA-143 N37327Stover Andrew C · Irvington, ALS/N 170 N3732BMurphy Walter D Trustee · Newcomerstown, OHBuilt 1980 · S/N WA-160 N3732FInderwiesen Nancy A · Cleveland, MOBuilt 1980 · S/N WA-154 N37332Shay Jonathan P · El Cajon, CABuilt 1980 · S/N WA-164 N3733CBarber Ted · Huntington, NYFirst renewal noticeBuilt 1980 · S/N WA-151 N37345Southern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1980 · S/N WA-158 N3735RJones Larry L · Paragould, ARS/N WA-171 N3739MAdair Steven M · Collierville, TNBuilt 1947 · S/N 12-2676 N3740BWood Graham A · Marshall, WIS/N WA-186 N3745VHill Lesly G · Folsom, CABuilt 1948 · S/N 15022 N3745ZFlint Paul L · Anchorage, AKBuilt 2001 · S/N 001 N3748MDebilt Bruce A · Berthold, NDS/N 12-2683 N374BWWiltse Bruce M · Vacaville, CABuilt 2007 · S/N 1354 N3752MYassick James M · Eagle River, AKBuilt 1947 · S/N 12-2688 N3758MSwede Aviation LLC · Tucson, AZS/N 12-2552 N3762MRobinson Fredrick J · Morris, ILBuilt 1947 · S/N 12-2694 N3762ULeipzig Andrew E · Ethridge, TNBuilt 1941 · S/N 5-678 N3764MDapp Eric M · Corvallis, ORBuilt 1947 · S/N 12-2696 N3767MGreat Cloud Design Inc · Dunedin, FLS/N 12-2699 N37685Koepsel Pamela L · Iron River, WIBuilt 1980 · S/N 447 N3771ZReed Gretchen M · Madison, OHBuilt 1943 · S/N 196 N3772ZHueners Clayton C · Anchorage, AKBuilt 1960 · S/N 18-7451 N3775NMedic Choppers LLC · Springdale, ARS/N WW1 N3780MRegistration Pending · Cody, WYRegistration pendingBuilt 1947 · S/N 12-2710 N3782MMills Air Service Inc · Marstons Mills, MAS/N 12-2712 N3782ZJordan S G · Wasilla, AKBuilt 1960 · S/N 18-7466 N3784MGtf Aviation LLC · Fryeburg, MEBuilt 1947 · S/N 12-2714 N3785MSale Reported · Stanton, MNSale reportedBuilt 1947 · S/N 12-2554 N3786MHuismann John C · Seaside, ORBuilt 1947 · S/N 12-2715 N3787MWilliams Jamey P · Thompson Falls, MTBuilt 1947 · S/N 12-2553 N3788MHendrickson Eric J · Brunswick, MEBuilt 1947 · S/N 12-2716 N378ACRagwing Aviation LLC · Palo Alto, CABuilt 1999 · S/N 1378-99 N3795MFoothills Aviation LLC · Buhl, IDBuilt 1947 · S/N 12-2722 N37961Gerwig Joseph L · Sutton, AKBuilt 1941 · S/N 5-832

Back to AD 80-25-02 R2