Skip to content

Registered aircraft · 81,728

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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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:81-18-04-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.

N3233WPickens Nathan A · Caldwell, IDS/N 32-45 N3233ZGelvin Stanley M · Central, AKBuilt 1959 · S/N 22-7178 N32344Cunningham James L · Oshkosh, WIBuilt 1974 · S/N 28R-7535046 N32346Voumard Rodney · Turlock, CABuilt 1974 · S/N 28-7510018 N3234FLastochka LLC · Kalispell, MTBuilt 1967 · S/N 670027 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 N32357Malone Bernard G · Frenchtown, NJBuilt 1974 · S/N 28R-7535047 N3235BHbhis LLC · Gnadenhutten, OHS/N 1010 N3235FRosario Michael J · Memphis, TNBuilt 1967 · S/N 670028 N3235MScheidel Jack A · Pleasant Grove, CABuilt 1947 · S/N 12-2028 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 N3236BSoderman David W · Gilby, NDBuilt 1954 · S/N 22-2066 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 N32379Erkert Jason A · Phoenix, AZBuilt 1974 · S/N 28R-7535049 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 N3238AHawley Timothy J · Ashland, OHBuilt 1965 · S/N 3185 N3238ESwiss Jack S · Anchorage, AKBuilt 1978 · S/N 17271477 N3238FKercheval Todd R · Georgetown, TXS/N 670031 N3238MNord Margie N Trustee · Cantwell, AKBuilt 1947 · S/N 12-2115 N3238QAttitude And Configuration Indicator LLC · Bedford, TXBuilt 1977 · S/N 28-7716145 N3238ZZulu Flight LLC · Washougal, WABuilt 1959 · S/N 22-7183 N32390Gruendling Kurt · Shelburne, VTS/N 28-7515145 N32392Devrnja Aero LLC · Knoxville, TNBuilt 1974 · S/N 28-7505056 N32393Mcnamee James R · Cocoa, FLBuilt 1974 · S/N 28R-7535050 N32394Cherokee Wings LLC · Indialantic, FLBuilt 1974 · S/N 32-7500005 N32397Tanya Austin L · Newburgh, NYBuilt 1974 · S/N 28-7525062 N3239ELeaf Air LLC · Queensbury, NYBuilt 1978 · S/N 17271478 N3239ZRoach Aviation LLC · Longview, TXBuilt 1959 · S/N 22-7185 N323AGalloway Lyle R · Ashton, IDBuilt 1999 · S/N 1058 N323AKRegistration Pending · Jupiter, FLRegistration pendingBuilt 1979 · S/N 6007027961218 N323APEm Concordia Inc · Brooklyn, NYS/N 31-8252031 N323BETracy Brian R · Georgetown, OHBuilt 1963 · S/N 28-1086 N323BGElectric Cowboy Aviation LLC · Okeechobee, FLS/N 28R-7435210 N323BTOlson Bryce T · Fertile, MNBuilt 2020 · S/N 3467 N323CAChatman Ira D · Mountain Home, ARS/N 807-98 N323DProfessional Training Aircraft LLC · Wilmington, DEBuilt 2016 · S/N 2843827 N323DFKeir Thomas A · Hopatcong, NJBuilt 1979 · S/N 28-7911200 N323DHKleinsmith Stacee F · Eagle River, AKBuilt 1963 · S/N 18-7939

Back to AD 81-18-04 R2