Skip to content

Registered aircraft · 6,801

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-13-03') 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-13-03') 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-13-03')
    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-13-03')
  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-13-03')
  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-13-03')
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.

N1007LPlane Fun Inc Tr Trustee · Snellville, GAS/N 28R-7703403 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100LGFlyd Pipers Inc · Dyer, INBuilt 1980 · S/N 28-8011113 N100MSHam Aviation LLC · Marydel, DEBuilt 1977 · S/N 28-7890186 N100WQCarolina Queen Inc · Oak Ridge, NCBuilt 1981 · S/N 28R-8131116 N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172 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 N101RTBrodine Alan H · Rochester, NYBuilt 1979 · S/N 28R-8018009 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 N103CCWhatley Wesley E · Plano, TXBuilt 1979 · S/N 28R-7918055 N103KCLang Elmer N · Hemphill, TXBuilt 1979 · S/N 28-7911238 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 N1047QTaras Brock DBA · Cedaredge, COBuilt 1977 · S/N 28R-7703049 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 N1056HBrown Danny Joe · Skidmore, MOS/N 28R-7703011 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

Back to AD 79-13-03