Registered aircraft · 11,798

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

N711LFlorida Aero Services S D · Brandon, FLBuilt 1984 · S/N LA-222 N711LTBlue Skies Aviation Of Daytona Inc · Ormond Beach, FLBuilt 1993 · S/N 6500232 N711PRDaniel Dewey · Okeechobee, FLBuilt 1974 · S/N E-608 N711THTri-County Sprayers Inc · Hamlin, TXS/N E-246 N711UFDodson International Parts Inc · Rantoul, KSBuilt 1984 · S/N 421 N711UST J Mccarthy Management LLC · Dallas, TXBuilt 1998 · S/N 560-0470 N711VASilver Circuit Investments LLC · Palm Beach Gardens, FLBuilt 2026 · S/N 525-1411 N711VNKa350 N711vn LLC · Plano, TXBuilt 1990 · S/N FL-7 N711VSMilne Jeff J · Lake Geneva, WIBuilt 1975 · S/N E-756 N711VVMaynard Aviation LLC · Westfield, MABuilt 1990 · S/N BB-1365 N711WGCinco Aviation LLC · Hobbs, NMBuilt 2001 · S/N 525-0424 N711XSSteiner Gp LLC · Weatherford, TXBuilt 2004 · S/N 560-0678 N7125NKsnl Aero LLC · Shawnee, OKBuilt 2015 · S/N 208B5235 N712FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0435 N712GDOsborne David · Texarkana, ARBuilt 1980 · S/N TH-1107 N712JDCpch Aviation LLC · Jacksonville, FLS/N 421C0908 N712JZHeffley Brothers Flying Circus LLC · Benbrook, TXBuilt 1975 · S/N TH-671 N712RHBtr Air Charter-Ka LLC · Baton Rouge, LAS/N BB-1839 N7131Van Dyke Bryan C · Wichita, KSBuilt 1997 · S/N E-3093 N7135GRegistered aircraftBuilt 1977 · S/N 421C0284 N713BBWilmington Trust Co Trustee · Wilmington, DEBuilt 2022 · S/N FL-1302 N713CBCaravan Charters LLC · Richmond, VABuilt 2005 · S/N 208B1106 N713FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0438 N713JDCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1978 · S/N 501-0075 N713RHFalcon Air LLC · Olive Branch, MSBuilt 1987 · S/N BB-1274 N713WLOx Aviation LLC · Lewes, DEBuilt 2008 · S/N 560-0798 N71411United Airlines Inc · Chicago, ILBuilt 2002 · S/N 30128 N714BMMurphy Randall · Ruston, LABuilt 2000 · S/N E-3345 N714DSPhoenix Air Group Inc · Cartersville, GAS/N 488 N714LMR & B Aviation LLC · Columbia, MOBuilt 2023 · S/N 525-1139 N714MHFkm King Air LLC · Newport Beach, CABuilt 1991 · S/N FL-48 N715BCSkinner Edward Mcgregor · LondonBuilt 1975 · S/N E782 N715FXFederal Express Corporation · Memphis, TNBuilt 1995 · S/N 208B0440 N715HETatonduk Outfitters Ltd DBA · Fairbanks, AKBuilt 1997 · S/N 208B0603 N715JCFlying Farmer LLC · Wilmington, DEBuilt 1977 · S/N 99 N715LALongbow Aviation LLC · Fernandina Beach, FLBuilt 1999 · S/N 258441 N715LHRcb Bank · Claremore, OKBuilt 2013 · S/N FL-844 N715LLTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 208B5876 N715LTTraveler LLC · Fort Stockton, TXBuilt 1998 · S/N E-3205 N715MGRichard L Richards Pa Trustee · Coral Gables, FLS/N 003 N715RDHalls Aviation LLC · Charleston, SCBuilt 1980 · S/N BB-707 N7166KKellar John C · Runaway Bay, TXBuilt 1975 · S/N TH649 N716APButler Aviation Inc · Houma, LABuilt 1978 · S/N BB-448 N716ATSivu Transportation LLC · Anchorage, AKBuilt 2024 · S/N 208B5828 N716AVMas Trailers LLC · Dalhart, TXS/N BB-1876 N716BMTraveling Toes LLC · Wilmington, DEBuilt 1993 · S/N FL-103 N716BRTiburon Aviation II LLC · Dallas, TXBuilt 1996 · S/N 560-0355 N716DBCervenka Debra A · Santa Rosa Beach, FLBuilt 2002 · S/N 258568 N716DDS2 Air LLC · Las Vegas, NVS/N S550-0120 N716DJN716dj LLC · Kentwood, MIBuilt 2021 · S/N 525-1087

Back to AD 2006-16-18 R1