Skip to content

Registered aircraft · 40,473

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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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:80-04-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.

N6157WLaminar Skies Aviation LLC · Broken Arrow, OKBuilt 1964 · S/N 28-20176 N61581Brat Equipment Co LLC · Slinger, WIBuilt 1975 · S/N 17264655 N61585Mele Michael L · Fairview, ORBuilt 1975 · S/N 17264658 N61586Evalt Ralph D II · Dillingham, AKS/N 17264659 N61588L&W Aircraft Investment LLC · Homestead, FLBuilt 1975 · S/N 17264661 N6158GCag Aircraft Holdings LLC · Crystal River, FLBuilt 1979 · S/N 17273573 N61594Hawk Aviation Inc · Rush City, MNBuilt 1975 · S/N 17264664 N6159DDavis James J · Beaver Dam, WIBuilt 1957 · S/N 22-4806 N6159JSmathers James R Jr · Mission Viejo, CABuilt 1976 · S/N 28-7615316 N6159RBagamaspad Alan M · Reseda, CABuilt 1979 · S/N 172RG0098 N6159WSale Reported · San Luis Obispo, CASale reportedBuilt 1964 · S/N 28-20178 N615FTFlorida Institute Of Technology · Melbourne, FLBuilt 1980 · S/N 28-8116123 N615MADowling Thomas · Mechanicville, NYBuilt 2004 · S/N 1372-2004 N615PMMcclanahan Luke D · Midland, TXBuilt 1993 · S/N MK0051 N615WTOwensby Paul T · Fayetteville, NCBuilt 1968 · S/N 17257421 N61605Blake Ernest Ronald · San Jose, CABuilt 1975 · S/N 17264670 N61606Swafford Charles T · Humble, TXBuilt 1975 · S/N 17264671 N61607Maier Dennis J · Morristown, SDBuilt 1975 · S/N 17264672 N6160JKirby Alan F · Imperial, MOBuilt 1976 · S/N 28-7615317 N6160WSteinsvik Magne · Seattle, WABuilt 1964 · S/N 28-20056 N61610Sugarpine Skies LLC · San Jose, CABuilt 1973 · S/N 17261367 N61615High Flight Academy LLC · Allison Park, PABuilt 1975 · S/N 17264677 N6161VWorkman Lonnie H · Farmington, ARBuilt 1964 · S/N 28-20161 N6161WCarlson Darrin E · Clay Center, KSBuilt 1964 · S/N 28-20179 N61622Lexington Flying Club · Richmond, KYBuilt 1975 · S/N 17264681 N61625Chapline Curtis · Cypress, TXBuilt 1975 · S/N 17264683 N61628Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1974 · S/N 17264684 N6162WEvans Stephen M · Vashon, WABuilt 1964 · S/N 28-20180 N61630Jerome Pester Farms Inc · Hingham, MTBuilt 1975 · S/N 17264685 N61631Jones Donald T Jr · Barrigada, GUBuilt 1975 · S/N 17264686 N61633Rotor Spec Aviation LLC · Fort Lauderdale, FLBuilt 1975 · S/N 17264688 N61635Meridian Aero Club Inc · Midland, MIBuilt 1975 · S/N 17264690 N61637Amelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 17264691 N6163DBistline John A · Cedar City, UTBuilt 1957 · S/N 22-4810 N6163FVagabond Flying Association · Winfield, ILBuilt 1979 · S/N 17273157 N6163WLang Michael R · Cedar Key, FLBuilt 1964 · S/N 28-20181 N61640Cooper Michael A · Rohnert Park, CABuilt 1975 · S/N 17264694 N61641Handzo Anthony J · Roseville, ILBuilt 1975 · S/N 17264695 N61642N61642 LLC · Lowell, MIBuilt 1975 · S/N 17264696 N61643Spence Stephen E · Mancelona, MIBuilt 1975 · S/N 17264697 N61645Lima-001 LLC · Muscatine, IABuilt 1975 · S/N 17264698 N6164DSeligson Andrew · Tuckahoe, NYBuilt 1957 · S/N 22-4811 N6164FBlue River Aviation LLC · Palmer, AKBuilt 1979 · S/N 17273158 N6164WSmith Steve W · Elizabethtown, KYBuilt 1964 · S/N 28-20182 N61655Air Planes LLC · Soddy Daisy, TNBuilt 1975 · S/N 17264704 N61656Dismang Chad C · Boynton, OKS/N 17264705 N61657Bell Ornithopters Flying Club Inc · Eastlake, COBuilt 1975 · S/N 17264706 N61658Nationwide Aviation LLC · Hudson Oaks, TXBuilt 1975 · S/N 17264707 N61659Bowerman Richard E · Wetmore, MIBuilt 1975 · S/N 17264708 N6165WSommers Wesley A · Kiana, AKBuilt 1964 · S/N 28-20183

Back to AD 80-04-03 R2