Skip to content

Registered aircraft · 40,394

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.

N9765LMartone Aviation LLC · Ocala, FLBuilt 1972 · S/N M-1383 N9765MMahoney James P · Renton, WABuilt 1967 · S/N 670059 N9765WShelby Gary J · Harleysville, PABuilt 1967 · S/N 28-23251 N97662Northwest Alabama Holdings LLC · Spruce Pine, ALBuilt 1984 · S/N 17276219 N9766DMayer Gregory B · Fall River Mills, CABuilt 1959 · S/N 22-6682 N9766WYoung Justice P · Prairie Grove, ARS/N 28-23252 N97674Oc Flight Lessons LLC · Costa Mesa, CABuilt 1984 · S/N 17276220 N9767JMatta Aviation Services LLC · Junction City, KSBuilt 1967 · S/N 28-3963 N9767MMcgill James D · Tucson, AZBuilt 1967 · S/N 670061 N9767WBrighton Flying Club LLC · Brighton, MIBuilt 1967 · S/N 28-23254 N97681Buiqui Aerospace Corp · Kissimmee, FLBuilt 1984 · S/N 17276221 N9768JOpp Prop Air LLC · Collierville, TNBuilt 1967 · S/N 28-3964 N9768WEichner Cynthia A Loening · Tolland, CTBuilt 1967 · S/N 28-23255 N9769JDubovtsev Mikhail · Wildwood, NJBuilt 1967 · S/N 28-3967 N976ACNaples Air Center Inc · Naples, FLBuilt 1981 · S/N 28-8116308 N976DPKnox John R · Arvada, COBuilt 1998 · S/N 23808 N976MSStaten Joseph A · Kitty Hawk, NCBuilt 1976 · S/N AA5B0353 N97702Smith Jeffrey W · Yakima, WABuilt 1984 · S/N 17276222 N9770UPlegge Timothy E · Granbury, TXBuilt 1976 · S/N AA5A-0170 N9770WRegistration Pending · Altus, OKRegistration pendingBuilt 1967 · S/N 28-23257 N9771DHull Christian M · Palmer, AKBuilt 1959 · S/N 18-6830 N9771JBuzzard Roost Aviation LLC · Marble, NCBuilt 1967 · S/N 28-4009 N9771LLarson Steven E · Columbus, NEBuilt 1972 · S/N M-1402 N9771QAerospec Insurance LLC · Gig Harbor, WAS/N 1254 N9772WCow Dog Flyers LLC · Bozeman, MTBuilt 1967 · S/N 28-23259 N9773BChagres Flight Training LLC · Albuquerque, NMBuilt 1981 · S/N 172RG1027 N9773J1st Flight LLC · Granby, COBuilt 1967 · S/N 28-3972 N9773UEnos Matthew · Jackson, MOBuilt 1976 · S/N AA5A0173 N97749Beck Shylan · Blanding, UTBuilt 1984 · S/N 17276225 N9774DRegistration Pending · Wolf Point, MTRegistration pendingBuilt 1959 · S/N 18-6835 N9774WAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17264500 N97755Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276226 N9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeBuilt 1981 · S/N 172RG1029 N9775LLassiter Jason T DBA · Ephrata, PABuilt 1972 · S/N M-1391 N97766Wiggins Air Patrol LLC · Wichita, KSBuilt 1984 · S/N 17276228 N9776D76 Delta LLC · Garwood, TXBuilt 1959 · S/N 18-6837 N9776JVarman Michael J · Elwood, ILS/N 28-3975 N9776UMurphy James J · Winston Salem, NCBuilt 1976 · S/N AA5A-0176 N97779Kool Wings Leasing LLC · Indianapolis, INBuilt 1984 · S/N 17276230 N9777DRouse Kenneth L Jr · Joseph, ORBuilt 1957 · S/N 18-6191 N9777JKunick Matthew · Belfair, WAS/N 28-3976 N9777LEarl W Morrow Cpa Pe · Williamson, GAFirst renewal noticeBuilt 1972 · S/N M-1392 N9777UFlippo Pete · Meeker, OKBuilt 1976 · S/N AA5A-0177 N9777WWinthrop Michael F · Gainesville, VABuilt 1967 · S/N 28-23265 N97789Delta State University · Cleveland, MSBuilt 1984 · S/N 17276231 N9778JGilroy Shawn J · Bremen, GABuilt 1967 · S/N 28-3977 N9779VCoombs Eric S · Louisburg, NCBuilt 1974 · S/N 17264501 N9779WNovember Sierra Aviation LLC · Oneill, NES/N 28-23267 N977ACNaples Air Center Inc · Naples, FLBuilt 1988 · S/N 2816073 N977JOklahoma Aeronautics Academy LLC · Oklahoma City, OKBuilt 1976 · S/N 28-7715198

Back to AD 79-10-03 R2