Registered aircraft · 4,730

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:2024-10-04') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2024-10-04') 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:2024-10-04')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2024-10-04')
  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:2024-10-04')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2024-10-04')
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 N1019TAndrew University · Berrien Springs, MIBuilt 2006 · S/N 4496232 N101FMN101fm Inc Trustee · Wilmington, DES/N 3433153 N101HWYale Companies LLC DBA · Fishers, INBuilt 2025 · S/N 2881920 N101LLTribeca Aviation LLC · New York, NYBuilt 2000 · S/N 2843367 N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066 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 N102DHPiper Aircraft Inc · Vero Beach, FLBuilt 2025 · S/N 4496597 N102EREmbry Riddle Aeronautical University · Daytona Beach, FLBuilt 2002 · S/N 2844081 N102PFKaehr Lyle · Decatur, INBuilt 1984 · S/N 28-8490042 N103AVFlying To Infinity And Beyond LLC · Atlanta, GABuilt 1983 · S/N 28-8390084 N1043QRegistered aircraftBuilt 1977 · S/N 28R-7737025 N1045Paragon Airplane Leasing Co · Fort Myers, FLBuilt 2024 · S/N 28020177 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 N104WTFour Whiskey Tango LLC · Grosse Pointe Park, MIBuilt 2004 · S/N 3449301 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 N10691Reed Kerr Aviation Inc · Wilmington, DEBuilt 1984 · S/N 34-8433050 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 N1080UBoard Of Regents Of The University Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020231 N108HWYale Companies LLC DBA · Fishers, INBuilt 2026 · S/N 2881997 N10958Aero Quest LLC · Olive Branch, MSBuilt 2025 · S/N 28020251 N109LDEast Bay Flight LLC · Alameda, CABuilt 1979 · S/N 28-7990292 N10DRFlying W LLC · Camden, DEBuilt 1994 · S/N 3448044 N110GGSkyview Aviation LLC · Tracy, CABuilt 2024 · S/N 3449486 N110LMGo Vertical Aviation LLC · Russellville, ALBuilt 1979 · S/N 28-7990277 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N11132Triple One 32 LLC · Sergeant Bluff, IABuilt 1995 · S/N 2890230 N1113ULeft Base Aviation LLC · Niagara, WIBuilt 1989 · S/N 2890126 N111AZ360 LLC · Carson City, NVFirst renewal noticeBuilt 2000 · S/N 28-43311 N111EMMccue Inc · Florence, MTBuilt 1985 · S/N 28-8690042 N111WMMoore Forrest · Liberty Hill, TXBuilt 1978 · S/N 28R-7837159 N1126HHead Lewis T · Portland, TNBuilt 1976 · S/N 28-7790286

Back to AD 2024-10-04