Skip to content

Registered aircraft · 6,916

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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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:97-01-01-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.

N32873Blundell Joseph B III · Belleville, ARBuilt 1975 · S/N 34-7570064 N3287RWright Maurice · Las Vegas, NVBuilt 1970 · S/N 28R-31262 N328MASs Aviation LLC · Wichita, KSBuilt 1974 · S/N 28R-7435035 N328NCHenderson Anthony B · Hoschton, GABuilt 1977 · S/N 28R-7737164 N3293RBrook Jacob C · Broken Arrow, OKBuilt 1969 · S/N 28R-31264 N3294RMurray Dennis P · Malta, NYBuilt 1969 · S/N 28R-31265 N32959Hill Ryan D · Fresno, CAS/N 34-7570069 N32978Klippel Charlie L · Huntington Beach, CABuilt 1975 · S/N 28R-7535103 N32994Lima Golf Bravo LLC · Chandler, AZBuilt 1975 · S/N 28R-7535104 N32999Mil2atp Inc · Pikeville, NCBuilt 1975 · S/N 34-7570071 N3299RDavis Charles · Sanford, FLBuilt 1970 · S/N 28R-31270 N32EJFox Jason Ross · Buckley, WABuilt 1967 · S/N 28R-30287 N32PDAsp Victor · Shoreline, WABuilt 1973 · S/N 28R-7435091 N32VEFlying Mirage LLC · New Port Richey, FLBuilt 1977 · S/N 32R-7780117 N33006Hawks Travis · Mount Vernon, MOS/N 28R-7535105 N33012Leon Hinkle LLC · Fort Ashby, WVBuilt 1975 · S/N 34-7570072 N33031Jerpbak Mark J · El Dorado Hills, CABuilt 1975 · S/N 28R-7535108 N33047Meise Justin · Hopewell Junction, NYBuilt 1975 · S/N 28R-7535111 N3306QTwin G Aviation LLC · Charlotte, NCBuilt 1977 · S/N 28R-7703100 N33071Krogstad Bruce H · Milwaukee, WIBuilt 1975 · S/N 34-7570082 N33075Portugues Aviation LLC · Canovanas, PRS/N 28R-7535116 N33085Salsbery Scott E · Brush Prairie, WAS/N 28R-7535118 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 N330CPCharlie Pop Flyers Inc · Jacksonville, FLBuilt 1969 · S/N 30-1884 N330JGCultra LLC · Naples, FLS/N 24-3042 N3310PLopes Gaston A · Dallas, TXBuilt 1973 · S/N 28R-7435121 N33110Grandview Aviation LLC · Bethel Park, PAS/N 28R-7535122 N33123Maccorkle Leon · Round Pond, MEBuilt 1975 · S/N 28R-7535123 N33129Cloud 9 Flying Club Inc · Cedar Rapids, IABuilt 1975 · S/N 28R-7535124 N33142Cogan Christopher · Warner Robins, GABuilt 1975 · S/N 28R-7535126 N33144Weather Modification LLC · Fargo, NDBuilt 1975 · S/N 34-7570094 N33151Thayer Victoria · Ontario, CABuilt 1975 · S/N 28R-7535127 N33156Bchr Aviation LLC · Boerne, TXBuilt 1975 · S/N 34-7570096 N331VRaptor Airmotive LLC · Poplar Grove, ILBuilt 1978 · S/N 347870340 N3322GLone Star Flight Museum · Houston, TXBuilt 1970 · S/N 39-10 N3326MMcray Brett H · Sugar Land, TXBuilt 1977 · S/N 28R-7837111 N3327MNearhoof Jeremy R · The Woodlands, TXBuilt 1977 · S/N 28R-7837112 N3328MHidley Robert W · Oneida, TNBuilt 1977 · S/N 28R-7803165 N33301Jensuz LLC · Agoura Hills, CABuilt 1975 · S/N 28R-7535130 N33303Kowalchyk Aviation Management LLC · Jasper, GAS/N 34-7570102 N33345Decker Timothy Daniel · Weatherford, TXBuilt 1975 · S/N 34-7570107 N33348Air Venture Inc · Hagerstown, MDBuilt 1975 · S/N 28R-7535136 N33349Stroud Jerry · Hope, ARBuilt 1975 · S/N 28R-7535137 N33360Synergy Transport LLC · Albany, ORBuilt 1975 · S/N 34-7570109 N33361Petit Raymond T Trustee · Westerville, OHBuilt 1975 · S/N 28R-7535087 N33372N33372 LLC · New Bern, NCBuilt 1975 · S/N 28R-7535139 N33379Unruh David E · Cadiz, KYBuilt 1975 · S/N 28R-7535141 N33399Begin Nelson · N Berwick, MEBuilt 1975 · S/N 28R-7535142 N333BBDenecke Robert W · Fredericksburg, VAS/N 34-7250279

Back to AD 97-01-01 R1