Skip to content

Registered aircraft · 22,416

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:87-08-08-R3') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3') 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:87-08-08-R3')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
  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:87-08-08-R3')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:87-08-08-R3')
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.

N9697SMelton Aviation LLC · Allen, TXBuilt 2005 · S/N 3257409 N9698JWalters Max D · Lamar, MOBuilt 1967 · S/N 28-3887 N9698WCas Ltd · Swanton, VTBuilt 1967 · S/N 28-23171 N9699JTrevino Alberto O · Vero Beach, FLBuilt 1967 · S/N 28-3888 N969DBBristol David W · Sautee Nacoochee, GABuilt 1969 · S/N 28-26197 N969LAJackson Aviation Of South Georgia LLC · Thomasville, GABuilt 1967 · S/N 28R-30138 N969NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881923 N969SDThompson James R · Warren, OHS/N 28-7225045 N96DTPierson Richard R · Galesville, WIBuilt 1978 · S/N 28-7990230 N96ELJimenez-Cruz Juan C · Mayaguez, PRBuilt 1966 · S/N 28-3615 N96GCSky West Aviation Inc Trustee · Albuquerque, NMS/N 28R-7703190 N96JBSigman Bruce A · East Brunswick, NJBuilt 1969 · S/N 32-40722 N96KMijangos Adrian E · Mary Esther, FLBuilt 1977 · S/N 28-7725269 N96KCJws Aviation LLC · Easton, CTBuilt 1997 · S/N 3246087 N96MLM & M Aero LLC · Wilmington, DEBuilt 1978 · S/N 32-7940009 N96TBBeattie Thomas B · Vacaville, CABuilt 1976 · S/N 28-7690144 N96VAJak Real Estate LLC · Gorham, MEBuilt 1973 · S/N 28-7415052 N9701KEmory Christopher W · Lexington Park, MDBuilt 1976 · S/N 28R-7635257 N9701WGlougie Robert M · Fresno, CABuilt 1967 · S/N 28-23175 N9702CToledo Flying Club Inc · Toledo, WABuilt 1978 · S/N 28-7816519 N9704CAlon Guy · El Paso, TXBuilt 1978 · S/N 28-7890439 N9705JFjb Aviation LLC · Palestine, TXS/N 28-3895 N9707WBulger Edward P · Amesbury, MABuilt 1967 · S/N 28-23182 N9708JGautsch Michael J · Onalaska, WIBuilt 1967 · S/N 28-3899 N9709KLkn Cherokee LLC · Mooresville, NCBuilt 1976 · S/N 28-7625191 N9709WStewart Glen W · Lebanon, TNBuilt 1967 · S/N 28-23184 N970ACNaples Air Center Inc · Naples, FLBuilt 1980 · S/N 28-8116113 N970LCMajeste Air LLC · Loveland, COBuilt 1979 · S/N 28-8016214 N970WCCavorite Aviation LLC · Lehi, UTBuilt 2002 · S/N 2843522 N9710JThompson Stephen N · Hagerman, IDBuilt 1967 · S/N 28-3901 N9711WChapman Darren P · Winter Haven, FLBuilt 1967 · S/N 28-23186 N9712JBowers Nicholas M · Mount Hope, WIBuilt 1967 · S/N 28-3903 N9713WGiles Robert L · Columbia, SCBuilt 1967 · S/N 28-23189 N9715CBragg Larry M · Kansas City, MOBuilt 1978 · S/N 28-7816520 N9715JFly By Faith LLC · Laurel Springs, NCBuilt 1967 · S/N 28-3906 N9717CMiloud Chadd · Fort Worth, TXBuilt 1978 · S/N 28-7816522 N9717JCook Gardner · Sonoma, CABuilt 1967 · S/N 28-3908 N9719KDoco Engineering Inc · Red Bluff, CAS/N 28-7615232 N971ABPiper Aircraft Inc · Vero Beach, FLS/N 28010092 N971ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916188 N971CCarol Corp · Lincoln, NEFirst renewal noticeBuilt 1964 · S/N 28-20093 N971SEBrown Robert G · Tucson, AZBuilt 1969 · S/N 28-25492 N971UHVan Blarcom Richard J · Columbia X Rd, PAS/N 328106031 N971WCCavorite Aviation LLC · Lehi, UTBuilt 2002 · S/N 2843525 N9720CCooper Richard W Trustee · Indianapolis, INBuilt 1978 · S/N 28-7890440 N9720JSouthern Cloudcruisers LLC · Lexington, NCBuilt 1967 · S/N 28-3912 N9720KCooper Timothy Ray · Lincoln, CABuilt 1976 · S/N 28-7615233 N9720WCarnahan Thomas W J · Independence, MOBuilt 1967 · S/N 28-23197 N97219Deull Jonathan S · Cornwall, NYBuilt 1978 · S/N 327840131 N9721CFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28R-7837218

Back to AD 87-08-08 R3