Registered aircraft · 44,877

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-10-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:2006-10-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:2006-10-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:2006-10-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:2006-10-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:2006-10-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.

N1000PJames Bond Aviation LLC · Belgrade, MNBuilt 1963 · S/N 28-1000 N1001WRight Downwind Inc · Ropesville, TXBuilt 2006 · S/N 60208 N10020Stephens David Sr · Plains, MTBuilt 1995 · S/N 20044C N1002GFlying Fox Aviation LLC · Idaho Falls, IDBuilt 2000 · S/N 27-0295 N1002HSmith Michael S · Anchorage, AKBuilt 1997 · S/N 23038C N1002NMobley John E · Newark, ARS/N 21005C N1002SKucel R Scott · Dallas, TXBuilt 1995 · S/N 20056C N10033Thunderfighter LLC · Englewood, COS/N 172S9797 N10039Vanderpool Wayne R · Adams, NYS/N 22275 N1004DGiezen Jurgen J · Fairfax, VAS/N 26001C N1004EUnison Air LLC · Palo Alto, CABuilt 2005 · S/N 172S9872 N1005ESemaska Victor J · Kensington, CTBuilt 1977 · S/N 299-77 N1005LO'Neal Gregory A · Saint Cloud, FLBuilt 1960 · S/N 248 N1005XSigler Lanny · Albuquerque, NMBuilt 2000 · S/N 27-0302 N10069Silvestri Leonardo · Ellicott City, MDBuilt 1996 · S/N 20050C N1006ESpot-Air LLC · Burlington, TXBuilt 1977 · S/N 244-77 N1006QMills James A · Dearborn, MIBuilt 1979 · S/N PS-1 N1006VLanier Equipment Leasing LLC · Gainesville, GABuilt 2005 · S/N 172S9805 N1007CVee Two Inc · Merritt Island, FLBuilt 1992 · S/N 10089 N1007UKallam Jerry · Palmer, AKBuilt 1998 · S/N 23047C N1007VSmith Loren Dallas · Great Falls, MTS/N 73-31060 N1008CBat Flying LLC · Blue Earth, MNBuilt 1981 · S/N 24-1100 N1008KAu Jerry · Manhattan Beach, CAS/N 10168 N1008WRay Jonas · Palmer, AKS/N 23022C N1009EAven Michael D · Georgetown, INBuilt 1977 · S/N 606-77 N1009XEnders Richard A · San Bernardino, CABuilt 1975 · S/N 28-7505194 N100AESale Reported · Spencer, NESale reported, pending cancellationBuilt 1978 · S/N 32R-7985058 N100BHChopper Aviation LLC · Cahokia Heights, ILBuilt 1958 · S/N TD-130 N100BJAllen David L · Eastpoint, FLBuilt 1966 · S/N 32-40077 N100BSC & C Logging LLC · Kelso, WABuilt 1966 · S/N 27-3431 N100BUJav Aviation LLC · Landenberg, PABuilt 1997 · S/N 19 N100CNAileron Aviation Inc · Sparta, TNS/N 27-7754050 N100CWCoffin Craig T · Glendale, CABuilt 1979 · S/N 1 N100DDCook Allen J · Aurora, COBuilt 1948 · S/N NAV41518 N100EEConcho Aviation LLC · Sterling City, TXBuilt 2006 · S/N 11028 N100ELLeading Edge Leasing LLC · Wilmington, DES/N 310Q-0688 N100EMKentem100 LLC · Asheboro, NCBuilt 1981 · S/N 31-8152196 N100ENRegistration Pending · Downingtown, PARegistration pending, pending cancellationS/N 816 N100EUSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2021 · S/N 28020030 N100GLWaco Aircraft Corp · Battle Creek, MIBuilt 2021 · S/N 1215 N100GQUsda-Aphis-Ws · Cedar City, UTBuilt 2010 · S/N CC18-0041 N100GSPegasus Florida I Inc · San Diego, CABuilt 1974 · S/N P-301 N100HRSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1968 · S/N 28-4509 N100HUSimpson Jared S · Malad City, IDBuilt 1996 · S/N 1319 N100HWYale Companies LLC · Fishers, INBuilt 2025 · S/N 2881884 N100JEResearch Consultant Solutions LLC · Miami, FLBuilt 1969 · S/N 28-5489 N100JGClub Cherokee Inc · Crystal, MNBuilt 1988 · S/N 3213019 N100JRLumland Properties LLC · Winchester, VABuilt 1969 · S/N 31-599 N100JVKremers Gary · Zeeland, MIBuilt 2012 · S/N 40992 N100KYRegistration Pending · Weston, FLRegistration pendingBuilt 1987 · S/N 901

Back to AD 2006-10-21