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.

N501MLVotava Paul A · Mcintosh, MNBuilt 1970 · S/N TH-72 N501MSDodson International Parts Inc · Rantoul, KSBuilt 1974 · S/N LJ-626 N501MZNovember501mikezulu LLC · Omaha, NEBuilt 1979 · S/N 5010298 N501NY501 Leasing LLC · Ocean Springs, MSBuilt 1977 · S/N 501-0038 N501NZPoussot Rodolphe · Malvern, PABuilt 1981 · S/N 501-0225 N501PJDiamond K Enterprises Inc · Caldwell, TXS/N 501-0111 N501PVJava Medical Group LLC · Nashville, TNBuilt 1977 · S/N 501-0028 N501QSmda LLC · Jefferson City, MOS/N 501-0233 N501RCAerodyne Holdings Inc · Crown Point, INBuilt 1980 · S/N 501-0165 N501RKCitation 501sp LLC · New Smyrna Beach, FLBuilt 1977 · S/N 5010024 N501RXRegistered aircraftBuilt 1978 · S/N 501-0060 N501SJMccann Michael Hal · Springfield, ORS/N 501-0071 N501SPN501sp LLC · Kalispell, MTBuilt 1977 · S/N 501-0039 N501STN501st LLC · Wintersville, OHS/N 501-0270 N501SVCalifornia Aviation LLC · Fresno, CABuilt 1977 · S/N 501-0005 N501SWTobar Services LLC · Hanover, MNBuilt 1985 · S/N 501-0689 N501TBJondu Services LLC · Roseville, CABuilt 1978 · S/N 501-0239 N501TPHargrove And Associates Inc · Mobile, ALBuilt 1984 · S/N 501-0684 N501WJN501wj LLC · Sylvania, OHS/N 501-0143 N501WLAlpha Bravo Charlie 1 Corp · Houston, TXBuilt 1979 · S/N 501-0135 N501XCrow Donald W · Shreveport, LABuilt 1982 · S/N 501-0255 N502APJbjp Capital Holdings LLC · Newark, DEBuilt 1984 · S/N BB-1187 N502BWRomero Leasing Inc · Stuttgart, ARBuilt 1992 · S/N E-2716 N502DADodson International Parts Inc · Rantoul, KSBuilt 1977 · S/N 21304 N502GVGrant Aviation Inc · Anchorage, AKS/N 208B5249 N502SAZambrano Homero Ramones · Bulverde, TXBuilt 1978 · S/N 421C0520 N502SVCryptologistics Of America Inc · Southwest Ranches, FLBuilt 1985 · S/N 502 N5036M66ee LLC · Santa Barbara, CABuilt 1978 · S/N E-1255 N503AWCsi Aviation Inc · Albuquerque, NMBuilt 1995 · S/N BB-1514 N503BAP&B Aviation Corp · Wilmington, DES/N TH-862 N503CBCtb Inc · Goshen, INBuilt 1982 · S/N LJ-997 N503DETvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2016 · S/N FL-1051 N503JMDls Aviation LLC · Gilmer, TXBuilt 1980 · S/N BB-712 N503LMBig Sky LLC · Draper, UTBuilt 1997 · S/N FL-182 N503MKJay Bruber LLC · Saint Paul, MNBuilt 2016 · S/N 208B5342 N503PWellsprings Aviation LLC · Winston Salem, NCBuilt 1979 · S/N BB-437 N503RMKa200 LLC · Jacksonville, NCBuilt 1980 · S/N BB-673 N504CBPlane Leasing LLC · Wilmington, DEBuilt 1974 · S/N LW-125 N504CCFirst Port Air Inc · Omaha, NEBuilt 1999 · S/N 560-0504 N504ECAlpha Tango LLC · Little River, SCBuilt 1995 · S/N BE-120 N504GFOxford Advisory Aviation LLC · Orlando, FLBuilt 1983 · S/N BB-1156 N504PWide Open Management Services LLC · Winston Salem, NCBuilt 1993 · S/N 525-0026 N504RWYingling Aircraft LLC · Wichita, KSS/N 560-0352 N504SFShb Aviation LLC · Indianapolis, INS/N 501-0643 N504SJAmerican Bonanza Society Air Safety Foundation Inc · Wichita, KSBuilt 1981 · S/N E-1849 N504SVLa Babia K A LLC · San Antonio, TXBuilt 2015 · S/N FL-1025 N504TAviationiq LLC · Helena, MTBuilt 1994 · S/N 650-7040 N504USunshine Airways Of N O LLC · New Orleans, LABuilt 2004 · S/N 560-0665 N504WFTito Enterprises LLC · Cameron, MTBuilt 2022 · S/N 525-1118 N504WJVantage Air Corp · Kalispell, MTBuilt 1976 · S/N 503

Back to AD 2006-16-18 R1