Skip to content

Registered aircraft · 5,458

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.

N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186 N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920 N101KWWiseman Ken L DBA · Calhoun, GABuilt 1980 · S/N 28-8016310 N101LLTribeca Aviation LLC · New York, NYBuilt 2000 · S/N 2843367 N101VPN101vp LLC · Ambler, PABuilt 1976 · S/N 28-7790131 N1024QDuroc LLC · Watertown, WIBuilt 1977 · S/N 28-7790370 N1029HRegistration Pending · Bulverde, TXRegistration pendingS/N 28-7790278 N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081 N102PFKaehr Lyle · Decatur, INBuilt 1984 · S/N 28-8490042 N1036QKelley Michael · Bellingham, MABuilt 1977 · S/N 28-7716079 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N103SAHolman Steven R · Vero Beach, FLBuilt 1983 · S/N 28-8416012 N1041QSwaz Aviation LLC · Mesa, AZBuilt 1977 · S/N 28-7716081 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 N1047MChristiansen Aviation LLC · Wilmington, DEBuilt 2007 · S/N 2842286 N104AAMeridian Aircraft LLC · Wilmington, DEBuilt 2022 · S/N 2881573 N104DHPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 2881999 N104EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2007 · S/N 2844135 N104FGWilson Conrad · Bowdon Junction, GAS/N 28-7716292 N104VADulles Aviation Inc · Bristow, VABuilt 2001 · S/N 2842115 N1059FRandag William F Jr · El Paso, TXS/N 2843643 N105AVAbbey Air Corp · New Castle, PABuilt 1983 · S/N 28-8490012 N105DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881910 N105HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881996 N1063LWjm Aviation LLC · North Wales, PABuilt 2006 · S/N 2843644 N106BCUniversidad Interamericana De Puerto Rico · Bayamon, PRBuilt 2003 · S/N 2843582 N106DJDelta Juliet Holco I LLC · Ocoee, FLBuilt 2025 · S/N 2881911 N106EMVenture West LLC · Mesa, AZBuilt 1977 · S/N 28-7790460 N106FMGroner Michael F · Hicksville, NYBuilt 1978 · S/N 28-7990199 N106HPAgain2 · San Diego, CABuilt 2003 · S/N 2843560 N106PESheboygan Flying Club LLC · Sheboygan, WIBuilt 1977 · S/N 28R-7837088 N1071CBmk Aviation LLC · Northampton, PABuilt 2006 · S/N 2843648 N1075RGeorgia Aviation Authority · Eastman, GABuilt 2006 · S/N 2843649 N1076QExecutive Flight Institute LLC · Murrieta, CABuilt 1977 · S/N 28-7790374 N107MRMeriden Aviation Center LLC · Meriden, CTBuilt 1977 · S/N 28-7816251 N107NDN107nd LLC · Wilmington, DEBuilt 1989 · S/N 2841214 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997 N108NDMavity Michael D · Phoenix, AZBuilt 1990 · S/N 2841328 N10958Aero Quest LLC · Olive Branch, MSBuilt 2025 · S/N 28020251 N109GPCash Management Consulting LLC · Granite Springs, NYBuilt 1977 · S/N 28-7816287 N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292 N110LMGo Vertical Aviation LLC · Russellville, ALBuilt 1979 · S/N 28-7990277 N110VPFly Aviation Corp · Wilmington, DEBuilt 1977 · S/N 28-7716189 N11132Triple One 32 LLC · Sergeant Bluff, IABuilt 1995 · S/N 2890230 N1113ULeft Base Aviation LLC · Niagara, WIBuilt 1989 · S/N 2890126 N1118QAscend Aviation LLC · Bountiful, UTBuilt 1977 · S/N 28-7716083

Back to AD 2016-07-21