Skip to content

Registered aircraft · 56,580

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

N3064YStemper Pete L · Madison, SDS/N 18254064 N30654Eagle Sky Patrol Inc · Deadwood, SDBuilt 1969 · S/N 17701386 N30656Vance Matthew Austin · Decatur, GABuilt 1969 · S/N 17701387 N3065ASouza Clifford A · Pattersonville, NYBuilt 1953 · S/N 25709 N3065E3065e LLC · Westfield, PABuilt 1978 · S/N 17271425 N3065FHinds Frank E · San Angelo, TXBuilt 1966 · S/N 18257165 N3065QSuchy Michael R · Murrieta, CABuilt 1967 · S/N 18258065 N30661Feiler Joe · Casper, WYBuilt 1969 · S/N 17701389 N30663Kroeker Bryan S · Grant, NEBuilt 1969 · S/N 17701391 N30668Elevation Aviation LLC · Mccomb, MSBuilt 1969 · S/N 17701394 N3066APrice Brian · Page, AZS/N 25710 N3066JWeyer Terry J · Edgewater, FLBuilt 1965 · S/N 15061166 N3066QMeyer Vernon C · Westlake, LABuilt 1967 · S/N 18258066 N30670Brown Thomas E · Trenton, GABuilt 1969 · S/N 17701395 N30671Foster Milton F · Dawson, GABuilt 1969 · S/N 17701396 N30673Cardinal Flyers Inc · Sault Sainte Marie, MIBuilt 1969 · S/N 17701397 N30677Worley Timothy Joseph · San Angelo, TXBuilt 1973 · S/N 15074966 N3067AHanson Lavon T · Huson, MTS/N 25711 N3067EGlass Bruce D · Crystal Lake, ILBuilt 1982 · S/N 18268231 N3067VStauffer Todd · Jackson, MSBuilt 1974 · S/N 15076375 N3067YRegistration Pending · Bluffdale, UTRegistration pendingBuilt 1962 · S/N 18254067 N30680Smith Ronald D · Anderson, INBuilt 1969 · S/N 17701401 N30685Blanchette George · Longwood, FLBuilt 1969 · S/N 17701404 N30686Tullos Morgan P · Austin, TXBuilt 1969 · S/N 17701405 N3068ACyrus Ely G · Kiana, AKS/N 25712 N3068FLehrman Walter M · Reedley, CABuilt 1966 · S/N 18257168 N3068JWave Soaring Adventures Inc · Lake Tapps, WABuilt 1965 · S/N 15061168 N3068SZephyrhills Flying Club Inc · Tampa, FLBuilt 1967 · S/N 15066968 N3068UArlins Aircraft Service Inc · Belgrade, MTBuilt 1963 · S/N 17250668 N30691Hayden Boyce · Grand Rapids, MIBuilt 1969 · S/N 17701407 N30695Beck Paul D · Russell, IAS/N 17701409 N3069FBlaine Barry A · Campbell, CABuilt 1966 · S/N 18257169 N3069JSkymax Holdings LLC · Spokane, WABuilt 1965 · S/N 15061169 N3069QMarin Alberto · Mc Neal, AZS/N 18258069 N306CACivil Air Patrol · Maxwell Afb, ALBuilt 2023 · S/N 172S13082 N306DMWylie Aviation LLC · North Little Rock, ARBuilt 1974 · S/N 18262544 N306DPHer Airway LLC · Boca Grande, FLBuilt 2016 · S/N 172S11736 N306GWCollege Of Missionary Aviation Inc · Keystone Heights, FLS/N 17250714 N306HBoard Of Trustees Of Southern Illinois University · Carbondale, ILBuilt 2023 · S/N 172S12968 N306PPSl Aviation LLC · Seattle, WABuilt 2010 · S/N 172S11042 N306TCN306tc LLC · Greenwich, CTBuilt 1976 · S/N 18503061 N30708Johnson Raymond W · Buffalo, MNBuilt 1969 · S/N 17701414 N30709Wessels Jr Steven A · Milledgeville, GABuilt 1969 · S/N 17701415 N3070AMacvey Troy R · Oxford, OHBuilt 1953 · S/N 25714 N3070JCascade Soaring Society · East Wenatchee, WABuilt 1965 · S/N 15061170 N3070YPearce Andrew R · Raleigh, NCBuilt 1962 · S/N 18254070 N30713Wallace James Ray · Baltimore, MDBuilt 1970 · S/N 17701417 N30717Day David G · Glendora, CAS/N 17701420 N30718Olson Andrew S · Copper Canyon, TXBuilt 1969 · S/N 17701421 N3071FRees Ryan G · Loa, UTS/N 18257171

Back to AD 79-10-14 R1