Skip to content

Registered aircraft · 40,404

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.

N13686T Craft Aero Club Inc · Nampa, IDBuilt 1974 · S/N 17262943 N1368URed Baron Flyers · Caledonia, MNBuilt 1976 · S/N 17267039 N1369Low Country Skyways LLC · Wilmington, DEBuilt 1969 · S/N RLG-316 N13690Dyre Daniel · Park Rapids, MNBuilt 1976 · S/N 17702454 N13692American Patrols Inc · Midland, TXBuilt 1974 · S/N 17262946 N13693Iowa Lakes Community College · Estherville, IABuilt 1974 · S/N 17262947 N13698Park Avenue Group Inc · Stuart, FLBuilt 1974 · S/N 17262952 N1369BFryt Michael J · Goldsboro, NCS/N 371-72 N1369RRyals Jon Harris · Billings, MTBuilt 1975 · S/N AA5-0769 N136AVHarford Archer Owners Group LLC · Bel Air, MDBuilt 1984 · S/N 28-8590004 N136CCShelk John Brian · Bend, ORBuilt 2002 · S/N 9953CC N136CHHall Kenneth C · Kernersville, NCBuilt 2004 · S/N 449 N136DKReece Robert B · Halstead, KSBuilt 2003 · S/N 24654 N136DWSun Aircraft Management LLC · Ormond Beach, FLBuilt 2003 · S/N 4496168 N136FSale Reported · Broomfield, COSale reportedBuilt 2001 · S/N 60300 N136FCDepartment Of Agriculture & Consumer Services · Tallahassee, FLBuilt 1982 · S/N 28-8290171 N136JMGregory Warren D Jr · Aguila, AZBuilt 1963 · S/N 22-5557 N136LMLge Flying Club · Canton, GABuilt 1975 · S/N 17265041 N136MMMiller Carl A · Vero Beach, FLBuilt 1993 · S/N 21718 N136RCCaldwell Richard A · Indn Hbr Bch, FLBuilt 2000 · S/N 24187 N136SASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1993 · S/N 10164 N136TRRv6a136tr LLC · Merrillville, INBuilt 2000 · S/N 34132 N136VPWartman Steven · Sandia Park, NMBuilt 1965 · S/N 28-21128 N13701M-A-R-S Aircraft Leasing LLC · Williamsburg, VABuilt 1974 · S/N 17262953 N13703Kisser Carroll P · Alexandria, VABuilt 1974 · S/N 17262955 N1370ESprocket Aircraft Management LLC · Kennesaw, GABuilt 1978 · S/N 17270972 N1370UUnited States Air Force Aero Club · Usaf Academy, COBuilt 1976 · S/N 17267041 N13710Registered aircraftBuilt 1976 · S/N 17702456 N13715Wingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17262962 N13719Precious Metal Aviation LLC · Menomonee Falls, WIBuilt 1974 · S/N 17262966 N1371TSaviortree House Ministries · Coarsegold, CABuilt 1972 · S/N 28-7225485 N1371UStanton Sport Aviation · Stanton, MNBuilt 1976 · S/N 17267042 N13721Muth Robert F · Whitefish, MTBuilt 1974 · S/N 17262968 N13723Johnson Darwin E Jr Trustee · Hollywood, ALBuilt 1974 · S/N 17262970 N13725Moster Paul C · Morristown, NJBuilt 1974 · S/N 17262972 N13727Ofarrell Scott A · Sterling Heights, MIBuilt 1974 · S/N 17262973 N1372ECsa Aircraft Leasing LLC · Park City, UTS/N 17270974 N1372TGriffin Justin B · Hayesville, NCBuilt 1982 · S/N 83 N1372UFerguson Joseph L II · Fairmont, WVBuilt 1976 · S/N 17267043 N13731East Derrick A · Cullman, ALBuilt 1974 · S/N 17262977 N13732Bay Lux Ventures LLC · Tampa, FLBuilt 1974 · S/N 17262978 N13733Kelleher James · Nevada City, CABuilt 1976 · S/N 17702462 N13734Red Bird Flyers LLC · Acton, MABuilt 1976 · S/N 17702463 N13737Crosswinds Flight Center Inc · Drums, PABuilt 1974 · S/N 17262983 N13739Maroldy Robert S · Gahanna, OHBuilt 1974 · S/N 17262985 N1373EEagle Aviation LLC · Spearfish, SDBuilt 1978 · S/N 17270975 N1373UWestberg Larry A · Milton, WIBuilt 1976 · S/N 17267044 N1373WGarces Manuel E · Jefferson, GABuilt 1963 · S/N 2654 N13740Gigax Steven G · Archbold, OHBuilt 1976 · S/N 17702465 N13741Rasmussen Tyler R · Independence, IAS/N 17262987

Back to AD 79-10-03 R2