Skip to content

Registered aircraft · 5,443

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

N9622CN9622c LLC · Clintondale, NYS/N 28-7816504 N9626CExecutive Flight Training & Services LLC · Sanford, NCBuilt 1978 · S/N 28-7816506 N9628KTriple Chin LLC · Bloomington, MNBuilt 1976 · S/N 28-7690266 N9629CFly Gateway Aviation Institute · New Castle, DEBuilt 1978 · S/N 28-7890430 N9629KN9629k LLC · Provo, UTBuilt 1976 · S/N 28-7690267 N962GCareer Pilot Training LLC · Wilmington, DEBuilt 2019 · S/N 2881227 N962WGChandler Air Services Inc · Chandler, AZBuilt 2000 · S/N 2843378 N962WWMindlin Frank August · New Haven, CTBuilt 2000 · S/N 2844022 N9631CThompson Joseph D · Alliance, NEBuilt 1978 · S/N 28-7890431 N9638CJones Francis P Jr · Newport, ARBuilt 1978 · S/N 28-7816507 N9639CNichols Brian J · Mount Hope, WIBuilt 1978 · S/N 28-7816508 N963ABPiper Aircraft Inc · Vero Beach, FLS/N 28010090 N963NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2025 · S/N 2881888 N963TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881963 N963WCCavorite Aviation LLC · Lehi, UTBuilt 2000 · S/N 2843381 N963WWCash Management Consulting LLC · Granite Springs, NYBuilt 2000 · S/N 2844023 N9642CBarts Flying Service Inc · Storm Lake, IABuilt 1978 · S/N 28-7816509 N964TFAir Fleet Holdings LLC · Missoula, MTBuilt 2025 · S/N 2881964 N964WCStardust Aviation LLC · Farmingdale, NYBuilt 2001 · S/N 2843462 N9658KFlying Particles Inc · Livermore, CABuilt 1976 · S/N 28-7690271 N965ACNaples Air Center Inc · Naples, FLBuilt 1989 · S/N 2841134 N9668CBrandywine Flight School Inc · West Chester, PABuilt 1978 · S/N 28-7816513 N9669CQuality Aero LLC · East Aurora, NYBuilt 1980 · S/N 28-8016361 N966DAJoye Richard · Huntsville, ALBuilt 1996 · S/N 2843054 N966NDUniveristy Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881924 N9671CFrench Loren · Gypsum, COS/N 28-7890435 N9674DSpace Coast Aircraft Co · Merritt Island, FLBuilt 1978 · S/N 28-7816583 N9676KEjs Enterprises LLC · Incline Village, NVBuilt 1976 · S/N 28-7690272 N967ABPiper Aircraft Inc · Vero Beach, FLS/N 28010091 N967GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881474 N967MSMt San Antonio College · Walnut, CABuilt 2023 · S/N 2881637 N9680CGregorski Thomas E · Kenly, NCBuilt 1978 · S/N 28-7816514 N9685CCendejas Agustin · Chino, CABuilt 1978 · S/N 28-7890436 N968WCOcr Enterprises LLC DBA · Long Beach, CABuilt 2001 · S/N 2843490 N9690CWindsock Inc · Red Wing, MNBuilt 1978 · S/N 28R-7837216 N969NDUniversity Of North Dakota · Grand Forks, NDBuilt 2025 · S/N 2881923 N96DTPierson Richard R · Galesville, WIBuilt 1978 · S/N 28-7990230 N96TBBeattie Thomas B · Vacaville, CABuilt 1976 · S/N 28-7690144 N9702CToledo Flying Club Inc · Toledo, WABuilt 1978 · S/N 28-7816519 N9704CAlon Guy · El Paso, TXBuilt 1978 · S/N 28-7890439 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 N9715CBragg Larry M · Kansas City, MOBuilt 1978 · S/N 28-7816520 N9717CMiloud Chadd · Fort Worth, TXBuilt 1978 · S/N 28-7816522 N971ABPiper Aircraft Inc · Vero Beach, FLS/N 28010092 N971ACNaples Air Center Inc · Naples, FLBuilt 1978 · S/N 28-7916188 N971WCCavorite Aviation LLC · Lehi, UTBuilt 2002 · S/N 2843525 N9720CCooper Richard W Trustee · Indianapolis, INBuilt 1978 · S/N 28-7890440 N9721CFlorida Aviation Career Training Inc · Saint Augustine, FLS/N 28R-7837218

Back to AD 2016-07-21