Skip to content

Registered aircraft · 40,472

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-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N32291Active Pilot Inc · Van Nuys, CABuilt 1974 · S/N 28-7515114 N32292Mdr Rental Corp · Ann Arbor, MIBuilt 1974 · S/N 28-7515115 N32293Stone James B · Springfield, VABuilt 1974 · S/N 28-7505046 N32296Fly South Aviation LLC · Charlotte, NCBuilt 1974 · S/N 28-7525046 N32299Lundahl Kristina N · Windsor, COBuilt 1974 · S/N 28-7515116 N322ATAbkadirov Tagir · Tampa, FLS/N 1524 N322BFVann Russell B · Mangum, OKBuilt 1979 · S/N 17273231 N322CTGrover Michael P · Palm Coast, FLBuilt 1979 · S/N 28-7916545 N322DRMcgrath James T · Campbell, CABuilt 2005 · S/N 81291 N322DWAutry Michael D · Metuchen, NJBuilt 2015 · S/N 11384 N322GEPierce Michael W · Leitchfield, KYS/N 0934 N322MLAshcraft Aviation LLC · Bay City, TXS/N 3572 N322SHelfrick Edward W Jr · Elysburg, PABuilt 1995 · S/N 2005 N322ZLafaille David A · Simi Valley, CABuilt 1991 · S/N WP001 N32300Primary Flight Control LLC · Fleming Island, FLBuilt 1974 · S/N 28-7515118 N32306Legacy Pilot Training LLC · Annandale, MNS/N 28-7515120 N3230QArizona Cassidy E · North Platte, NEBuilt 1977 · S/N 28-7790448 N3230TLsao LLC · Shelbyville, ILBuilt 1967 · S/N 17700530 N32314Fort Dodge Flight Support Inc · Fort Dodge, IABuilt 1974 · S/N 28-7525048 N32318Feulner Lori · Hebron, NEBuilt 1974 · S/N 28-7515123 N3231QCollins Gregory J · Appleton, WIBuilt 1977 · S/N 28-7725220 N3231TGouse Frederick Earl II · Waxahachie, TXBuilt 1967 · S/N 17700531 N3231ZWestern Skyways Inc · Montrose, COBuilt 1959 · S/N 22-7176 N32321Irvin Phillip Jerry · Winters, TXBuilt 1974 · S/N 28-7515126 N32326Blair James J Jr · Brick, NJBuilt 1974 · S/N 28-7525050 N32332Warrior 74 LLC · Columbia, SCBuilt 1974 · S/N 28-7515129 N32334N32334 Aviation LLC · Chandler, AZBuilt 1974 · S/N 28-7515130 N32336Simmer Nicholas Lee · Rock Falls, ILBuilt 1974 · S/N 28-7525052 N32337Pab Air Inc · Hialeah, FLBuilt 1974 · S/N 28-7515131 N32338Rivera Filiberto Jr · Moses Lake, WABuilt 1974 · S/N 28-7515132 N3233WPickens Nathan A · Caldwell, IDS/N 32-45 N3233ZGelvin Stanley M · Central, AKBuilt 1959 · S/N 22-7178 N32351International Air Services Inc Trustee · Carson City, NVBuilt 1974 · S/N 28-7515134 N32353Gardiner Kenneth W · Enfield, MEBuilt 1974 · S/N 28-7515136 N32355Finlayson Duncan Robert · Estacada, ORBuilt 1974 · S/N 28-7505053 N32361Odom Eric J · Johnson City, TNBuilt 1974 · S/N 28-7525055 N32363Wagner Daniel R · Dewey, AZS/N 28-7515137 N32364Buffalo Ridge Aviation LLC · White, SDBuilt 1974 · S/N 28-7515138 N32367Martin Stephen · Bonney Lake, WABuilt 1974 · S/N 28-7515139 N32369Avia Flight Academy LLC · Stratford, CTBuilt 1974 · S/N 28-7505054 N3236PFalcon Air LLC · Anchorage, AKBuilt 1958 · S/N 18-6766 N32375Mersereau Austen D · Anchorage, AKBuilt 1974 · S/N 28-7515140 N32376Delaware State University · Dover, DEBuilt 1974 · S/N 28-7515141 N32378Sanders David D · Alvin, TXBuilt 1974 · S/N 28-7505055 N3237NLee Leo Lea Young · Pasadena, CABuilt 1970 · S/N 5849 N32384Metz Justin · Scottsdale, AZBuilt 1993 · S/N 22388 N32386Rice Craig W · Walnut Creek, CABuilt 1974 · S/N 28-7525058 N32387Mclelland Brenda M · Springfield, MOBuilt 1974 · S/N 28-7525059 N3238ESwiss Jack S · Anchorage, AKBuilt 1978 · S/N 17271477 N3238QAttitude And Configuration Indicator LLC · Bedford, TXBuilt 1977 · S/N 28-7716145

Back to AD 80-04-03 R2