Skip to content

Registered aircraft · 40,396

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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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:79-10-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.

N5089RHigh Wing Air Services LLC · Merritt Island, FLBuilt 1974 · S/N 17263327 N508BDIron Wings Aviation LLC · Ralph, MIBuilt 1961 · S/N 28-214 N508GLCirone James · Pampa, TXBuilt 1974 · S/N 0508 N508RFFugate Richard Dee · Rochester, MNBuilt 1981 · S/N 28-8190281 N508THFowler David P · Freeport, MEBuilt 1967 · S/N 28-22869 N50906Aitken & Wilson Aviation LLC · Leesburg, VABuilt 1980 · S/N 17274232 N5090EMelbourne Flight Training LLC · Melbourne, FLBuilt 1978 · S/N 17271705 N5090MAri Ben Aviator Inc · Fort Pierce, FLBuilt 1978 · S/N ME-34 N5090TWoodcox Edmund A · West Monroe, NYBuilt 1968 · S/N MB-346 N5090WJaybird Aviation LLC · San Antonio, TXBuilt 1961 · S/N 28-99 N5091717 Leasing LLC · Englewood, COBuilt 1980 · S/N 17274233 N5091EAmerican Asset Leasing LLC · Aurora, ORBuilt 1978 · S/N 17271706 N5091PSpicuzza Robert A · Waterford, MIBuilt 1958 · S/N 24-100 N5091WRegistration Pending · Anchorage, AKRegistration pendingBuilt 1961 · S/N 28-100 N50926Registered aircraftBuilt 1992 · S/N 002 N5092EKaye Russell G · New Fairfield, CTBuilt 1978 · S/N 17271707 N5092MZavalney Steven Michael · Canyon, TXBuilt 1978 · S/N MB-891 N5092TZigo Daniel N · Madill, OKBuilt 1968 · S/N MB-347 N50935Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274365 N5093EBohmer Carla M · Tulsa, OKS/N 17271708 N5093KL A M Capital Management LLC · Sheridan, WYBuilt 1980 · S/N 17273964 N5093PAir Chutney LLC · Waynesboro, VABuilt 1958 · S/N 24-102 N5093RSkyhawks Inc · Montoursville, PABuilt 1974 · S/N 17263331 N5093SPerez Matthew C · Indianapolis, INS/N 28-7125301 N5093TTaylor Allen S · Oak Harbor, WABuilt 1968 · S/N MB-378 N50941Labrucherie Peter E · El Centro, CAS/N 17264216 N50944Munoz Jacqueline T · Huntsville, ALS/N 17264217 N50947Bend Aircraft Mechanics LLC · Bend, ORBuilt 1974 · S/N 17264218 N5094RHigh View Air LLC · Driftwood, TXBuilt 1974 · S/N 17263332 N5094TKrass Roman · West Hills, CAS/N M-1137 N5095RTraining Planes LLC · Tampa, FLBuilt 1974 · S/N 17263333 N5095TColter Duane E · Plainfield, INBuilt 1968 · S/N M-1138 N5095WBailey Bruce B · Dublin, VABuilt 1961 · S/N 28-107 N50967Sellers Raymond L · Trussville, ALS/N 17264221 N5096GRiya Aviation LLC · Tracy, CABuilt 1979 · S/N 17273545 N5096HMyhre Norman G · Hixton, WIBuilt 1975 · S/N 17265339 N5096TRichards Lyle D · Riley, KSBuilt 1972 · S/N 28-7225344 N5097EBenedikt Craig A · Clayton, GABuilt 1978 · S/N 17271710 N5097RPlymouth Flying Club Inc · Plymouth, NCBuilt 1979 · S/N 172RG0039 N5097VCamm Air · Spencer, IABuilt 1980 · S/N 172RG0447 N50987Berg James O · Dunseith, NDBuilt 1968 · S/N 15069690 N50988Propability One LLC · Daytona Beach, FLBuilt 1974 · S/N 17264223 N5098RWilliams Austin T · Sheridan, INBuilt 1974 · S/N 17263336 N5098VHarvestowne Aviation LLC · Saint Charles, MOBuilt 1980 · S/N 172RG0448 N50996Burke John E · Spring, TXBuilt 1968 · S/N 15069698 N5099CRinker Robert W Jr · Seattle, WABuilt 1987 · S/N 1828 N5099KSaari Michael · Sycamore, ILBuilt 1980 · S/N 17273969 N5099MBufo David · Los Osos, CABuilt 1978 · S/N M-2028 N5099RFly High Aircraft Sales LLC · Ocilla, GABuilt 1974 · S/N 17263337 N5099TClark Darril W · Scappoose, ORBuilt 1972 · S/N 28-7225347

Back to AD 79-10-03 R2