Skip to content

Registered aircraft · 22,413

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-08-08-R3') 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-08-08-R3') 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-08-08-R3')
    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-08-08-R3')
  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-08-08-R3')
  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-08-08-R3')
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.

N32SJCutter Southwest Aircraft Sales LLC · Phoenix, AZBuilt 2007 · S/N 3257473 N32SPCochran Gene P · Silverdale, WABuilt 1976 · S/N 28-7690199 N32SXDorans Aviation LLC · Yardley, PABuilt 2004 · S/N 3232022 N32TEBlue Line Aviation LLC · Dunbar, NEBuilt 1999 · S/N 3257112 N32VEFlying Mirage LLC · New Port Richey, FLBuilt 1977 · S/N 32R-7780117 N32VTWinging It LLC · Louisville, KYBuilt 1979 · S/N 32-7940029 N32WFN32wf LLC · Muscatine, IAS/N 3246026 N33001Peak Builders Inc · San Diego, CAS/N 28-7525134 N33006Hawks Travis · Mount Vernon, MOS/N 28R-7535105 N33009Pamrus Inc · Zephyr Cove, NVS/N 32-7540080 N33017Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 28-7515289 N33018Lovingier Michael J · Glendale, AZBuilt 1975 · S/N 28-7515290 N3302WKsnl Aero LLC · Shawnee, OKBuilt 1965 · S/N 32-137 N33030Fanopoulos Joshua J · Boise, IDS/N 28-7525139 N33031Jerpbak Mark J · El Dorado Hills, CABuilt 1975 · S/N 28R-7535108 N33046American Eagles Flying Club · New Hudson, MIBuilt 1975 · S/N 28-7505114 N33047Meise Justin · Hopewell Junction, NYBuilt 1975 · S/N 28R-7535111 N3305WSalisch Jurgen · Napoleon, OHS/N 32-141 N33061Piper 33061 LLC · Rustburg, VABuilt 1975 · S/N 28-7505116 N33064Facklair LLC · Granville, OHS/N 28-7505117 N33068Crosby Michael W · Clearwater, FLBuilt 1975 · S/N 28-7510037 N3306QTwin G Aviation LLC · Charlotte, NCBuilt 1977 · S/N 28R-7703100 N33075Portugues Aviation LLC · Canovanas, PRS/N 28R-7535116 N33076Takagishi Hideto · San Jose, CABuilt 1975 · S/N 32-7540084 N33077Klug Ryan Gregory · Lincoln, NEBuilt 1975 · S/N 28-7525149 N33079Devaney Aviation Inc · Palm City, FLS/N 28-7525150 N3307WCowell Samuel · Easley, SCBuilt 1965 · S/N 32-144 N33081Tofan Ray · Chula Vista, CAS/N 28-7505119 N33083Barnhill Chris · Carbondale, ILBuilt 1975 · S/N 28-7505120 N33085Salsbery Scott E · Brush Prairie, WAS/N 28R-7535118 N33089Double Ll Enterprises LLC · Virginia Beach, VABuilt 1975 · S/N 32-7540086 N33092Shepherd Edward H · Grass Valley, CABuilt 1975 · S/N 28-7525153 N33095Kollmansberger James K · Fond Du Lac, WIBuilt 1975 · S/N 28R-7535120 N33096United States Air Force Owner · Offutt Afb, NEBuilt 1975 · S/N 28R-7535121 N330FTSuwannee Arrow LLC · Clearwater, FLBuilt 1982 · S/N 28-8216209 N330MCWoolever Shane M · Sault Sainte Marie, MIBuilt 1978 · S/N 32R-7987072 N330PCaldaso Inc · Peachtree City, GABuilt 1978 · S/N 32-7840164 N330TFMartin Earl · Seneca Falls, NYBuilt 1996 · S/N 3246032 N33107Florida Coastal Flying Club LLC · Titusville, FLBuilt 1975 · S/N 28-7525154 N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121 N3310WBig Wing Energy LLC · Decatur, ARBuilt 1965 · S/N 32-148 N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122 N3311GEdge Construction & Consulting Inc · Bement, ILBuilt 2007 · S/N 3257454 N33121Civil Air Patrol Flying Association Inc · Branford, CTBuilt 1975 · S/N 28-7505124 N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123 N33124Meyer Robert Dean Jr · California, MDBuilt 1975 · S/N 28-7510039 N33128Flora Airport Authority · Flora, ILBuilt 1975 · S/N 28-7505125 N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124 N3312WMcmurray Michael J · Killeen, TXBuilt 1965 · S/N 32-150 N33133Balisier Aviation Inc Trustee · Wilmington, DEBuilt 1975 · S/N 32-7540089

Back to AD 87-08-08 R3